Data Model and Transformation Install Failure in QC with ORA-20200/ORA-06510 After Changing a Column's Oracle Name (Doc ID 2730489.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

Data Model Install and Transformation Install Fail in QC Lifecycle with the following errors:

ERRORS

1. In Transformation install log:
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_W###_#####_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.DME_INST_XFORM_MAP", line 12559
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.DME_DF_XFORM_MAP", line 20479
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 15062
ORA-06512: at "CDR_W###_#####_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

2. In DM install log:
Unit Name=CDR_W###_#####_$CREATE_$CREATE_1
ORA-00942: table or view does not exist

Unit Name=CDR_W###_#####_$CREATE_$CREATE_1
ORA-00904: "T"."<TABLE_NAME>": invalid identifier

...

********** End of Execution phase, dumping residue buffered log message **********

Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_W###_#####_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-20200: *** ERROR: Error during Workarea Install : There are errors during OWB deployment. See install log for details.
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_DF_MODEL_INSTALL", line 2488
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 14093
ORA-06512: at "CDR_W###_#####_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

Changes

The issue occurs after changing a column's Oracle Name in Development Lifecycle, installing and promoting it to Quality Control Lifecycle.

Cause

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