11.5.10: How To Identify Differences When OPM Inventory and Subledger Do Not Balance

(Doc ID 371065.1)

Last updated on NOVEMBER 10, 2016

Applies to:

Oracle Process Manufacturing Financials - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Subledger Update, Inventory Valuation

Goal

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.

Solution

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