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

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.