T2T Datatype Mismatch Error: Execution Fails if Target Column Datatype is DATETIME (Doc ID 1623772.1)

Last updated on OCTOBER 04, 2016

Applies to:

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

Symptoms

In OFSAA 7.3.3.2.4, previously working Table to Table (T2T) extracts do not run successfully.  All records seem to be rejected due date format. No data is inserted into table$.

The T2T log does not show relevant error details:

ERRORS INTO FSI_D_CUSTOM_ALMACENADORA$ ('INDOMOFSAAI_T2T_CUSTOM_ALMACENADORA_20131031_27_Task1') REJECT LIMIT 50
OCI_NO_DATA
Log Message here 1: Mon Feb 10 19:20:49 2014||INFO||No. of records failed for other reasons (INSERT statement preparation, Datatype mismatch etc.) : 0
Log Message here 1: Mon Feb 10 19:20:49 2014||INFO||ClsUTableToTableLoad::directLoad, Success, data loaded successfully
Log Message here 1: Mon Feb 10 19:20:49 2014||DEBUG||Back from loader : rows loaded ->0
Log Message here 1: Mon Feb 10 19:20:49 2014||DEBUG||Back from loader : rows rejected->26
Log Message here 1: Mon Feb 10 19:20:49 2014||DEBUG||ClsUTableToTableLoad::updateETLLoadHistory, INFO, insert query for ETLLoadHistory table : INSERT into ETLLoadHistory values('INDOMOFSAAI_T2T_CUSTOM_ALMACENADORA_20131031_27','Task1','INDOMOFSAAI','ETLSRCDW',1,'FSI_D_CUSTOM_ALMACENADORA','T2T_CUSTOM_ALMACENADORA',to_date('20131031','YYYYMMDD'),to_date('2014-2-10 19:20:00','yyyy-mm-dd HH24:mi:ss'),to_date('2014-2-10 19:20:00','yyyy-mm-dd HH24:mi:ss'),26,0,0,26,'LS',0,'',0,null,null,null,null,null,'T2T_CUSTOM_ALMACENADORA',0,'NO')

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