OFSAA Object Migration Fails to Migrate FTP Interest Rate Curves (Doc ID 1627449.1)

Last updated on JANUARY 03, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1 to 6.1.1 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)

Symptoms

In OFSAAI 7.3.3.0/ FTP 6.1, When trying to migrate FTP Interest rate curves from one environment to another, the following error is displayed in the FUSIONSUBSYSTEMSService.log:

ERROR
[DBUTIL]Dependency Exist for the Object , So Preparing to Move Dependent Objects of Count..1
[FUSIONSUBSYSTEMS] Feb 17,14 11:52:23 : [DBUTIL]Preparing to Migrate Object..[id:EUR,name:Euro (European EMU),type:802,Source Folder: ,Target Folder: ]
[FUSIONSUBSYSTEMS] Feb 17,14 11:52:23 : [MIGRATIONSERVICECLIENT]depAPI null
[FUSIONSUBSYSTEMS] Feb 17,14 11:52:23 : [QUERYRUNNER]Executing Query..SELECT FITC.OBJECT_TYPE FROM FSI_ID_TYPE_CD FITC WHERE FITC.ID_TYPE_CD = ?
[FUSIONSUBSYSTEMS] Feb 17,14 11:52:23 : [MIGRATORTHREAD]Object Group TYPE:::null
[FUSIONSUBSYSTEMS] Feb 17,14 11:52:23 : [MIGRATORTHREAD]Panel Type :::0
[FUSIONSUBSYSTEMS] Feb 17,14 11:52:23 : [DBUTIL]Object Destination Folder... Doesn't Exist in Target Environment.[id:EUR,name:Euro (European EMU),type:802,Source Folder: ,Target Folder: ]
[FUSIONSUBSYSTEMS] Feb 17,14 11:52:23 : [DBUTIL]Since One of the Dependent Object Migration Failed, Not Migrating the Parent Object..[id:99988,name:IRR4_Euribor Rates_Org,type:801,Source Folder: ,Target Folder:null]
[FUSIONSUBSYSTEMS] Feb 17,14 11:52:23 : [DBUTIL]Migration Completed With Errors.Number Of Objects Failed to Migrate is ...1
[FUSIONSUBSYSTEMS] Feb 17,14 11:52:23 : [MIGRATIONINTERNALSERVICECLIENT]query::::UPDATE REV_MIG_EXECUTION SET STATUS = ?, END_DATE = SYSDATE WHERE RUN_ID = ?
[FUSIONSUBSYSTEMS] Feb 17,14 11:52:23 : [MIGRATIONHANDLER]Migration Execution status..SUCCESS


Steps to reproduce

The issue can be reproduced at will with the following steps:
1. Attempt to migrate the FTP Interest rate curves using Object Migration.

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