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:Business Intelligence Applications Consumer - Version 188.8.131.52 [AA 1830] to 184.108.40.206 [AA 1830] [Release V7]
Information in this document applies to any platform.
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
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