Historical Interest Rates Data Loader T2T Fails When Launched From Interest Rates Screen With 'Error, unable to find the properties XML file' Errors (Doc ID 2233513.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Table to Table (T2T) Data Loader
Data Mapping
Historical Rates Loader
T2T_IRC_LOADDATA Batch

Symptoms

On OFSAA 8.0.1, the Historical Rates Data Loader appears to fail. From the launched T2T batch log file OFSAA_T2T_IRC_LOADDATA_20150101_3_Task2_ttl.log, the following error is found:

ERROR

Log Message here 1: Tue 17 Jan 2017 03:10:24 PM JST||DEBUG||Definition Name -> T2T_IRC_TS_PARAM_HIST
Log Message here 1: Tue 17 Jan 2017 03:10:24 PM JST||INFO||ClsUTableToTableLoad::ExtractLoad, Success, Definition File name converted to shell encoding : /staging/OFSAA/ftpshare//STAGE/NULL/T2T_IRC_TS_PARAM_HIST.xml
Log Message here 1: Tue 17 Jan 2017 03:10:24 PM JST||INFO||ClsUTableToTableLoad::ExtractLoad, Success, Properties file name converted to shell encoding : /staging/OFSAA/ftpshare//STAGE/NULL/T2T_IRC_TS_PARAM_HIST.properties.xml
Log Message here 1: Tue 17 Jan 2017 03:10:24 PM JST||DEBUG||ClsUTableToTableLoad::ExtractLoad, After file name conversions.
Log Message here 1: Tue 17 Jan 2017 03:10:24 PM JST||DEBUG||Definition file name : /staging/OFSAA/ftpshare//STAGE/NULL/T2T_IRC_TS_PARAM_HIST.xml
Log Message here 1: Tue 17 Jan 2017 03:10:24 PM JST||DEBUG||Properties file name : /staging/OFSAA/ftpshare//STAGE/NULL/T2T_IRC_TS_PARAM_HIST.properties.xml
Log Message here 1: Tue 17 Jan 2017 03:10:24 PM JST||SEVERE||ClsUTableToTableLoad::ExtractLoad, Error, unable to find the properties XML file

The files mentioned do not appear to exist:

/staging/OFSAA/ftpshare//STAGE/NULL/T2T_IRC_TS_PARAM_HIST.xml
/staging/OFSAA/ftpshare//STAGE/NULL/T2T_IRC_RATE_HIST.xml

The issue can be reproduced at will with the following steps:
1. Rate Management -> Interest Rates screen
2. Launch the Historical Interest Rates Data Loader running man

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