Inventory Value Report - As Of Date Not Working

(Doc ID 2380566.1)

Last updated on MARCH 29, 2018

Applies to:

Oracle Cost Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Reports Issues

ACTUAL BEHAVIOR
---------------
Inventory Value Report - As of Date not working

When we run the Inventory Value Report with an 'as of' date (in the past) the report is using a quantity for that date but the cost is the cost for the date that the report is run. We are using the Average Cost Method. Is this the way it works or do we have to change something?

EXPECTED BEHAVIOR
-----------------------
Expect the report to use the cost that existed from the as of date.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the Inventory Value Report
2. Use specific past date for As of Date
3. Observe the cost is the cost for the date that the report is run

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get accurate data using the As of Date .

Changes

 

Cause

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