R12 AP/XLA: xlaaxuap.sql Failed With ORA-00942: Table or View Does Not Exist During Upgrade From R12.1.3 To R12.2 (Doc ID 2166763.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


During upgrade from REL12.1.3 to REL12.2,
xlaaxuap.sql script failed with the following error.

ERROR

sqlplus -s APPS/***** @/u01/app/oracle/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/app/oracle/fs1/EBSapps/appl/xla/12.0.0/patch/115/sql/xlaaxuap.sql &un_ax &batchsize'
Connected.

PL/SQL procedure successfully completed.

AX_DOCUMENT_STATUSES AD,
*
ERROR at line 549:
ORA-06550: line 549, column 3:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 268, column 9:
PL/SQL: SQL Statement ignored


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