My Oracle Support Banner

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 JANUARY 16, 2018

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.