No Rows Loaded After Running Seeded T2T_EXCHANGE_RATE_HIST Batch

(Doc ID 1276677.1)

Last updated on FEBRUARY 28, 2017

Applies to:

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

Symptoms

On OFSAA 7.2.4, when attempting to run the T2T_EXCHANGE_RATE_HIST, although the batch completes successfully, the FSI table is not populated.

The t2t batch log however, shows 0 rows loaded:

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


EXPECTED BEHAVIOR
Expect successful completion of batch to also have the FSI table populated.

The issue can be reproduced at will with the following steps:
1. Populate the STG_EXCHANGE_RATE_HIST table.

2. Run a new batch with the following:

Component: LOAD DATA

Task1: Status = Successful

Parameters:
Data File Name: NULL
Datastore Name: EPMINF
Datastore Type: EDW
Default Value: NULL
File Name: T2T_EXCHANGE_RATE_HIST
IP Address: 123.1.0.55
Load Mode: Table to Table
Source Name: STAGING_SOURCE_T2T

3. Query the FSI table once batch is successful.
==> Errors also occur when running the T2T_IRC_RATE_HIST.  The batch fails when run.

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