Resources

Recent Speaking Engagements

OATUG Cost Management Special Interest Group, February 27, 2023
Simple And Effective Cost Accounting Reporting for Oracle EBS

Over the years I've given several SQL reporting scripts to the Oracle Community, for reconciling inventory to the G/L, summary and detail transaction reports, inventory value reports and even multiple-ledger period open/close status reports. But in order for your Cost Accountants and staff to use them you had to take these SQL scripts and develop these reports using your own technical reporting tools, such as Oracle's BI Publisher. Now, in partnership with Enginatics, I've published over 90 fully configured Cost Accounting Reports, ready to use as soon as you install Blitz Report. With parameters that automatically default, such as transaction date ranges, period names, organization codes, and ledgers. Multi-org reports which naturally download into native Microsoft Excel. For most Oracle EBS configurations, including Project Manufacturing (PJM) and Warehouse Management (WMS), and even when using Category Accounting.  For more information see:  Blitz Report for Cost Accounting.

East Coast Oracle Conference 2022, November 9, 2022
New Features for EBS Release 12.2.11: Returns on Internal Sales Orders

Is your firm using internal requisitions with internal sales orders (also known as IR/ISO)? Ever want to do a “return to vendor” on an internal order, just like you do for external suppliers? With the ability to reverse the original IR/ISO? Now you can, with the new Release 12.2.11 feature for returns on internal sales orders.  For more information see this presentation:  EBS Returns on Internal Orders.

AUSOUG Webinar Series 2022, June 22, 2022
EBS Discrete WIP Variances, How to Overcome the Confusion!

Having difficulty understanding Oracle EBS Discrete WIP variances?  Can’t make heads or tails of the WIP job close variances?  How are these variances calculated?  How to read the Discrete Job Value Report for Standard and Average Costing?  What are resource efficiency variances?  Material usage variances?  And what about configuration and methods variances?  Doug explained how you can go beyond what the standard Oracle reports has to offer and how you can quickly analyze your WIP jobs.  Doug described the advanced manufacturing variance reports available from Enginatics and Blitz Report, which are applicable to both Oracle Release 11i and 12.  For more information see this presentation:  EBS Discrete WIP Variances, How to Overcome the Confusion!.

OATUG Cost Management Special Interest Group

As part of Doug's commitment to the Oracle Applications Technology User Group (OATUG) he has led the OATUG Cost Management Special Interest Group (SIG) since 2007.  In these monthly webinars Doug and other expert presenters give practical advice on using Oracle Cost Management, showcasing new products and collectively, helping each other do more with the Oracle Applications. Oracle Cost Development and Oracle Support also participate in these discussions and actively engage with the Cost Management SIG for feedback on product features and directions.  Doug has been organizing these webinars since 2007, with topics such as A/P accruals, profit in inventory, change management, new features, and inventory reconciliation.  For more information email Doug at Doug@Volzconsulting.com or visit the OATUG Cost SIG web site at OATUG Cost Management SIG.

OATUG, Collaborate, OpenWorld, UKOUG Presentations

A/P Accruals:

• A/P Accruals for Oracle Release 12
     (OATUG Cost Management SIG April 2011)
• (R12) Resolve Your Inventory A/P Accrual Issues Now! Even for Intercompany Internal Orders and Consignment (Collaborate17 April 2017)
• (R11i) How to Setup, Use, and Balance Your Oracle A/P Accrual Accounts for Manufacturing and Distribution companies
     (Fall 1996, Spring 1997 US OAUG conferences)
• (R11i) How to Setup and Use Your Oracle A/P Accruals
     (NorCal OATUG Training Day Jan. 2009, Collaborate08 April 2008)

Change Your Cost Methods Without Re-implementing:

• Costing Methods:  Who Said Changing Cost Methods with Discrete
     Costing Can't be Done?  (Collaborate16 April 2016)

Cloud Costing vs. EBS Costing:

• Cloud Costing Comparison and Setup: How Does Oracle Cloud Costing
     Stack Up Against Oracle EBS Costing?
    (Collaborate19 April 2019, OATUG Cost Mgmt SIG September 2018)
• ERP Structures in the Cloud (Ascend22)

Cost Rollup:

• Supply Chain Oracle Cost Rollup, What Works, What Doesn't?
     (OATUG Cost Management SIG May 2012)

Costing Tips and Tricks:

• Tips and Tricks for Oracle EBS Cost Management
     (OATUG Cost Management SIG, January 2019)
• Costing Tips and Tricks:  More Tips for Oracle Cost Management
     (OATUG Cost Management SIG, February 2011)
• (R11i) Costing Tips and Tricks:  Make Oracle Cost Management Work for You!
     (NorCal OATUG Training Day Jan. 2008, UKOUG Dec. 2007)

Cost Management & Subledger Accounting (SLA):

• How to Create Shipping Burdens for Oracle Cost Management
     (Collaborate14 April 2014)
• Subledger Accounting for Oracle Discrete & EAM Cost Accounting: Product Line, EAM and Expense Accounting Made Easy Through SLA
      (Collaborate13 April 2013, UKOUG October 2013)
• Cost Accounting As You Want It - Oracle R12 Cost Accounting with SLA
     (UKOUG Dec. 2009, Collaborate09 May 2009, NorCal OAUG Jan. 2009)
• Cost Accounting with Oracle EBS  Release 12 Subledger Accounting
     (Oracle OpenWorld September 2008)

Discrete & Process Cost Accounting Integration:

• We Can Create Combined Oracle Cost Accounting Reports for Both Discrete and Process Manufacturing!  (Collaborate15 April 2015)

Inventory Reconciliation, Interfaces and Period Close Tips:

• Period Close:  Managing Reconciliation in Manufacturing and Distribution Organizations (Collaborate17 April 2017)
• Inventory to General Ledger Reconciliation for Oracle
     (Collaborate14/11, UKOUG 2011, NorCal Training Day 2011, East Coast Oracle Conference 2022)
• Can We Actually Reconcile Oracle Project MFG to Inv., WIP, Projects & G/L?
     (Collaborate10 April 2010)
• E-Gads!  How in the Dickens Do I Manage the Oracle Month-End Interfaces?  (Collaborate12 April 2012, OATUG NorCal Training Day Aug-2012)
• How to Manage the Inventory and Manufacturing Period Close and Remain Sane…  (Collaborate16 April 2016)
• (R11i) How to Reconcile Your Oracle Manufacturing Accounting
     (Fall 1998 US OATUG, OATUG Cost Mgmt SIG 1999 – 2001)

Periodic Costing

• Periodic Costing: Want to Know Your Average Costs? Run Periodic Costing Alongside Your Costing Method! (OATUG Cost Management SIG Sept 2016)

Profit in Inventory Solutions:

• INTL: Cloud and EBS Costing, You Can Track & Eliminate Profit in Inventory
     (Collaborate18 April 2018)
• Does Oracle Rel. 12 Solve Global Issues for Profit in Inventory and COGS?
     (Collaborate10 April 2010)
• Profit in Inventory with Oracle EBS  (OATUG Cost Mgmt SIG Sept 2010)

Transactions and Variances:

• COGS Accounting Solutions for Trade and Intercompany Sales
     (OATUG Cost Mgmt Webinar May 2017 and NWOUG September 2017)
• Cost Update Challenges for Oracle (Release 11i)
     (OATUG Cost Management SIG, October 2008)
• EAM Costing, How Is It Different from Oracle MFG Costing?
     (OATUG Cost Management SIG October 2014)
• EBS Discrete WIP Variances, How to Overcome the Confusion!. 
      (AUSOUG Webinar Series 2022, June 2022)
  
• EBS Returns on Internal Orders.
     (East Coast Oracle Conference 2022, November 2022)
  
• How to Setup, Transact and Use Outside Processing
     (OATUG Cost Management SIG May 2014)
• InterCompany – Fulfillment Delivery Options - an Oracle DropShip Example
     (Collaborate13 April 2013)
• Manufacturing Variances for Oracle EBS
     (OATUG Cost Management SIG  October 2009)
• Overview of Oracle Discrete Costing for Manufacturing
      (OATUG Discrete MFG SIG Nov. 2010)
• Receiving as it Relates to Oracle Cost Management
     (OATUG Cost Management SIG June 2011)
• Ship to Invoicing Oracle Transaction Flows:Tracing a Sale Through Inventory
     (OATUG Cost Management SIG May 2011)
• You Can Close Thousands of Discrete Jobs Safely Each Month!
      (OATUG Cost Management SIG, October 2018)

Other Related Presentations:

• Blitz Report for Cost Accounting  (OATUG Cost Mgmt SIG February 2023)
  
• Change Management is So Important  (Collaborate09 May 2009)
• Cost Allocations:  Different Ways to Use Oracle EBS Cost Elements, Sub-Elements and Cost Allocation Methods  (OATUG Cost Mgmt SIG April 2011)
• Don’t Forget Your Business Processes! Oracle Can’t Do it All for You
     (APPSWORLD January 2004, US OATUG Fall 2003)
• Is Oracle Release 11i Ready for Production?  (Fall 2000 UKOUG)
• Major Tables & Relationships for Oracle EBS Costing
     (OATUG Cost Management SIG April 2010)
• Manufacturing Accounting by Product Line for Oracle Release 11
     (Spring 1999 US OAUG)
• What's New in Oracle Release 12 – the Changes that Matter
      (Collaborate13 April 2013)
• Why Upgrade to Oracle Release 12 Costing - What's In it for Me?
      (OATUG Cost Management SIG July 2010)

Useful Links

• Oracle Application & Technology Users Group (OATUG)
• OATUG Cost Management SIG
• Australia Oracle User Group (AUSOUG)
• UK Oracle User Group (UKOUG)
• My Oracle Support (MetaLink)
• Enginatics – Blitz Report:  Simple, Fast Excel Reporting for Oracle EBS
• eprentise – Transformation Software for the Oracle E-Business Suite
• More4Apps – Excel Into Oracle

As part of Doug's philosophy for helping the Oracle community, Douglas Volz Consulting has presented numerous times at Oracle Application conferences. These papers are available here for your use and include practical tips and suggestions. Feel free to contact Doug with questions.

Sample participant comments from recent conference and webinar presentations:  

"Good morning Doug, First of all I want to make my compliments for your hard work and your “class”.  I was your “FAN”, I studied a lot of your White Papers and Presentations, and finally, yesterday, I saw you in Action… Amazing…"

"Thank you, Doug. Your sql will definitely be very handy! BTW, excellent webinar…contents were excellent and your presentation skills were really good. I look forward to attending your next webinar."

Contact us...