Search Results wf_activities_vl




Overview
Explore in AI Chat

Overview

WF_ACTIVITIES_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 functions as the translatable, user-facing representation of the Workflow Activities definition maintained by Oracle Workflow. Workflow activities are the discrete executable units that a workflow process invokes at each node, and WF_ACTIVITIES_VL exposes their technical attributes alongside language-dependent display text, allowing reports, forms, and integration programs to present activity information in the session's current language.

Because it is a view rather than a table, WF_ACTIVITIES_VL does not store data of its own. Instead it resolves the language-specific display name and description at runtime, which is the standard Oracle EBS multilanguage pattern. This makes the view the preferred access point for any query that must surface activity labels to end users, while the underlying base table remains the appropriate choice for bulk technical processing. The view is documented as a VALID object in Oracle EBS Release 12.1.1 and 12.2.2, and its definition carries a header comment dated 2008/03/14, indicating stability across the 12.x releases.

Underlying Base Objects

The ETRM metadata documents two referenced base objects, both resolved through synonyms in the APPS schema:

  • WF_ACTIVITIES – the base table holding the language-independent, technical definition of each activity, aliased as B in the view text.
  • WF_ACTIVITIES_TL – the translation table holding the language-dependent DISPLAY_NAME and DESCRIPTION, aliased as T.

The view joins the two tables on the composite key ITEM_TYPE, NAME, and VERSION, and filters the translation table with the condition T.LANGUAGE = USERENV('LANG'). As a result, only the row belonging to the language of the current database session is returned, ensuring the display text matches the user's environment.

Key Columns

The view exposes the ROWID of the base activity row plus a broad set of definitional columns:

  • ROW_ID – the ROWID of the WF_ACTIVITIES row, useful for direct row access.
  • ITEM_TYPE, NAME, VERSION – the composite identity of the activity within its workflow item type.
  • TYPE – classification of the activity, distinguishing standard activities from other node types.
  • FUNCTION, FUNCTION_TYPE, RESULT_TYPE – the callable function invoked and the data type of its result.
  • RERUN, RUNNABLE_FLAG – controls governing whether the activity may be re-executed and whether it is runnable.
  • ROLE columns (EXPAND_ROLE, READ_ROLE, WRITE_ROLE, EXECUTE_ROLE) – role-based access and expansion settings.
  • PROTECT_LEVEL, CUSTOM_LEVEL – customization protection and user customization levels.
  • BEGIN_DATE, END_DATE – validity window of the activity definition.
  • ERROR_PROCESS, ERROR_ITEM_TYPE – error-handling targets.
  • EVENT_NAME, DIRECTION – event subscription and direction attributes.
  • ICON_NAME, MESSAGE – presentation metadata.
  • DISPLAY_NAME, DESCRIPTION – the language-dependent text sourced from WF_ACTIVITIES_TL, which differentiates this view from the base table.

Common Use Cases and Queries

Typical uses include building workflow activity reports, validating activity configurations during upgrades, and diagnosing why an activity label appears in an unexpected language. A basic query lists all activities for a given item type with their translated names:

  • SELECT ITEM_TYPE, NAME, VERSION, DISPLAY_NAME, TYPE FROM WF_ACTIVITIES_VL WHERE ITEM_TYPE = :item_type;
  • SELECT NAME, DISPLAY_NAME, DESCRIPTION FROM WF_ACTIVITIES_VL WHERE ITEM_TYPE = 'WFSTANDARD' ORDER BY NAME;
  • SELECT NAME, FUNCTION, RESULT_TYPE FROM WF_ACTIVITIES_VL WHERE RUNNABLE_FLAG = 'Y';

Because the language filter is embedded in the view definition, queries against WF_ACTIVITIES_VL automatically return text in the session language, simplifying multilingual reporting without the need to join the translation table explicitly.