My Oracle Support Banner

No Rows Loaded After Running Seeded T2T_EXCHANGE_RATE_HIST Batch (Doc ID 1276677.1)

Last updated on JUNE 29, 2021

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: <INFODOM>
Datastore Type: EDW
Default Value: NULL
File Name: T2T_EXCHANGE_RATE_HIST
IP Address: <IP ADDRESS>
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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.