Inventory Value Report - By Subinventory Is Giving Incorrect Valuation Amounts
Last updated on FEBRUARY 02, 2017
Applies to:Oracle Cost Management - Version 12.1.1 and later
Information in this document applies to any platform.
On : 12.1.1 version, Inventory Costing
Inventory Value Report - by Sub-inventory amount values are not matching with Inventory Period values at close. After analysing the report, Item valuations are being done at latest standard cost instead of respective available standard cost for that period.
For Ex: when running inventory valuation report for Apr-FY 2011, Inventory valuation for all items is calculated based on latest standard cost which is updated in May-FY2011 though there is a different standard cost for Period Apr-FY2011.
Applied Patch <11714951>:R12.BOM.C to get CSTRINVR.rdf version 120.8.12010000.6.
After re-applying the Patch Inventory FG Period Close Values are still not matching with Elemental Inventory Value Report - by Subinventory.
Please refer to screen shots and also output file of the Elemental Inventory Value Report - by Subinventory report.
Expect the Inventory Value Report - by Sub-inventory figures to match with Inventory Period values at close.
The issue can be reproduced at will with the following steps:
1. Run the reports- Inventory Value Report - by Sub-inventory
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms