Getting PLS-00801 on compiling invalid objects which are invalid after applied patch

After you applied a few OE patches,you have invalid objects like OE%.After you run utlrp.sql,these object aren't gone.When you want one of these objects manually you get PLS-00801 error.

But these invalid objects can effect this module.

Problem:

Getting PLS-00801 on compiling invalid objects which are invalid after applied patch

We applied patch 10338643,this patch solved problem,but it generate 5 invalid in apps schema.



Invalid objects:

OE_ORDER_GRP
OE_OE_FORM_LOT_SERIAL
OE_DEFAULT_LOT_SERIAL
OE_DEFAULT_LINE_PATTR
OE_OE_FORM_HEADER_PAYMENT

Error Codes
---------------------------------------------------
PLS-00801

Solution:

1) start database in UPGRADE mode
(using STARTUP UPGRADE or ALTER DATABASE OPEN UPGRADE)

2) Run script $ORACLE_HOME/rdbms/admin/utlirp.sql
You must be connected AS SYSDBA to run this script.

3) Shut down the database and restart in normal mode

4) Run script $ORACLE_HOME/rdbms/admin/utlrp.sql
You must be connected AS SYSDBA to run this script.
There should be no other DDL on the database while running the script.


Note:It is very important and took 4 hours on my database which have 315000 objects

PLS-00801 reduce invalid objects

Problem:

I applied patch 10338643,this patch was solved my problem,but it generate 5 invalid in apps schema.

Invalid objects:

OE_ORDER_GRP
OE_OE_FORM_LOT_SERIAL
OE_DEFAULT_LOT_SERIAL
OE_DEFAULT_LINE_PATTR
OE_OE_FORM_HEADER_PAYMENT

I compiled apps schema via adadmin,I compiled these packages via alter package  <package_name> compile;but these packages are
invalid.I am getting PLS-00801 on compiling this objects.I followed this document below:

Getting PLS-00801 on compiling various ONT packages [ID 1062560.1]
Then I create a SR,then my problem was resolved.

Solution:

as a database user

sqlplus / as sysdba

SQL>shutdown immediate;
SQL>startup nomount
SQL>alter system set "_disable_fast_validate"=TRUE SCOPE=pfile
SQL>create spfile from pfile
SQL>shutdown immediate;
SQL>startup upgrade;
SQL>@?/rdbms/admin/utlirp.sql
SQL>shutdown immediate
SQL>startup
SQL>@?/rdbms/admin/utlrp.sql

All objects will be invalid via utlirp.sql,then utlrp.sql will compile them.

Note:"?" means $ORACLE_HOME