Search Results activity_description

Overview

The view AMW_WF_PROCESS_HIERARCHY_VL belongs to the AMW product family, documented in Oracle E-Business Suite as Internal Controls Manager. The ETRM metadata classifies AMW as obsolete, and the view itself is recorded as "Not implemented in this database." Consequently, the object should be treated as a legacy or dormant database artifact rather than an actively supported interface in Oracle EBS 12.1.1 or 12.2.2.

Functionally, the view exposes a flattened hierarchy of Oracle Workflow process definitions and their constituent activities. It joins workflow process activities to both the parent process definition and the child activity definition, and it resolves the multi-language display name and description for the activity. Its role in reporting and integration was to provide Internal Controls Manager logic — and any downstream consumer — with a single, language-aware row per process/activity relationship, without requiring the caller to navigate the underlying Workflow metadata tables directly.

Underlying Base Objects

The ETRM metadata states that no base objects are documented for this view and that it is not implemented in the target database. However, the documented view text reveals the objects it is defined over:

• WF_PROCESS_ACTIVITIES — supplies the process-to-activity association, including process item type, process name, process version, activity item type, activity name, and instance identifier.
• WF_ACTIVITIES WA1 — the parent process definition, filtered to those with no end date (END_DATE IS NULL), i.e., currently valid processes.
• WF_ACTIVITIES WA2 — the child activity definition, restricted to activities of TYPE = 'PROCESS' and likewise active (no end date).
• WF_ACTIVITIES_TL WA2_TL — the translation table providing the language-specific display name and description for the child activity.

The joins are keyed on item type, name, and version, and the translation row is restricted to the session language via USERENV('LANG'), making the view a locale-aware projection of Workflow definition metadata.

Key Columns

• PROCESS_ITEM_TYPE — the item type of the parent workflow process.
• PROCESS_NAME — the internal name of the parent process.
• ACTIVITY_ITEM_TYPE — the item type associated with the sub-process activity.
• ACTIVITY_NAME — the internal name of the activity or sub-process.
• ACTIVITY_DISPLAY_NAME — the translated, user-facing name of the activity (WA2_TL.DISPLAY_NAME).
• ACTIVITY_DESCRIPTION — the translated description of the activity (WA2_TL.DESCRIPTION), the column users commonly search for as "activity_description."
• INSTANCE_ID — the identifier tying the row to a specific process definition instance.

Common Use Cases and Queries

Where the view exists, typical usage is to enumerate the sub-process activities defined within a workflow process and to retrieve their translated descriptions for documentation, audit, or integration mapping.

• Listing activity descriptions for a given process item type and name.
• Feeding Internal Controls Manager configuration or audit reports with readable activity text.
• Reconciling custom workflow definitions against delivered process hierarchies.

Illustrative query:

• SELECT PROCESS_ITEM_TYPE, PROCESS_NAME, ACTIVITY_ITEM_TYPE, ACTIVITY_NAME, ACTIVITY_DISPLAY_NAME, ACTIVITY_DESCRIPTION FROM AMW_WF_PROCESS_HIERARCHY_VL WHERE PROCESS_NAME = :process_name;

Given the "Not implemented" status and obsolete product classification, any dependency on this view in 12.1.1 or 12.2.2 should be validated against the actual database before use; equivalent information is generally available directly from the WF_ACTIVITIES and WF_ACTIVITIES_TL tables.