Tuesday, 23 December 2014

adpatch - An error occurred while generating Oracle Forms library files. Continue as if it were successful


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: