Search Results java_generate_func

Overview

WF_EVENTS_VL is a language (translated) view owned by the APPS schema in Oracle E-Business Suite, defined in the FND - Application Object Library product. It presents the business event definitions of the Workflow engine together with their language-specific, translatable attributes. Oracle EBS maintains many reference entities in a pair of tables: a base table holding language-independent data and a "_TL" table holding translated columns keyed by LANGUAGE. WF_EVENTS_VL joins those two sources and exposes a single, denormalized row per event in the session's running language, so that consumers do not have to perform the translation join themselves.

Because the view selects the translation row where LANGUAGE equals USERENV('LANG'), it always returns the display name and description in the language of the current session. The object is therefore the standard reporting and integration entry point for querying event metadata, and it is the source used by forms, concurrent programs, and custom code that need to list events with human-readable labels. In ETRM the object is registered with status VALID and is documented identically across 12.1.1 and 12.2.2.

Underlying Base Objects

The view text is a two-table join over the synonyms WF_EVENTS and WF_EVENTS_TL, both resolving to objects owned by the Workflow (WF) schema but referenced here through APPS:

• WF_EVENTS — the base table holding the language-independent event definition, aliased as B in the view text.
• WF_EVENTS_TL — the translation table holding display name and description per language, aliased as TL.

The join predicate is TL.GUID = B.GUID AND TL.LANGUAGE = USERENV('LANG'), ensuring exactly one translated row is returned per event for the session language. The ETRM metadata for 12.2.2 records the referenced base objects as the synonyms WF_EVENTS and WF_EVENTS_TL.

Key Columns

• ROW_ID — the ROWID of the WF_EVENTS row (B.ROWID), useful for direct row access.
• GUID — the globally unique identifier of the event; the join key between base and translation tables.
• NAME — the internal, language-independent event name used programmatically (for example in WF_EVENT APIs and subscriptions).
• TYPE — the event type classification.
• STATUS — the event's lifecycle/registration status.
• GENERATE_FUNCTION / JAVA_GENERATE_FUNC — the PL/SQL function and Java generator function used to raise the event.
• OWNER_NAME / OWNER_TAG — the owning application or component of the event definition.
• CUSTOMIZATION_LEVEL — indicates whether the event is seeded, extensible, or user-defined.
• LICENSED_FLAG — licensing indicator for the event.
• DISPLAY_NAME / DESCRIPTION — the translated, user-facing label and description from WF_EVENTS_TL.
• IREP_ANNOTATION — annotation used by the iRep (Internet Reporting) integration.

Common Use Cases and Queries

Typical scenarios include building event catalogs, diagnosing why a subscription is not firing, validating customization levels before upgrades, and feeding integration metadata to external systems. Because translations follow the session language, the same query returns localized labels for different users.

List all custom (non-seeded) events:

• SELECT name, display_name, owner_name, status FROM apps.wf_events_vl WHERE customization_level = 'User';

Resolve an event's readable label from its internal name:

• SELECT display_name, description, generate_function FROM apps.wf_events_vl WHERE name = 'oracle.apps.wf.notification.send';

Summarize events by owning application:

• SELECT owner_name, COUNT(*) FROM apps.wf_events_vl GROUP BY owner_name ORDER BY 2 DESC;

When language-independent values are required regardless of session language, query WF_EVENTS directly; use WF_EVENTS_VL whenever a localized, human-readable result set is needed.