Monday 6 June 2016

Issues While Re-starting 12.2.4 RUP Patch 17919161 Failed With ORA-04063, ORA-06508, ORA-06512 on FND_CONC Package Invalid

When applying Oracle E-Business Suite 12.2.4 Release Update Pack Patch 17919161 on the run edition application environment, using downtime mode getting the error below:

$ adop phase=apply apply_mode=downtime patches=17919161 restart=yes

Error:

SQL> select ad_zd_adop.is_icm_alive() from dual
  *
ERROR at line 1:
ORA-04063: package body "APPS.FND_CONC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_CONC"
ORA-06512: at "APPS.AD_ZD_ADOP", line 1635
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[UNEXPECTED] Error occurred

Cause:

An invalid FND_CONC package.

The error in the adop log file shows the following object is invalid and it needs to be validated so the patch can continue:

ERROR at line 1:
ORA-04063: package body "APPS.FND_CONC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_CONC"
ORA-06512: at "APPS.AD_ZD_ADOP", line 1635


Fix:

1. Run the script $FND_TOP/patch/115/sql/AFCPDIGB.pls to validate the FND_CONC package:

sqlplus apps/<appspwd> @$FND_TOP/patch/115/sql/AFCPDIGB.pls

2. Re-run adop.

Ref: (Doc ID 1926427.1)

No comments:

Post a Comment