FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching

Symptoms:

After applying patches, FND_CP_GSM_OPP_AQ queue becomes invalidated. The patches can be any, including Technology patches like (FND,OWF, OAF) or functional patches like (AP, AR,OM etc).
ORA-600 [kqludp2] is seen in the alert log.

The PL/SQL Call Stack may have elements of the following:
package body SYS.DBMS_RULE_ADM
anonymous block
package body SYS.DBMS_AQADM_SYS
package body SYS.DBMS_PRVTAQIS
package body SYS.DBMS_AQADM_SYS
package body SYS.DBMS_AQADM
package body APPS.FND_CP_OPP_IPC
The call stack may look similar to the following:
kgerinv kgeasnmierr kqludp kwraadr kwriadr spefcmpa spefmccallstd pextproc peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrrun peicnt <- kkxexe

Solution:

Patch application (or) Validating and Compiling the Apps schema while Output Post processor (OPP) is up and running.

If the OPP service is running and there are messages in FND_CP_GSM_OPP_AQ queue, applying patches will invalidate this queue. The patch/patches internally validate and compile the schema making the data in the queue to be inconsistent.
If OPP service is not running then all requests that use XML Publisher transformation will fail and if FND_CP_GSM_OPP_AQ queue is not up and running, the OPP service fails to start.

1. Recreate the queue using  $FND_TOP/patch/115/sql/afopp002.sql file as 'APPLSYS' user.  On running the script you will be prompted for username and password.
2. Republish those requests to get the real output generated by applying the template.

References:

FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching [ID 311851.1]

Get Oracle Certifications for all Exams
Free Online Exams.com