Error while applying patch
++ When you check the worker log in $APPL_TOP/admin/SID/log
ERROR generating library "resource/ASTACLIB.plx" from input file
/u01/dev/apps/apps_st/appl/au/12.0.0/resource/ASTACLIB.pll
Results of library generation:
(from file /u01/dev/apps/apps_st/appl/au/12.0.0/resource/ASTACLIB.err
AD Worker has deleted the original .err file)
-------------------------------------------------------------------------
Compilation errors on OTS_ACCESS:
PL/SQL ERROR 905 at line 4, column 63
object APPS.AS_API_RECORDS_PKG is invalid
PL/SQL ERROR 0 at line 4, column 22
Declaration ignored
PL/SQL ERROR 0 at line 0, column 0
Automatic recompile of Package Spec OTS_ACCESS failed
Compilation errors on ASTCUACT_NEW_ACCT:
PL/SQL ERROR 0 at line 159, column 7
Statement ignored
Failed to generate library.
FRM-30312: Failed to compile the library.
Solution:
Compile the invalid object APPS.AS_API_RECORDS_PKG and continue the patch
Alter package AS_API_RECORDS_PKG compile;
Alter package AS_API_RECORDS_PKG compile body;
SQL> alter package apps.ASO_SECURITY_INT compile;
SQL> alter package apps.ASO_SECURITY_INT compile body;
SQL> alter package apps.ASO_QUOTE_PUB_W compile body;
SQL> alter package apps.ASO_QUOTE_HEADERS_PVT compile body;
SQL> alter package apps.ASO_OPP_QTE_PUB compile body;
if needed execute below to compile other invalid objects using below script.
select 'alter ' ||
decode(object_type, 'PACKAGE BODY', 'package', object_type) ||
' ' ||
object_name||
' compile' ||
decode(object_type, 'PACKAGE BODY', ' body;', ';')
from dba_objects
where status = 'INVALID' and owner='APPS'
/
No comments:
Post a Comment