OBIA 220.127.116.11.1 - Conversion Rate Is Applied Incorrectly In W_SALES_PICK_LINE_F with EBS 18.104.22.168
Last updated on JANUARY 31, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms