My Oracle Support Banner

DCOGS balance breakup (SO/RMA wise) and Diagnostic in OPM Financials (Doc ID 1617599.1)

Last updated on JUNE 21, 2023

Applies to:

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

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Troubleshooting Steps
 Data Flow Chart:
 Table Mapping:
 Sheet #1 - OE Data
 Sheet #2 - OE Shipment Data
 Sheet #3 - OE Not Invoiced
 Sheet #4 - AR Interface
 Sheet #5 - In OE, Not In AR
 Sheet #6 - AR Data
 Sheet #7 - AR Distributions
 Sheet #8 - COGS Data
 Sheet #9 - MMT Data
 Sheet #10 - Extract Headers Data
 Sheet #11 - Extract Lines Data
 Sheet #12 - DCOGS Balance Data

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.