Transfer Pricing Rule Migration Fails with 'ORA-00001: unique constraint (<atomic>.PK_FSI_M_OBJECT_DEFINITION_B) violated' (Doc ID 2478111.1)

Last updated on JULY 30, 2019

Applies to:

Symptoms

In Oracle Financial Services Funds Transfer Pricing (FTP) 8.0.x, in Object Administration > Object Migration, when attempting to migrate a Transfer Pricing Rule from one environment to another, the migration process ends in a status of 'Failed'.  The following error exists in the FUSIONSUBSYSTEMSService.log from the web server's OFSAA log directory:

[27-11-18 19:42:13,425 GMT PM] [DEBUG] [WEB] [AMHM] [NA] [FTPMIGRATIONSERVICE] target Object Id..213945
[27-11-18 19:42:13,425 GMT PM] [DEBUG] [WEB] [AMHM] [NA] [MIGRATIONCOMMONSERVICE] Select query..SELECT ID_TYPE, OBJECT_ORIGIN_APP_CD, APPL_NAME, ACCESS_CD, LEAF_NUM_ID, DELETED_FLAG, SOURCE_LANG, TABLE_NAME FROM FSI_M_OBJECT_DEFINITION_B WHERE OBJECT_DEFINITION_ID = ?
[27-11-18 19:42:13,426 GMT PM] [DEBUG] [WEB] [AMHM] [NA] [MIGRATIONCOMMONSERVICE] Insert query..INSERT INTO FSI_M_OBJECT_DEFINITION_B(OBJECT_DEFINITION_ID,ID_TYPE,OBJECT_ORIGIN_APP_CD,APPL_NAME,ACCESS_CD,FOLDER_ID,FOLDER_NAME,LEAF_NUM_ID,DELETED_FLAG,SOURCE_LANG,TABLE_NAME,CREATED_BY,CREATION_DATE,MODIFIED_BY,LAST_MODIFIED_DATE) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,SYSDATE,?,SYSDATE)
[27-11-18 19:42:13,436 GMT PM] [ERROR] [WEB] [AMHM] [NA] [MIGRATIONCOMMONSERVICE]
com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: unique constraint (ATOMIC.PK_FSI_M_OBJECT_DEFINITION_B) violated

       at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
       at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:83)
       at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:57)
       at java.lang.reflect.Constructor.newInstance(Constructor.java:437)
       at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:627)
       at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:686)
       at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2267)
       at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1191)
       at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:853)
       at com.ofs.reveleus.migration.impl.MigrationCommonService.migrateObjectDefinition(MigrationCommonService.java:941)
       at com.ofs.fsapps.ftp.global.FTPMigrationService.migrate(FTPMigrationService.java:89)
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
       at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:90)
       etc.

If you check "target Object Id..213945" from the log in FSI_M_OBJECT_DEFINITION_B and FSI_M_OBJECT_DEFINITINON_TL, a row already exists for the Object Id and it is associated with an object that is not a Transfer Pricing Rule.

As a result of this error, the Transfer Pricing Rule fails to migrate to the target environment.

Changes

Cause

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