This discussion is archived
2 Replies Latest reply: Jan 31, 2013 12:06 AM by user3714906 RSS

invalid objects in apps schema

user3714906 Newbie
Currently Being Moderated
Hi,

I have 5 invalid objects in apps schema in Production in R12

SQL> select owner, object_name,object_type from dba_objects where status ='INVALID';

OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------------ -------------------
APPS XXASS_AR_GET_CUSTBAL_PKG PACKAGE BODY
APPS XXGNC_SSHR_PAYSLIP PACKAGE BODY
APPS HR_EMPLOYEE_BK1 PACKAGE BODY
APPS IGI_IAC_REINSTATE_PKG PACKAGE BODY
APPS IGI_IAC_RETIREMENT PACKAGE BODY

Can I run utlrp.sql to compile them or I have to use adadmin to compile whole apps schema?

Regards

Edited by: user3714906 on Jan 30, 2013 11:30 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points