My Oracle Support Banner

XML VALUATION REPORTS ARE NOT ROUNDING QUANTITY, COSTS AND VALUES CORRECTLY (Doc ID 1609900.1)

Last updated on JANUARY 16, 2021

Applies to:

Oracle Cost Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Some Inventory Value Reports are displaying the Unit Cost in only 2 digits.
 
However, CSTRINVR module: Inventory Value Report - by Subinventory is displaying 5 digits.

(1) Inventory Value Report - by Subinventory (XML) (CSTRINVR_XML)
    a."Unit Cost" was not rounded by currency extended precision
    b."Extended Value" was not under currency format
    c.Items under same subinventory were not grouped into the same  subinventory when sorting by "subinventory,item"
    d.Subinventories were not in sequential order
    e.Quantity was not rounded by profile Dynamic Quantity precision
    f.Sort option was not translatable since its value was coming from xml raw  data
 (2) All Inventories Value Report - by Cost Group(XML) (CSTRAIVA_XML)
    a."Subinventory Value" for each item always has values as 0.
    b.Quantity of suinventory/receiving/intransit was not rounded by  user-defined Quantity precision
    c.Performance issue with relative path
 (3) Elemental Inventory Value Report - by Cost Group(XML) (CSTREIVW_XML)
    a."No data found" was always shown at the end of XML report.
    b."Category Total" was not shown under each category when sorting by  "category, item"
    c.Sorting by Cost Group, Item: did not work properly. The report result  acted like Sort by Item.
    d.Items within the same cost group were not grouped together when sorting  by "cost group, item"
    e.Calculations of "Cost Group Total" and "Cost Element Total" were not  correct when sorting by "cost group, item"
    f.Sort option was not translatable since its value was coming from xml raw  data
 (4) Elemental Inventory Value Report - by Subinventory(XML) (CSTREIVR_XML)
    a.All value fields were not formatting as currency.
    b.Value of Cost Element Overhead was wrong, always appending with "0.00"  when sorting by "subinventory, item"
    c.Quantity was not rounded by profile Quantity precision
 (5) Intransit Value Report(XML) (CSTRITVR_XML)
    a."Unit Cost" was not rounded by currency extended precision
    b.Quantity was not rounded by profile Quantity precision
    c.Performance issue with relative path
    d.Sort option was not translatable since its value was coming from xml raw



STEPS
-----------------------
1. run Inventory Value Reports  (XML - ones)

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.