My Oracle Support Banner

After 12.2.7 Upgrade Some ONT Objects Are Invalid. How To Resolve? (Doc ID 2396857.1)

Last updated on JUNE 13, 2022

Applies to:

Oracle Order Management - Version 12.2.7 and later
Information in this document applies to any platform.

Goal

After upgrading to 12.2.7 there are still the three (3) pll files which do not compile
successfully due to the OE_ORDERORG_GTT issue:
au resource OEXOEGWY.pll
au resource OEXOEFRM.pll
au resource OEXOETRE.pll

SQL> SELECT * FROM ALL_SYNONYMS
2 WHERE synonym_name LIKE '%OE_ORDERORG_GTT%';
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
ORIGIN_CON_ID
APPS OE_ORDERORG_GTT ONT OE_ORDERORG_GTT 0
APPS OE_ORDERORG_GTT1 ONT OE_ORDERORG_GTT1 0



Please assist on getting them valid.
 

Solution

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
Goal
Solution
References


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