POXOTOTM.sqll Failed During 12.2 Upgrade (Doc ID 2219104.1)

Last updated on DECEMBER 30, 2016

Applies to:

Oracle Purchasing - Version 12.0.2 and later
Information in this document applies to any platform.

Symptoms

Performing 12.2 upgrade and received the following error:.

POXOTOTM.sql failed with the following errors:

Start time for file is: Mon Dec 26 2016 16:51:51

sqlplus -s APPS/***** @/ASCDEV_shared/app/ora/EBS/ASCDEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/ASCDEV_shared/app/ora/EBS/ASCDEV/fs1/EBSapps/appl/po/12.0.0/patch/115/sql/POXOTOTM.sql '
Connected.

PL/SQL procedure successfully completed.

DROP TYPE PO_OTM_ORDER_TYPE
*
ERROR at line 1:
ORA-04043: object PO_OTM_ORDER_TYPE does not exist


DROP TYPE PO_OTM_SCHEDULE_LINE_TBL
*
ERROR at line 1:
ORA-04043: object PO_OTM_SCHEDULE_LINE_TBL does not exist


CREATE OR REPLACE TYPE PO_OTM_SCHEDULE_LINE_TYPE AS OBJECT (
*
ERROR at line 1:
ORA-22308: operation not allowed on evolved type


Usage: { EXIT | QUIT } [ SUCCESS | FAILURE | WARNING | n |
   | : ] [ COMMIT | ROLLBACK ]


Time when worker failed: Mon Dec 26 2016 16:51:52

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