ORA-00001: Unique Constraint (OFS_BI_ATT_INST_BKP_PK) Violated Running OFS_BI_LOAD
Last updated on JUNE 11, 2009
Applies to:Oracle Financial Services Profitability Analytics - Version: 4.5.39
This problem can occur on any platform.
Oracle Financial Services Applications (OFSA) 4.5.39
When re-loading data into the Profitability Analytics tables using the OFS_BI_DATA_LOAD.OFS_BI_LOAD procedure, the new data is not loaded and you receive the following errors in the OFS_BI_PROCESS_LOG table:
|Attributes - FEM_CHECKING||F||ORA-00001: unique constraint (OFSADEMO.OFS_BI_ATT_INST_BKP_PK) violated|
|Attributes load failed||F||ORA-00001: unique constraint (OFSADEMO.OFS_BI_ATT_INST_BKP_PK) violated|
|General Error - Process Aborted||F||ORA-00001: unique constraint (OFSADEMO.OFS_BI_ATT_INST_BKP_PK) violated|
|Process Status||F||Done Processing with Errors - Please see earlier error for Details|
The data being loaded was already loaded once for the same As of Date. You are re-loading it a second time.
You may also be re-running the OFS_BI_LOAD after correcting an error
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