This can be done in several ways. Below I have described the most easiest ones.
Option 1 - Use 'adadmin' utility to recompile all invalid objects in the database
1. Open a new terminal window and setup the application tier environment (see more info here How to setup environment for Application Tier at linux terminal?)
2. Start adadmin (see more info here How to use adadmin utility for enabling maintenance mode?)
3. Here you will be presented with a main menu:
4. Choose option 3 for 'Compile/Reload Applications Database Entities menu'
AD Administration Main Menu
--------------------------------------------------
1. Generate Applications Files menu
2. Maintain Applications Files menu
3. Compile/Reload Applications Database Entities menu
4. Maintain Applications Database Entities menu
5. Change Maintenance Mode
6. Exit AD Administration
5. A sub-menu will be displayed. Choose option 1 for 'Compile APPS schema'
Compile/Reload Applications Database Entities
---------------------------------------------------
1. Compile APPS schema
2. Compile menu information
3. Compile flexfields
4. Reload JAR files to database
5. Return to Main Menu
Option 2 - Manually compile a specific Invalid db object at SQL Prompt
1. Open a new terminal window and setup database environement
2. Login into sqlplus as 'SQLDBA'
sqlplus '/as sysdba';
3. Run the following command for the specific object:
alter [object] [object's name] compile
for example of your object is a 'package body' and obect's name is 'OKLABCD' the the command will be
alter package body OKLABCD compile
Option 3 - Using script on Database Tier
1. Open a new terminal window and setup database environement (see more info here How to setup environment for Database Tier at linux terminal?)
2. Go to following directory:
cd $ORACLE_HOME/rdbms/admin
2. Login into sqlplus as 'SQLDBA'
sqlplus '/as sysdba';
3. Run the following command for the specific object:
@utlrp.sql
Assumptions
- Oracle Database is up and running
Environment
- Oracle E Business Suite R12i
- Oracle Enterprise Linux 5.7