BICC - BI APPS Product_wid Is Not Populated Correctly In W_SALES_ORDER_LINE_F
Last updated on JUNE 30, 2018
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 to 188.8.131.52.2 [Release 11g]
Information in this document applies to any platform.
BICC - BI APPS Product_wid is not populated correctly in W_SALES_ORDER_LINE_F. We did run SCM & OM full extracts in BICC and we did run the Domain load plan and warehouse load plans accordingly. While verifying the data loaded in the sales order line table in BIAPPS the PRODUCT_WID column is being populated as 0 for all the records. As per our observation , the Data from BICC Extracts looks correct but it looks like something issues around loading the data from the file to the staging table in SDS schema. The inventory item id in the BICC extracts is not matching with what we have in the FSC_DO_FULFILLLINE286178 table in SDS schema.
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