Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EBS R12.0.6 upgrade to 12.2.7 -  Apply the Online Patching Enablement patch

Beauty_and_dBestApr 11 2019 — edited Feb 9 2021

Hi ALL,

We are now in step >

  • Apply the Online Patching Enablement patch

Apply Patch # 13543062

$ cd 13543062

$ adpatch options=hotpatch,forceapply

Then I encounter failed worker :

1. Facing issue while applying the 13543062:R12.ADC patch (ADOP enablement patch). The error details as below:-

FAILED file ADZDPREP.sql on worker 1

sqlplus -s APPS/***** @/mnt/applmgr/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/mnt/applmgr/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsstats.sql '

Connected.

PL/SQL procedure successfully completed.

declare

*

ERROR at line 1:

ORA-20000: ORA-20001: APPS.GL_DSC_ACRONYM is an invalid identifier Error while

executing

FND_STATS.GATHER_SCHEMA_STATISTICS package.

ORA-06512: at line 98

I have been encountering this APPS.GL_DSC_ACRONYM with almost all of my patches

I just skip it so I can proceed.

Please help how to cure this bug? or is this part of ADGRANTS.sql?

Kind regards,

jc

This post has been answered by Shaik on Apr 11 2019
Jump to Answer
Comments
Post Details
Added on Apr 11 2019
2 comments
92 views