INVENTORY VALUE REPORT SHOWS INCORRECT EXTENDED VALUE WHEN RUN IN 2 DIFFERENT MONTHS (Doc ID 1451220.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Symptoms

On :  12.1.1 version, Reports Issues
  
  ACTUAL BEHAVIOR  
  ---------------
  Inventory Value Report - by Subinventory ran in 2 different month using the
  same parameters and As of Date:  30-APR-2011 23:59:59 show a discrepancy.
  For Report Date:  30-APR-2011 23:59
  As of Date:  30-APR-2011 23:59:59
  
  the Report value was :  2,953,231.05
  
  and
  
  For Report Date:  15-jul-2011 23:59
  As of Date:  30-APR-2011 23:59:59
  
  the Report value was :  2,953,225.48
  
  There is a difference between two values
  
  
  Also, if you run the report using As of Date: 01-OCT-2011, the same
  discrepancy can be seen:
  
  Report Date: 02-JAN-2012
  As of Date: 01-OCT-2011
  
  
  Report Total: 2917310.25
  
  
  
  Report Date: 15-DEC-2011
  As of Date: 01-OCT-2011
  
  
  Report Total: 2919826.58
  
  
  EXPECTED BEHAVIOR
  -----------------------
  no difference
  
  STEPS
  -----------------------
  The issue can be reproduced at will with the following steps:
  1. run report in 2 separate months

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