1)Currently we have issue with Patch 21841299:R12.AD.C.(DELTA 8).

2)In worker log below is the error message, As the issue in worker log adop session still remains hangs. And in adctrl we can see that worker status running but its not performing any action
for many hours, So we  forcefully existed the session.


ms/java:/u01/apps/
fs1/EBSapps/10.1.2/forms/java/frmall.jar:/u01/apps/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/u01/apps/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"

Calling /u01/apps/fs1/EBSapps/comn/util/jdk32/jre/bin/java ...
Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 114
ORA-06512: at "APPS.AD_ZD_CTX", line 13
ORA-06512: at line 1

3)Next we removed the current application and database and restored from the previous backup(Before the Delta 8 patch).

4) Analysis for Delta 8 patch

As per error message in worker log worker is looking for object "APPS.AD_ZD_CTX" package, but the object doesnot exists in database, the object is  created by "ADZDCTXS.pls,ADZDCTXS.pls". As this object creation is the
part of application(21841299 delta 8 patch). Also we observed that only "ADZDCTXS.pls,ADZDCTXS.pls" are not copying to $AD_TOP/patch/115/sql while copy portion activity of driver u21841299.drv.

5) Before applying the 21841299, we manually created the AD_ZD_CTX package using the "ADZDCTXS.pls,ADZDCTXS.pls" from patch top (21841299).

6)Next we applied the patch as specifed in doc. Which went sucessful without any issues.


$ adop phase=apply patches=21841299 hotpatch=yes


7)Also we analyzied the Patch 20745242 (R12.AD.C.Delta.7

AD_ZD_CTX object is created as part of patch 20745242, so the users didnt got any issue.


Conclusion ::   While applying patch 21841299, patch itself is not creating the package AD_ZD_CTX. Due to this issue occured.