FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching; May Trigger ORA-00600 [kqludp2] (Doc ID 311851.1)

Last updated on AUGUST 07, 2024

Applies to:

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

kqludp <- kwraadr <- kwrxadr <- spefcmpa <- spefmccallstd <- pextproc <- peftrusted <- psdexsp <- rpiswu2 <- psdextp <- pefccal <- pefcal <- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- opiall0 <- opikpr <- opiodr <- rpidrus <- skgmstack <- rpiswu2 <- kprball <- kwqaadqrs <- kwqaasub <- spefcmpa <- spefmccallstd <- pextproc <- peftrusted <- psdexsp <- rpiswu2 <- psdextp <- pefccal <- pefcal <- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool

Changes

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

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.