T2T Load Successful But 'No Rows Selected for the Given Definition in the Source Table(s)' (Doc ID 1336745.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), you are trying to load records from the STG_<instrument table> table into the FSI_D_<instrument table> table using the Table to Table (T2T) data loader.  The T2T batch process finishes with a status of 'Successful' but no rows are loaded into the instrument table.  The following message is at the end of the log file located in the directory $FIC_DB_HOME/log/t2t:

2011-07-06 | 19:03:53 | t2tserver | INFO | | | ClsUTableToTableLoad::directLoad, Success, fetched the no. of rows : 0
2011-07-06 | 19:03:53 | t2tserver | WARN | | | ClsUTableToTableLoad::directLoad, no rows selected for the given definition in the source table(s)
2011-07-06 | 19:03:53 | t2tserver | WARN | | | ClsUTableToTableLoad::directLoad, previous load is not enabled
2011-07-06 | 19:03:53 | t2tserver | INFO | | | ClsUTableToTableLoad::ExtractLoad, Success, direct table to table load successful
2011-07-06 | 19:03:53 | t2tserver | INFO | | | Status from extract load ... 0
2011-07-06 | 19:03:53 | t2tserver | DEBUG | | | T2TLoad::main, INFO, Status Returned from Table To Table Loading: 0

The warning message prevents data from being loaded into the instrument table.

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