Results for “wf_event_subscriptions”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The WF_EVENT_SUBSCRIPTIONS table, owned by the APPLSYS schema, is the core configuration repository for the Oracle Workflow Business Event System (BES) within Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the FND — Application Object Library product family and stores subscription definitions that determine how business events raised by applications, concurrent programs, or external systems are delivered to agents, workflows, and rule functions. Each row represents a single subscription, describing what event is being monitored, which system and agent it applies to, under what phase it executes, and what action should be performed when the event fires.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as a link table. This reflects its heavy reliance on foreign key relationships that connect independent hubs such as systems, agents, and events. The suggested classification is a modeling convenience rather than a physical constraint; the table itself is a normalized EBS entity with a GUID-based surrogate primary key.

Key Information Stored

The table contains 30 documented columns. The most operationally significant include:

• GUID — the unique identifier for the subscription, and part of the business unique index WF_EVENT_SUBSCRIPTIONS_U1 (GUID, ZD_EDITION_NAME).
• WEN_PK — the documented primary key of the table, referenced when searching on subscription identity.
• SYSTEM_GUID — foreign key to WF_SYSTEMS, identifying the source system for the subscription.
• SOURCE_TYPE, SOURCE_AGENT_GUID — define the origin of the event and, where applicable, the source agent.
• EVENT_FILTER_GUID — foreign key to WF_EVENTS, specifying the event being subscribed to.
• PHASE, STATUS, PRIORITY — control when the subscription fires, whether it is enabled, and its execution order.
• OUT_AGENT_GUID and TO_AGENT_GUID — foreign keys to WF_AGENTS defining the outbound and destination agents.
• RULE_FUNCTION, RULE_DATA, EXPRESSION, JAVA_RULE_FUNC — the executable logic and Boolean filtering used to invoke the subscription.
• WF_PROCESS_TYPE, WF_PROCESS_NAME — identify the workflow process launched by the subscription.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS enforcing data access boundaries.
• OWNER_NAME, OWNER_TAG, CUSTOMIZATION_LEVEL, LICENSED_FLAG — metadata used for ownership, customization tracking, and licensing.
• ACTION_CODE, ON_ERROR_CODE, MAP_CODE — control the resulting action and error handling behavior.

Common Use Cases and Queries

Administrators commonly query WF_EVENT_SUBSCRIPTIONS to audit which subscriptions are active for a given event, to troubleshoot why a business event did not trigger its associated workflow, or to report on custom subscriptions that may be affected by patching. A typical query joins to WF_EVENTS and WF_AGENTS:

• SELECT s.GUID, s.STATUS, s.PHASE, s.PRIORITY FROM WF_EVENT_SUBSCRIPTIONS s WHERE s.EVENT_FILTER_GUID = :event_guid AND s.STATUS = 'ENABLED';
• Reporting disabled or erroring subscriptions by joining ON_ERROR_CODE and ACTION_CODE.
• Identifying orphaned subscriptions by outer-joining to WF_SYSTEMS and WF_AGENTS.

Related Objects

The table participates in several documented foreign key relationships:

• WF_AGENTS — referenced through OUT_AGENT_GUID and TO_AGENT_GUID.
• WF_EVENTS — referenced through EVENT_FILTER_GUID.
• WF_SYSTEMS — referenced through SYSTEM_GUID.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID.

These relationships make WF_EVENT_SUBSCRIPTIONS the central link between event definitions, agent delivery paths, and system boundaries within the Business Event System.