OBIA 220.127.116.11.1 - Conversion Rate Is Applied Incorrectly In W_SALES_PICK_LINE_F with EBS 18.104.22.168
(Doc ID 1989871.1)
Last updated on FEBRUARY 15, 2019
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.1 and later
Information in this document applies to any platform.
OBIA 126.96.36.199.1 with EBS 188.8.131.52
- Conversion Rate is applied incorrectly in W_SALES_PICK_LINE_F
- There is an order where the ORDER_UOM is in KG and the shipped UOM is in LB, the standard UOM for this product LB.
- When the data is populated in W_SALES_PICK_LINES_F the act_shipped_qty column is storing the shipped quantity and the SALES_UOM is being stored as the ORDER_UOM which is different from SHIPPED UOM in EBS.
- In RPD the shipped quantity is being multiplied with the conversion rate which is causing data issues.
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