Search Results wa_tl




Overview
Explore in AI Chat

Overview

AMW_WF_PROCESSES_V is a reporting view in the Oracle E-Business Suite Applications (APPS) schema that exposes Oracle Workflow process activity definitions together with their translated display names. It is defined in the Oracle E-Business Suite 12.1.1 and 12.2.2 releases and forms part of the Oracle Workflow dictionary reporting layer, which is used by products such as Oracle Approvals Management (AMW) and Oracle Workflow itself. The view answers a recurring functional question: which workflow processes exist in the current environment, in which item type are they defined, and what is their user-facing name in the session's language?

Because it resolves the display name from the translation table using the session language, the view is particularly relevant to multi-language installations, where a process is identified internally by a name and version but presented to users through a localized display name. The view is a read-only consolidation and is not intended for transactional use.

Underlying Base Objects

The view is defined over two Oracle Workflow dictionary tables, joined on the natural key of a workflow activity. Referenced base objects are not separately documented in the ETRM metadata, but the view text identifies them explicitly:

  • WF_ACTIVITIES — the base activity definition table, supplying the internal activity name, item type, version, activity type, and end date. The view text aliases this table as WA.
  • WF_ACTIVITIES_TL — the translation table for activities, supplying the language-specific display name. The view text aliases this table as WA_TL; the alias wa_tl appears in the search term associated with this object.

The join is an equijoin across four columns: NAME, VERSION, ITEM_TYPE, and (implicitly through the translation table) LANGUAGE. Only rows where the activity's TYPE is 'PROCESS' are returned, and only rows where END_DATE IS NULL, meaning the process definition is still active. The translation row is restricted to the language returned by USERENV('LANG'), the language of the current database session.

Key Columns

  • DISPLAY_NAME — the translated, user-facing name of the workflow process, taken from WF_ACTIVITIES_TL. This is the value presented in workflow administration screens and notifications.
  • NAME — the internal, untranslated process identifier from WF_ACTIVITIES. It is the value used programmatically in workflow APIs and in the WF_ACTIVITIES foreign key relationships.
  • ITEM_TYPE — the workflow item type (for example, an order or approval item type) that owns the process definition. Together with NAME and VERSION it uniquely identifies a process activity.

Common Use Cases and Queries

Typical usage includes validating that a required process exists before configuring AMW rules, building ad hoc reports of available processes per item type, and troubleshooting why a process label appears untranslated. A simple listing of active processes follows:

  • SELECT display_name, name, item_type FROM apps.amw_wf_processes_v ORDER BY item_type, name;
  • SELECT display_name FROM apps.amw_wf_processes_v WHERE item_type = :p_item_type AND name = :p_process_name;
  • SELECT item_type, COUNT(*) FROM apps.amw_wf_processes_v GROUP BY item_type ORDER BY 1;

Because the view filters on the session language, a query executed by a user with a language for which no translation row exists returns no row for that process; this behaviour should be considered when the view is used as the basis for validation or integration logic.