Installation of Load Set Fails with ORA-20200 After Column Added Using Metadata File (Doc ID 1427307.1)

Last updated on FEBRUARY 19, 2023

Applies to:

Symptoms

When the structure of a Table Descriptor for a Text Load Set or a SAS Load Set is changed using a
metadata file, e.g. adding an additional column called 'COL1', the installation of Load set fails with the
following error message in the job log:

Trying to handle the unmapped target table descriptors
******************** WITHIN HANDLE VIEW PROGRAMS***********************

Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin
CDR_W1_1620101_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;"
caught:java.sql.SQLException: ORA-20200: *** ERROR: Exception while trying to install the
workarea User-Defined Exception
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 8661
ORA-06512: at "CDR_W1_1620101_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

Excerpts of error message from the OWB log are:

java.sql.SQLException: ORA-00904: "COL1": invalid identifier
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)
at oracle.jdbc.driver.T2CStatement.executeForDescribe

java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661)
at oracle.jdbc.driver.T2CStatement.executeForDescribe

oracle.apps.cdr.dbserver.exec.server.CdrOperatorException: while executing statement statement:
"begin CDR_W1_1620101_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;"
caught:java.sql.SQLException: ORA-20200: *** ERROR: Exception while trying to install the
workarea User-Defined Exception
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 8834
ORA-06512: at "CDR_W1_1620101_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

Cause

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