Resources

Recent Speaking Engagements

Doggoneit! Why is my Cost Rollup Taking So Long and Why Do I have So Many Item Cost Problems? January 22, 2023
Is your Oracle EBS Discrete Supply Chain Cost Rollup taking FOREVER? Over four hours, perhaps eight or more hours? Wanna figure out why? And are your Cost Rollup results difficult to understand? Rolling up to a zero cost? Duplicating item costs? What is with the Buy vs. Make vs. Based on Rollup controls and how does this affect the Cost Rollup results?

Find out how you can gain better visibility over your Supply Chain Cost Rollup, with quicker results and fewer errors. Learn from the experiences gained over the past twenty years using the Supply Chain Cost Rollup and how you can easily apply these “lessons learned” to your situation.  I've create a special presentation to help you learn about potential issues and solutions for your Cost Rollup results.  For more information please see Doggonit! Why is my Cost Rollup Taking So Long and Why Do I Have So Many Item Cost Problems?

Cost Accounting for Oracle EBS – Blitz Report version 3.2.6, April 27, 2023
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 please see Cost Accounting Reporting for Oracle EBS.

OATUG Cost Management Special Interest Group, March 27, 2023
Gotchas with Oracle EBS Release 12 Purchase Price Variances

For Standard Costing, for purchase price variance, what is the best way to set up Oracle R12 EBS? Especially for Oracle General Ledger, Oracle Payables and Purchasing given the recent, crazy fluctuations in USD versus EUR, GBP (and other currencies). Find out how configuration settings such as "Match on PO", vs. Match on Receipt" affect the outcome. And how choosing the correct functional currency for your operations has such a large impact to PPV amounts. Is there better reporting available for PPV? And how does FASB 830 affect the definition and recognition of FX Gain and Loss? Learn from recent client experiences and discover different approaches on how to best deal with Purchase Price Variances..  For more information see this presentation:  Gotchas with Oracle EBS Release 12 Purchase Price Variances.

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/Ascend, 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, Cost Management SIG March 2022)

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 and OATUG Cost Mgmt SIG Oct 2022)

Cost Rollup:

• Supply Chain Oracle Cost Rollup, What Works, What Doesn't?
     (OATUG Cost Management SIG May 2012)
• Doggonit! Why is my Cost Rollup Taking so Long and Why do I Have so Many Item Cost Problems? (OATUG Cost Management SIG, Oct 2023)
  

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)

Cost Management Reporting:

• Simple And Effective Cost Accounting Reporting for the Oracle E-Business Suite
     (Cost Management SIG February 2023)

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:

• Cloud and EBS Costing, You Can Track & Eliminate Profit in Inventory
     (Collaborate18 April 2018, OATUG Cost Management SIG June 2021)
• 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, OATUG Cost Mgmt SIG, November 2022)
  
• Gotchas with Oracle EBS Release 12 Purchase Price Variances
     (OATUG Cost Management SIG, April 2023)
• 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...