11.5.10: How To Identify Differences When OPM Inventory and Subledger Do Not Balance
Last updated on APRIL 12, 2018
Applies to:Oracle Process Manufacturing Financials - Version 11.5.10 to 188.8.131.52 [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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms