Duplicate Subscription Registered For Business Event CS_WF_EVENT_SUBSCRIPTIONS_PKG.CS_SR_Verify_All
(Doc ID 2288745.1)
Last updated on JULY 14, 2020
Applies to:
Oracle Teleservice - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Symptoms
On : 12.1.3 version, Business Events
ACTUAL BEHAVIOR
---------------
There are multiple subscriptions registered to business even oracle.apps.jtf.cac.task.updateTask
STEPS
-----------------------
Multiple subscriptions displayed for business event oracle.apps.jtf.cac.task.updateTask when executing the following 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |