OBIA 7964: SIL_InventoryProduct_Dimension Fails With Error - "ORA-00001: unique constraint (WAREHOUSE.W_INV_PROD_D_P1) violated"
(Doc ID 2359989.1)
Last updated on FEBRUARY 19, 2019
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11 to 18.104.22.168 [Release V7]
Information in this document applies to any platform.
On Oracle Business Intelligence Applications (OBIA) 22.214.171.124
- The Incremental Load for the table W_INVENTORY_PRODUCT_D fails from SILOS folder.
- From the session log, it was found that UNIQUE INDEX "WAREHOUSE"."W_INV_PROD_D_P1" ON "WAREHOUSE"."W_INVENTORY_PRODUCT_D" ("ROW_WID") has been violated.
- The ROW_WID trying to be inserted is already present in the table, however the Integration_ID is different for the new data created.
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