Duplicate Subscription Registered For Business Event CS_WF_EVENT_SUBSCRIPTIONS_PKG.CS_SR_Verify_All

Last updated on JULY 21, 2017

Applies to:

Symptoms

On : 12.1.3 version, Business Events

ACTUAL BEHAVIOR
---------------
See multiple subscriptions running for CS_WF_EVENT_SUBSCRIPTIONS_PKG.CS_SR_Verify_All
(also check oracle.apps.jtf.cac.task.updateTask)

STEPS
-----------------------
Run this select statement:

SELECT *
FROM
 (
 SELECT ES.GUID AS GUID -- PK, GUID
   ,
   ES.SYSTEM_GUID AS SYSTEM_GUID -- FK - WF_SYSTEMS.GUID
   ,
   SY.NAME AS SYSTEM_NAME -- SYSTEM NAME
   ,
   L1.LOOKUP_CODE AS SOURCE_TYPE -- LOCAL | EXTERNAL | ANY
   ,
   ES.SOURCE_AGENT_GUID -- FK to WF_AGENTS
   ,
   DECODE(LENGTH(NVL(AGT1.NAME,' ')),1,' ',AGT1.NAME
   ||'@'
   ||SY.NAME) AS SOURCE_AGENT_NAME -- SOURCEAGENT
   ,
   ES.EVENT_FILTER_GUID -- FK to WF_EVENTS
   ,
   EV.NAME AS EVENT_FILTER_NAME -- EVENT FILTER NAME
   ,
   ES.PHASE -- execution order
   ,
   L2.LOOKUP_CODE AS STATUS -- ENABLED | DISABLED
   ,
   ES.RULE_DATA -- KEY | MESSAGE
   ,
   ES.OUT_AGENT_GUID -- outbound agent
   ,
   DECODE(LENGTH(NVL(AGT2.NAME,' ')),1,' ',AGT2.NAME
   ||'@'
   ||SY.NAME) AS OUT_AGENT_NAME -- OUTAGENTNAME
   ,
   ES.TO_AGENT_GUID -- destination agent
   ,
   DECODE(LENGTH(NVL(AGT3.NAME,' ')),1,' ',AGT3.NAME
   ||'@'
   ||SY.NAME) AS TO_AGENT_NAME -- TO AGENT NAME
   ,
   ES.PRIORITY -- 1-100 message priority
   ,
   ES.RULE_FUNCTION -- code to run
   ,
   ES.WF_PROCESS_TYPE -- workflow item type
   ,
   IT.DISPLAY_NAME AS ITEM_DISPLAY_NAME -- workflow item display name
   ,
   ES.WF_PROCESS_NAME -- workflow process name
   ,
   DECODE(LENGTH(NVL(ES.WF_PROCESS_TYPE,' ')),1,' ',(ES.WF_PROCESS_TYPE
   ||'/'
   ||ES.WF_PROCESS_NAME)) AS PROCESS_DISPLAY_NAME ,
   ES.PARAMETERS -- other parameters
   ,
   ES.OWNER_NAME -- owning program
   ,
   ES.OWNER_TAG -- owning program tag
   ,
   ES.EXPRESSION -- sql rule
   ,
   ES.DESCRIPTION -- TL (on base table)
   ,
   'N' AS SELECT_FLAG ,
   L1.MEANING AS SOURCE_TYPE_MEANING ,
   L2.MEANING AS STATUS_MEANING ,
   L3.LOOKUP_CODE AS CUSTLEVEL ,
   L3.MEANING AS CUSTLEVEL_MEANING ,
   ES.LICENSED_FLAG ,
   ES.ON_ERROR_CODE ,
   ES.ACTION_CODE ,
   ES.JAVA_RULE_FUNC ,
   ES.MAP_CODE ,
   ES.STANDARD_TYPE ,
   ES.STANDARD_CODE ,
   (SELECT meaning
   FROM apps.FND_LOOKUPS
   WHERE lookup_code = NVL(ES.ACTION_CODE, 'CUSTOM_RG')
   ) AS ACTION ,
   NVL(ES.RULE_FUNCTION, 'java://'
   ||ES.JAVA_RULE_FUNC) AS RULE_FUNCTION_NAME
 FROM apps.WF_EVENT_SUBSCRIPTIONS ES ,
   apps.WF_SYSTEMS SY ,
   apps.WF_EVENTS EV ,
   apps.WF_AGENTS AGT1 ,
   apps.WF_AGENTS AGT2 ,
   apps.WF_AGENTS AGT3 ,
   (SELECT name,
     display_name
   FROM apps.WF_ITEM_TYPES_TL
   WHERE language=userenv('LANG')
   ) IT ,
   (SELECT B.ITEM_TYPE,
     B.NAME PROCESS_NAME
   FROM apps.WF_ACTIVITIES B
   WHERE B.RUNNABLE_FLAG = 'Y'
   AND B.TYPE = 'PROCESS'
   AND sysdate BETWEEN B.BEGIN_DATE AND NVL(B.END_DATE, sysdate)
   ) PS ,
   apps.FND_LOOKUPS L1 ,
   apps.FND_LOOKUPS L2 ,
   apps.WF_LOOKUPS L3
 WHERE ES.SYSTEM_GUID = SY.GUID
 AND L1.LOOKUP_CODE = ES.SOURCE_TYPE
 AND L1.LOOKUP_TYPE = 'WF_BES_SOURCE_TYPE'
 AND L2.LOOKUP_CODE = ES.STATUS
 AND L2.LOOKUP_TYPE = 'FND_WF_BES_STATUS'
 AND ES.EVENT_FILTER_GUID = EV.GUID
 AND ES.SOURCE_AGENT_GUID = AGT1.GUID (+)
 AND ES.OUT_AGENT_GUID = AGT2.GUID (+)
 AND ES.TO_AGENT_GUID = AGT3.GUID (+)
 AND ES.WF_PROCESS_TYPE = IT.NAME (+)
 AND ES.WF_PROCESS_NAME = PS.PROCESS_NAME (+)
 AND ES.WF_PROCESS_TYPE = PS.ITEM_TYPE (+)
 AND L3.LOOKUP_CODE = ES.CUSTOMIZATION_LEVEL
 AND L3.LOOKUP_TYPE = 'WF_CUSTOMIZATION_LEVEL'
 ) QRSLT
WHERE ( ( (EVENT_FILTER_name = 'oracle.apps.jtf.cac.task.updateTask' ) ) )

Changes

Cause