ETL Fails with Error Messages "fails on the target ORACLE connection ORACLE_FTI" (Doc ID 1574802.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Randomly (so it seems), sometimes the ETL is successful, sometimes it fails. When it fails, it has the following errors (examples, more are in the attached log file)

ODI-1226: Step INCR_F_ORDER_RELEASE_AUDIT_DETAIL fails after 1 attempt(s).
ODI-1240: Flow INCR_F_ORDER_RELEASE_AUDIT_DETAIL fails while performing a Control operation. This flow loads target table F_ORDER_RELEASE_AUDIT_DETAIL.
ODI-1228: Task F_ORDER_RELEASE_AUDIT_DETAIL (Control) fails on the target ORACLE connection ORACLE_FTI.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CT

ODI-1226: Step INCR_D_LOCATION fails after 1 attempt(s).
ODI-1240: Flow INCR_D_LOCATION fails while performing a Control operation. This flow loads target table D_LOCATION.
ODI-1228: Task D_LOCATION (Control) fails on the target ORACLE connection ORACLE_FTI.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.p

ODI-1226: Step INCR_F_BASE_UOM fails after 1 attempt(s).
ODI-1240: Flow INCR_F_BASE_UOM fails while performing a Control operation. This flow loads target table F_BASE_UOM.
ODI-1228: Task F_BASE_UOM (Control) fails on the target ORACLE connection ORACLE_FTI.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.p

Cause

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