My Oracle Support Banner

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

Last updated on APRIL 04, 2025

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

Changes

 

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
Changes
Cause
Solution


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