Results for “wf_event_groups”

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

Overview

WF_EVENT_GROUPS is a Business Event System (BES) configuration table owned by the APPLSYS schema and delivered under the FND — Application Object Library product in Oracle E-Business Suite 12.1.1 and 12.2.2. It defines the composition of event groups — named collections of individual business events — that the Workflow Business Event System uses to register, subscribe, and propagate events as a logical unit. Rather than subscribing to each event separately, an application or agent can subscribe to a single event group, and every member event raised within the EBS instance is evaluated against that group membership.

The table is a pure association, or link, entity: each row pairs one group event with one member event. Both endpoints resolve back to WF_EVENTS through foreign keys, so the same table stores both the grouping event and its members. Its heuristic Data Vault classification, mined from the documented foreign key structure, is a link, sitting between two references to the WF_EVENTS hub. It is not a hub (it carries no independent business key of its own beyond the pair) and not a satellite (it stores no descriptive, time-variant attributes about a single parent).

Key Information Stored

The documented physical schema contains four columns. The table is narrow and structurally an intersection, so only a small set of columns carry meaning:

• GROUP_GUID — the globally unique identifier of the grouping event. This is the parent side of the link and a foreign key to WF_EVENTS.
• MEMBER_GUID — the globally unique identifier of the member event contained in the group. This is the child side of the link and also a foreign key to WF_EVENTS.
• SECURITY_GROUP_ID — the security group (operating unit / data partition) under which the group membership applies; foreign key to FND_SECURITY_GROUPS. It supports multi-organization and data-restriction filtering.
• ZD_EDITION_NAME — the editioning marker introduced with the AD Online Patching / edition-based redefinition model in 12.2.x; it participates in the unique index WF_EVENT_GROUPS_U1 and is not present in 12.1.1.

The surrogate primary key is WEP_PK, defined over (GROUP_GUID, MEMBER_GUID). The documented unique index WF_EVENT_GROUPS_U1 covers (MEMBER_GUID, GROUP_GUID, ZD_EDITION_NAME); this serves as the business-key candidate, ensuring that a given member appears at most once per group per edition. The pair (GROUP_GUID, MEMBER_GUID) is therefore both the physical PK and the natural key.

Common Use Cases and Queries

Typical uses include resolving the full member list of a group subscription, identifying which groups a given event belongs to before raising it, and validating event group configuration during implementation or post-clone review.

• List the members of a group: join twice to WF_EVENTS, once on GROUP_GUID and once on MEMBER_GUID, with a WHERE clause on the group GUID.
• Reverse lookup — find every group containing an event: filter on MEMBER_GUID.
• Security-scoped reporting: add a predicate on SECURITY_GROUP_ID, or join to FND_SECURITY_GROUPS, to restrict results to a single operating unit.
• Integrity audit: use the two foreign keys to WF_EVENTS to detect group references whose target event has been deactivated or removed (orphaned membership rows).

A representative pattern is: SELECT g.GROUP_GUID, g.MEMBER_GUID FROM APPLSYS.WF_EVENT_GROUPS g WHERE g.GROUP_GUID = :p_group, then joining the member GUID back to WF_EVENTS for the human-readable event name and status.

Related Objects

WF_EVENT_GROUPS is closely bound to the following objects:

• WF_EVENTS — referenced twice via GROUP_GUID and MEMBER_GUID; supplies the event definitions on both sides of the link.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; enforces data partitioning.
• WF_EVENT_GROUP_MEMBERS and related BES views — commonly used with WF_EVENT_GROUPS for resolving group composition at runtime.
• WF_SYSTEMS and WF_AGENTS — subscribe to, or route, events that may be grouped here.
• WF_SUBSCRIPTIONS — evaluates group membership when filtering which raised events trigger a subscriber.
• WF_EVENT_GROUP_UTIL / WF_EVENT_FUNCTIONS — PL/SQL utilities that manipulate and inspect event group membership.

These relationships make WF_EVENT_GROUPS a critical junction in the Business Event System’s subscription and propagation model.