Batch execution failed by Long ANSI Join defined in T2T (Doc ID 2876485.1)

Last updated on JUNE 27, 2023

Applies to:

Symptoms

On ofsaa 8.1.0.2.0,

ACTUAL BEHAVIOR
---------------

 When attempting to run the t2t batch, Below error occurred in ftpshare T2TCPP log:

ERROR:

[11-02-22 03:19:49 EST AM][INFO][BACKEND][OFSAA][T2TCPP] executing insert query
FAILED: ORA ERROR : ORA-00904: "INTERCO"."FIC_MI_DATE": invalid identifier

[11-02-22 03:19:49 EST AM][SEVERE][BACKEND][OFSAA][T2TCPP] ClsUDBConnect::executeInsertQuery, Error, unable to execute the insert query. ERROR Message: ORA-00904: "INTERCO"."FIC_MI_DATE": invalid identifier

[11-02-22 03:19:49 EST AM][INFO][BACKEND][OFSAA][T2TCPP] ClsUBatchLoader::Bulk, Error Messaage : ORA-00904: "INTERCO"."FIC_MI_DATE": invalid identifier

EXPECTED BEHAVIOR
-----------------------

After executing the T2T Batch, It must be transfer the data from source table to target table.

STEPS
-----------------------

The issue can be reproduced at will with the following steps:

1. In Data Mapping, define a T2T 

2. In batch monitor, create batch id and add the defined T2T in the task

3. In batch maintenance, execute the batch

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, unable to execute T2T definitions.

Cause

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