Migrate_Common_Tbls Errors with ORA-00001: Unique Constraint (<atomic>.PK_FSI_M_OBJECT_DEFINITION_B) Violated' (Doc ID 1453066.1)

Last updated on MAY 01, 2012

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Oracle Financial Data Manager - Version 4.5.39 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Applications (OFSA)

Symptoms

When running the "fsi_util.migrate_common_tbls" procedure for the OFSA 4.5 to Oracle Financial Services Analytical Applications (OFSAA) 5.2.2 migration process, you get a unique constraint error on FSI_M_OBJECT_DEFINITION_B.

The following error exists in Status.txt:

Procedure MIGRATE_COMMON_TBLS Executed with ERRORS
 
*** Errors Details ***
 
Table Name :- 'FSI_M_OBJECT_DEFINITION_B'
 
Oracle Error Message :- ORA-00001: unique constraint (<atomic>.PK_FSI_M_OBJECT_DEFINITION_B) violated


And the following error exists in migrateCommonData.log:

 ********* Starting Migration From Staging to Target *********
 
Inserting into FSI_M_OBJECT_DEFINITION
Error while Inserting into FSI_M_OBJECT_DEFINITION_B

The error causes the Common Table Migration process to fail.

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