How to Determine Why Records Are Rejected When T2T Database Extract Fails

(Doc ID 1642819.1)

Last updated on JULY 21, 2016

Applies to:

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

Goal

In Oracle Financial Services Analytical Applications (OFSAA) infrastructure, when you run a T2T Database Extract in a batch, the batch fails.  The following messages are output to the log file in $FIC_DB_HOME/log/t2t:

Log Message here 1: Tue Apr 01 11:11:50 2014||SEVERE||Loading Failed, Number of erroneous records exceeded the reject limit
Log Message here 1: Tue Apr 01 11:11:50 2014||INFO||No. of records failed for other reasons (INSERT statement preparation, Datatype mismatch etc.) : 0
Log Message here 1: Tue Apr 01 11:11:50 2014||SEVERE||Back from loader : rows loaded -> 0
Log Message here 1: Tue Apr 01 11:11:50 2014||DEBUG||Back from loader : rows rejected -> 51

How can you determine why the records are rejected?

Solution

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