DCOGS balance breakup (SO/RMA wise) and Diagnostic in OPM Financials
(Doc ID 1617599.1)
Last updated on APRIL 03, 2020
Oracle Process Manufacturing Financials - Version 12.1.1 to 12.1.3 [Release 12.1] Information in this document applies to any platform.
Purpose of this diagnostic (OPMDCOGSDiag.sql) is to identify the sales orders which constitute the Deferred COGS account balance.
This will help to get the detailed transaction informations for Sales Order/s Order Management, Account Receivables, Inventory and OPM financials sub ledger at the Organization level. This script is applicable for various scenarios of Standard Sales Order, Return Orders (RMA) coupled with all the applicable OPM costing methods like Standard, Actual and Lot costing. OBJECTIVE: The sales order(s) which are at different stages of their life cycle in one spreadsheet at one go.
To collect the information of
This will help in:
Lesser time for data collection.
Faster diagnosis of the issue.
Easy collaboration across different modules like Order Management, Accounts Receivables, Inventory and Cost Management.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!