ORA-00001: Unique Constraint (OFS_BI_ATT_INST_BKP_PK) Violated Running OFS_BI_LOAD (Doc ID 828535.1)

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
OFS-PA
OBIEE

Symptoms

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:

INST_NAME RESULT REMARKS
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

Cause

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