APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 37,356 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    March 2009
    M T W T F S S
    « Feb   Apr »
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  
  • Archives

  • Authors

Invalid Objects

Posted by appsinfo on March 11, 2009

When Invalid Objects are created

 

  1. Applying patches can create Invalid objects. 
  2. It has been experience that while applying some patches the patch fails this is due to invalid objects, complying invalid objects and reapplying will resolve the issue. 
  3. Technical consultant working on packages may generate invalid objects and require recompilcation 
  4.  Use adadmin utility to complie the apps schema for invalid objects related to apps user

 Simple query

 

SELECT COUNT(*) FROM DBA_OBJECTS WHERE STATUS = ‘INVALID’;

 

Detailed Query

 

SELECT OWNER, OBJECT_TYPE, COUNT(*) FROM DBA_OBJECTS WHERE STATUS = ‘INVALID’ GROUP BY OWNER, OBJECT_TYPE;

 

Recompile and individual objects

 

Connect as application user “apps”

 

alter package <package_name> compile; (package specification)

alter package <package_name> compile body; (package body)

alter view <view_name> compile; (view)

 

If objects compile with warning use

 

show errors

or

select * from user_errors where name = ‘<OBJECT_NAME>’;

 

Using adadmin Utility

 

  1. Log on as Apps User (applmgr/applmgr)
  2. Source the enviornment file
  3. run adadmin
  4. Under the Maintain Applications Database Objects Menu, select Compile APPS schema(s)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: