DAC Execution Plan with Siebel source failed with ORA-00001: unique constraint W_STATUS_D_U1 violated error
(Doc ID 2617943.1)
Last updated on DECEMBER 12, 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.
Data Source: Siebel
DAC Execution Plan failed after Siebel Upgraded from IP15.11 to IP19.9 at the step "SIL_StatusDimension(DataWarehouse->DataWarehouse)" which is out of the box.
The error from Informatica log is:
ORA-00001: unique constraint (OBI.W_STATUS_D_U1) violated
The staging table W_STATUS_DS has duplicates for each status code.
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