'Error, Unable to Find the Properties XML File' Running T2T Extract with NULL SourceName (Doc ID 2161525.1)

Last updated on JULY 16, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Profitability Management (PFT), when you try to run a T2T Data Mapping extract (ex. T2T_EXCHANGE_RATE_HIST), you get the following errors in the log in $FIC_DB_HOME/log/t2t:

Log Message here 1: Fri 17 Jun 2016 10:42:37 AM MST||DEBUG||Properties file name : /<ftpshare>//STAGE/NULL/T2T_EXCHANGE_RATE_HIST.properties.xml
Log Message here 1: Fri 17 Jun 2016 10:42:37 AM MST||SEVERE||ClsUTableToTableLoad::ExtractLoad, Error, unable to find the properties XML file


Additionally, the "SourceName" value is null:

Log Message here 1: Fri 17 Jun 2016 10:42:37 AM MST||DEBUG||Stage Path -> /<ftpshare>//STAGE
Log Message here 1: Fri 17 Jun 2016 10:42:37 AM MST||DEBUG||ERwin File Path ->/<ftpshare>//OFSAA/erwin
Log Message here 1: Fri 17 Jun 2016 10:42:37 AM MST||DEBUG||SourceName ->NULL
Log Message here 1: Fri 17 Jun 2016 10:42:37 AM MST||DEBUG||Definition Name -> T2T_EXCHANGE_RATE_HIST


The null data source value causes the T2T load to fail.  You do not understand why the source is null.

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