Find Package Bodies (OE_DEFAULT_CONTRACT,OE_DEFAULT_PRICE_BREAK,OE_OE_FORM_CONTRACT,OE_OE_FORM_PRICE_BREAK) Invalid After 12.1 Upgrade (Doc ID 1055187.1)

Last updated on DECEMBER 02, 2015

Applies to:

Oracle Advanced Pricing - Version 11.5.10 and later
Oracle Inventory Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
Affected Database: Oracle



Symptoms


On : 12.1.1 version, Install / Upgrade

When attempting to upgrade from 11.5.9 to 12.1.1, several objects did not compile and
the following errors occur.

ERROR
-----------------------
SQL> select text from user_errors where name='OE_DEFAULT_CONTRACT';

TEXT
------------------------------------------------------------------------
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored

10 rows selected.
2.
SQL> select text from user_errors where name='OE_DEFAULT_PRICE_BREAK';

TEXT
---------------------------------------------------------------------------
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored

20 rows selected.
3.
SQL> select text from user_errors where name='OE_OE_FORM_CONTRACT';

TEXT
------------------------------------------------------------------------
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
4.
SQL> select text from user_errors where name='OE_OE_FORM_PRICE_BREAK' ;

TEXT
-------------------------------------------------------------------------
PLS-00801: internal error [1401]
PL/SQL: Statement ignored


A)
1.
SQL> select text from user_errors where name='OE_DEFAULT_CONTRACT';

TEXT
------------------------------------------------------------------------
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored
PLS-00801: internal error [1401]
PL/SQL: Statement ignored

10 rows selected.



NOTES
---------
11.5.9 CU2 patch 3171663 and OM pre-req patch 3234019 was applied to the 11.5.9 instance.
The invalid packages are:

OE_DEFAULT_CONTRACT OEXDPCTB.pls 115.0
OE_DEFAULT_PRICE_BREAK OEXDDPBB.pls 115.0
OE_OE_FORM_CONTRACT OEXFPCTB.pls 115.0
OE_OE_FORM_PRICE_BREAK OEXFDPBB.pls 120.1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgraded test instance from 11.5.9 to 12.1.1
2. Found 4 packages which failed to recompile and are invalid
3. Manually recompiling thes packages fails

Changes

Usually this is needed to switch bit versions of Oracle (ie 32 to 64 or the reverse).

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