My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.