Rejected Rows Not Inserted into FSI_D_<table>$ Table for a Large T2T Database Extract
Last updated on JULY 28, 2017
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications (OFSAA) 7.3.3, when you run a T2T Database Extract that loads millions of rows from a STG_<table> table to the target FSI_D_<table> table, records are rejected but the rejected records are not inserted into FSI_D_<table>$. As a result, you do not know why the rows were rejected.
In the Database Extract, in Mapping Properties, there is "Rejection Threshold" defined and Loading Mode is set to "Batch".
The following is in the log file in $FIC_DB_HOME/log/t2t:
Log Message here 1: Sun Feb 16 20:47:52 2014||DEBUG||ClsUBatchLoader::LoadData, INFO, insert query for load data formulated : insert into FSI_D_CASA(HOLIDAY_ROLLING_CONVENTION_CD,....................:T_RATE_INT_RATE_CD)LOG ERRORS INTO FSI_D_CASA$ ('INFODOM_T2T_CASA_20131031_20_Task1') REJECT LIMIT 50
Log Message here 1: Mon Feb 17 01:32:16 2014||SEVERE||Loading Failed, Number of erroneous records exceeded the reject limit
Log Message here 1: Mon Feb 17 01:32:16 2014||INFO||No. of records failed for other reasons (INSERT statement preparation, Datatype mismatch etc.) : 0
Log Message here 1: Mon Feb 17 01:32:17 2014||SEVERE||Back from loader : rows loaded -> 13958449
Log Message here 1: Mon Feb 17 01:32:17 2014||DEBUG||Back from loader : rows rejected -> 51
However, there are no rows inserted into FSI_D_CASA$ for the T2T batch.
You have multiple T2T database extracts. This issue only occurs for the database extracts that process millions of rows. The smaller extracts insert rows into the FSI_D_<table>$ tables successfully.
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