After Upgrading To 6.3.6 Getting Errors in The "HDOWNER.E_LOAD_LOG" Table Running The ETL Process

(Doc ID 2014176.1)

Last updated on NOVEMBER 01, 2017

Applies to:

Oracle Fusion Transportation Intelligence - Version 6.3.6 to 6.3.8 [Release 6.3]
Information in this document applies to any platform.

Symptoms

Upgraded OTM from 6.3.2 to 6.3.6, getting errors in the HDOWNER.E_LOAD_LOG table Running the ETL process

The errors are generated while completing the following:
A) Select Transportation Intelligence
B) Select Process Management
C) Run ETL
----Then to display the errors ,
D) Select Transportation Intelligence
E) Select Data Management
F) Select View FTI Data Load Log

"ODI-1226: Step INCR LOAD_PATH_AND_PATHEDGE fails after 1 attempt(s).
ODI-1232: Procedure INCR_LOAD_PATH_AND_PATHEDGE execution fails.
ODI-1228: Task INCR_LOAD_PATH_AND_PATHEDGE (Procedure) fails on the target ORACLE connection ORACLE_FTI.
Caused By: java.sql.SQLException: ORA-06550: line 30 column 30:
PL/SQL: ORA-02289: sequence does not exist
ORA-06550: line 28 column 1:
PL/SQL: SQL Statement ignored

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.pro"
"ODI-1226: Step INCR_W_LEG_D fails after 1 attempt(s).
ODI-1240: Flow INCR_W_LEG_D fails while performing a Integration operation. This flow loads target table W_LEG_D.
ODI-1228: Task INCR_W_LEG_D (Integration) fails on the target ORACLE connection ORACLE_FTI.
Caused By: java.sql.SQLSyntaxErrorException: ORA-02289: sequence 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.proce"
"ODI-1226: Step INCR_W_NETWORK_D fails after 1 attempt(s).
ODI-1240: Flow INCR_W_NETWORK_D fails while performing a Integration operation. This flow loads target table W_NETWORK_D.
ODI-1228: Task INCR_W_NETWORK_D (Integration) fails on the target ORACLE connection ORACLE_FTI.
Caused By: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.drive"

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