How To Find the Inventory Balances on a Specific Date for a chosen Item (Doc ID 2070914.1)

Last updated on NOVEMBER 02, 2015

Applies to:

Oracle Process Manufacturing Financials - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

How to find Inventory Balances for past dates in OPM. In OPM, standard report is available for balances for current date or month end only.
If user needs to find Inventory Balances for some specific date of previous period, it is not available.
Is there any report available to find historical balances in OPM?
If not please provide a query to find historical balances with following fields.
Organization Code, Item Code,Item Description,Subinventory,Locator,Primary Quantity,UOM,Lot Number,Cost
with input parameters as Organization Code,Date(Historical date for which inventory quantity need to be find).
 

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