OBIA 7964: SIL_InventoryProduct_Dimension Fails With Error - "ORA-00001: unique constraint (WAREHOUSE.W_INV_PROD_D_P1) violated"
Last updated on JUNE 11, 2018
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206 to 220.127.116.11 [Release V7]
Information in this document applies to any platform.
On Oracle Business Intelligence Applications (OBIA) 18.104.22.168
- 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.
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