OBIA 7962 Order Management: The Backlog Amounts Are Overstated When The "Standard UOM Conversion Rate" Is > 1 (Doc ID 1665385.1)

Last updated on JANUARY 23, 2020

Applies to:

Symptoms

The Backlog amounts are overstated when the "Standard UOM Conversion Rate" Is > 1.

The PLP mapping PLP_SalesBacklogLinesFact_Load_OrderLines populates the NET_AMT information in Backlog Lines Fact.
The calculation logic for NET_AMT is results in a wrong amount when Standard UOM Conversion Rate >1.

Open Quantity is calculated based on Total Invoice Quantity, Sales Quantity, Total Shipped Quantity and Standard UOM Conversion Rate.

Sales Quantity is being multiplied by Standard UOM Conversion rate to derive the Scheduled Quantity which is then used to determine the Open_Qty.

NET_DOC_PRICE is calculated based on NET_AMT and Sales Quantity /Cancelled Quantity as per below logic:

NET_DOC_PRICE = NET_AMT / Sales Quantity if Sales Quantity > 1 Else NET_AMT / Cancelled Quantity

Then NET_AMT is calculated as below:

NET_AMT = NET_DOC_PRICE*Open Quantity

Changes

Cause

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