11.5.10: How To Identify Differences When OPM Inventory and Subledger Do Not Balance
(Doc ID 371065.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Process Manufacturing Financials - Version 11.5.10 to 18.104.22.168 [Release 11.5]
Information in this document applies to any platform.
Subledger Update, Inventory Valuation
Use the scripts to reconcile Inventory and the Subledger.
Sum subr_amount of INV account title for each doc_type in Query 1 output. Similarly, sum pnd_amount for each doc_type in "Query 3" + "Query 4". Compare the subr_amount and pnd_amount for each document type.
This should match for all doc_type except PORC as it depends on Event Fiscal Policy setting. If PO receipts are booked at PO unit price then there will be difference for PORC document type as inventory value in "Query 3" & "Query 4" is computed using item cost and subledger postings are generated using PO Unit Price.
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
OPM Inventory Reconciliation scripts:
Validation Steps :