My Oracle Support Banner

OBIA 11g: Load Fails on Custom SIL_ActivityMiniDimension with ORA-00942 (Doc ID 2322700.1)

Last updated on OCTOBER 02, 2020

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.2 and later
Information in this document applies to any platform.

Symptoms

While running the load for the new SIL custom interface, there was no record for the new scenario in the table W_ETL_LOAD_DATES and thus the run didn't create the I$ table (/* Full load flow bypass */) with the following error :

Error:

             ODI-1226: Step Custom_SIL_ActivityMiniDimension.WC_ACTIVITY_MD fails after 1 attempt(s).

             ODI-1240: Flow Custom_SIL_ActivityMiniDimension.WC_ACTIVITY_MD fails while performing a Control operation. This flow loads target table WC_ACTIVITY_MD.

             ODI-1228: Task WC_ACTIVITY_MD (Control) fails on the target ORACLE connection BIAPPS_DW.

             Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: Tabelle oder View nicht vorhanden

In the step Session Task Control (insert Column Len errors (String)), there is select from I$% that does not exist. This works in ODI 11.1.17 but not in ODI 11.1.1.9.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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