How to compile apps schema in Oracle applications R12



How to compile apps schema (or invalid objects in database) in Oracle applications R12

1.       Connect to Database Tier
[ora@sujeet ~]$ cd $ORACLE_HOME/rdbms/admin
[ora@sujeet admin]$ sqlplus / as sysdba

Find how many Invalid objects. (Here 182 row select).
SQL> select object_name, owner, object_type from all_objects where status= 'INVALID';
182 rows selected.
Run below scripts:-
SQL> @utlrp.sql
Again check Invalid objects. (Here 0 row select).
SQL> select object_name, owner, object_type from all_objects where status= 'INVALID';
no rows selected

2. From application tier (using adadmin)
a) Login as application tier user.
b) Set environment variable.
c) Run “adadmin”
d) option 3 “compile/reload Applications Database Entities menu
e) option 1 “Compile Apps Schema”


3. From SQL (Individual objects)
a) Identity Invalid Object

SQL> select object_name, owner, object_type from all_objects where status= 'INVALID';
b) SQL> alter [object] [object_name] compile;

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...