OPLA ETL Is Failing with Error "ODI-1228: Task Procedure-odi_pro_BI_COM_MULTILIST_DATA_PRO-odi_pro_BI_MDS_MULTILIST_DATA_PRO fails on the target connection TRG_BI_PHYSICAL. Caused By: java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name" (Doc ID 2823279.1)

Last updated on NOVEMBER 25, 2021

Applies to:

Symptoms

On : 3.6.1 version, MDS Load for Agile PLM 9x

Oracle Product Lifecycle Analytics (OPLA) Target reporting Schema (MDS) Full Extract Transform Load (ETL) is failing.

ERROR
ODI-1228: Task Procedure-odi_pro_BI_COM_MULTILIST_DATA_PRO-odi_pro_BI_MDS_MULTILIST_DATA_PRO fails on the target connection TRG_BI_PHYSICAL.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name
ORA-06512: at "MDS.MDS_MULTILIST_DATA_PRO", line 1470
ORA-06512: at "MDS.MDS_MULTILIST_DATA_PRO", line 1356
ORA-06512: at "MDS.MDS_MULTILIST_DATA_PRO", line 1356
ORA-06512: at "MDS.MDS_MULTILIST_DATA_PRO", line 1321
ORA-06512: at "MDS.MDS_MULTILIST_DATA_PRO", line 1356

STEPS
The issue can be reproduced at will with the following steps:
1. Log into OPLA
2. Perform Environment propagation by referring to "https://docs.oracle.com/cd/E70337_03/otn/pdf/install/html_oplab/output/appendix_c.htm#BEJBHAHC"
3. Start Full ETL for stage and MDS
4. Stage Full ETL completed successfully, But MDS full ETL fails with error

Cause

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