WF_EVENT_SUBSCRIPTIONS

Subscription for Business Event System

Name Datatype Length Mandatory Comments
GUID RAW (16) Yes Event subscription global unique id
SYSTEM_GUID RAW (16) Yes System that this subscription should take action
SOURCE_TYPE VARCHAR2 (8) Yes Where the event comes from like ERROR, EXTERNAL or LOCAL
SOURCE_AGENT_GUID RAW (16)
From which agent the event comes from
EVENT_FILTER_GUID RAW (16) Yes What event this subscription is interested in
PHASE NUMBER

Order of subscriptions to take place when there are multiple subscriptions on an event. when phase is 100 or above, the subscription is considered deferred.
STATUS VARCHAR2 (8) Yes Subscription status which could be ENALBLED or DISABLED.
RULE_DATA VARCHAR2 (8) Yes Data that the rule function is interested in which could be KEY or MESSAGE
OUT_AGENT_GUID RAW (16)
Send the event to this agent
TO_AGENT_GUID RAW (16)
Retrive event from this agent
PRIORITY NUMBER

Subscription priority
RULE_FUNCTION VARCHAR2 (240)
Function to be run for this subscription
WF_PROCESS_TYPE VARCHAR2 (30)
Item type of a workflow to be invoked
WF_PROCESS_NAME VARCHAR2 (30)
Process in above item type to be invoked
PARAMETERS VARCHAR2 (4000)
Parameters to be passed in
OWNER_NAME VARCHAR2 (30)
Subscription owner name which usually is the product name
OWNER_TAG VARCHAR2 (30)
Subscription owner tag wich usually is the product short code
DESCRIPTION VARCHAR2 (240)
Description of the subscription
EXPRESSION VARCHAR2 (4000)
something that will be evaluated at runtime to further restrict if an event subscription rule applied
SECURITY_GROUP_ID VARCHAR2 (32)
identifier reserved for hosting environment
CUSTOMIZATION_LEVEL VARCHAR2 (1) Yes CUSTOMIZATION_LEVEL
LICENSED_FLAG VARCHAR2 (1) Yes LICENSED_FLAG
INVOCATION_ID NUMBER

INVOCATION_ID
MAP_CODE VARCHAR2 (30)
MAP_CODE

Usage:


  cursor cur_subscriptions(c_guid in varchar2) is
  select s.wf_process_name
  ,      s.wf_process_type
  ,      s.rule_function
  ,      s.source_type
  ,      s.description
  from   wf_event_subscriptions s
  where s.event_filter_guid = c_guid
  order by source_type;