Recompile all invalid objects ADCOMPSC.pls

How can I recompile all my invalid objects using ADCOMPSC.pls?
=================================================================

Within Applications, there is a script to compile INVALID objects - called ADCOMPSC.pls

Arguments for ADCOMPSC.pls:
1 - Schema to run in
2 - Password for schema
3 - Check errors for objects starting with #3

NOTE:      The order in which to compile Invalid Objects in schemas is
    SYS, SYSTEM, APPS and then all others.  APPS_DDL and APPS_ARRAY_DDL
        should exist in all schema's.  If you encounter an ORA-1555 error
        while running adcompsc.pls, just restart the script.

The script can be run as follows:

cd $AD_TOP/sql
sqlplus @adcompsc.pls SCHEMA_NAME SCHEMA_PASSWORD %

Example:  SQL> @adcompsc.pls apps apps %


What if I still have invalid objects than can not be resolved by ADCOMPSC.pls?
==============================================================================

If there are any objects still left INVALID, you can verify them by using
aderrchk.sql to record the remaining INVALID objects.  Aderrchk.sql use the
same syntax as adcompsc.pls.  This script is also supplied with the
Applications. You can send the aderrchk.sql to a file using the
spool command in sqlplus.

e.g. sqlplus x/y @aderrchk.sql SCHEMA_NAME SCHEMA_PASSWORD %

For objects will not compile, try the following:

select text
from user_source
where name = 'OBJECTNAME'
and text like '%Header%';

This script will give you the sql that creates the packages.  You can then
recreate the packages.  SQL>@packageheader     SQL>@packagebody
If recreating the package does not make the package valid you will have to
analyze the user_errors table to try to determine the cause of the invalid
package.

select text
from user_errors
where name = 'PACKAGENAME';

11.5.10.2 to 12.1.3 upgrade on IBM-AIX

Sorry folks for late reply. In busy schedule i am not able to get the time for update.

Upgrade steps---

Set Application R12.1.1 Enviornment file
Drop MRC schema (conditional)
Ensure that Maintenance Mode is enabled
R12 pre upgarde patch  9179588 (9179588:R12.AD.B), 7461070.R12 and 9477107.B
R12 Pre upgrade patches --Related to Functional---check on metalink


Configure and start Server Processes
Run Rapidwiz  for configure the Application services



Update database tier nodes with the Oracle E-Business Suite Release 12.1.1 code level.
Generate the appsutil file in the apps node and copy it to the DB node
unzip the appsutil file and run the autoconfig on the DB node
Run autoconfig on Database Tier
Run autoconfig on Application Tier



R12.1.1 Post Upgrade Task
Re-enable custom triggers and indexes (conditional)


OATM Tablespace migration
Execute the OATM Tool


Upgrade to 12.1.3 (Metalink Note---1080973.1)
Patch 9239089 R12.AD.B.Delta.3
Patch 9239090 12.1.3
Patch 9239095 12.1.3 online Help
Patch 9817770 R12.ATG_PF.B  (POST UPGRADE PATCH)
Patch 9966055 R12.FND.B  (POST UPGRADE PATCH)


Update database tier nodes with the Oracle E-Business Suite Release 12.1.3 code level.
Generate the appsutil file in the apps node and copy it to the DB node
unzip the appsutil file and run the autoconfig on the DB node
Run autoconfig on Database Tier
Run autoconfig on Application Tier


Run HRGLOBAL.DRV  (Metalink Note---145837.1)


Post Upgrade Task
Regenerate forms,reports,messages and product jar files
Compile invalid objects if any is there in APPS schema
Compile JSP
Disable Maintenance Mode and Start the Application Services

If anyone need any kind of help then do not hesitate to send me an email. (devesh288@gmail.com)