My Oracle Support Banner

BICC - BI APPS Product_wid Is Not Populated Correctly In W_SALES_ORDER_LINE_F (Doc ID 2417778.1)

Last updated on JUNE 30, 2018

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

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.

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