My Oracle Support Banner

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 [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 :
Tables Involved:

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