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)
$ 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