ORA-0001 on FSI_ENGINE_LOOKUP_PK Executing FSI_UTILl.MIGRATE_COMMON_TBLS During Migration from OFSA 4.5 (Doc ID 1457744.1)

Last updated on MAY 11, 2012

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.8 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 7.2.8 version, Install and Upgrade Issues

When attempting to execute migration script fsi_util.migrate_common_tbls the following error occurs.

ERROR
-----------------------
SQL> exec fsi_util.migrate_common_tbls('CONFIG','OFSAPROD');
Staging Table Migration : COMMON Tables --> Started
Truncating Staging Table : FSI_ERROR_LOG
Truncating Staging Table : FSI_M_OBJECT_DEFINITION_T
Truncating Staging Table : FSI_DEFAULT_HIER_T
Truncating Staging Table : FSI_DATA_IDENTITY_T
Truncating Staging Table : FSI_EXCHANGE_RATE_HIST_AUDIT_T
Truncating Staging Table : FSI_EXCHANGE_RATE_HIST_T
Truncating Staging Table : FSI_FISCAL_YEAR_INFO_T
Truncating Staging Table : FSI_TEMP_OBJECTS_T
Truncating Staging Table : FSI_CURRENCIES_T
Truncating Staging Table : FSI_IRCS_T
Truncating Staging Table : FSI_IRC_RATE_TERMS_T
Truncating Staging Table : FSI_IRC_RATE_HIST_T
Truncating Staging Table : FSI_IRC_TS_PARAM_HIST_T
Truncating Staging Table : FSI_FIXED_CURRENCIES_T
Truncating Staging Table : FSI_FIXED_CURRENCIES_AUDIT_T
Truncating Staging Table : FSI_TM_FIN_ELEM_SET_T
Truncating Staging Table : REV_DESCRIPTION_TABLES_T
Truncating Staging Table : FSI_FIN_ELEM_SET_DTL_T
Truncating Staging Table : FSI_ENGINE_LOOKUP_T
Truncating Staging Table : FSI_DB_INFO_T
Truncating Staging Table : REV_EXPRESSION_DETAILS_T
Truncating Staging Table : FSI_EXCHNG_RATE_DIRECT_ACCESST
Truncating Staging Table : FSI_EXCHNG_RATE_CONV_FORMULA_T
Staging Table Migration : COMMON Tables --> Ended Successfully
Target Table Migration : COMMON Tables --> Started
ERROR While Executing  Target Table Migration : COMMON Tables -->

PL/SQL procedure successfully completed.

 Further debugging shows: Oracle Error Message: ORA-0001 unique constraint (ATOMIC.FSI_ENGINE_LOOKUP_PK) violated.

Changes

 Migrate from OFSA 4.5 to OFSAA 5.2.2.

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