My Oracle Support Banner

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 7.9.6.2 [AA 1830] to 7.9.6.2 [AA 1830] [Release V7]
Information in this document applies to any platform.

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

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
Changes
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.