Results for “complete_flag”

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

Overview

AZ_PROCESS_ACTIVITIES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the AZ – Application Implementation product family, the module that underpins Oracle's Application Implementation Wizard (AIW). The view presents the definition of a Wizard process by joining implementation process metadata to activity version details. Specifically, it exposes one row per active Wizard activity, combining setup context information from AZ_PROCESSES with version and descriptive attributes drawn from the workflow activities warehouse. Because the Wizard relies on Oracle Workflow definitions for item types and process activities, this view acts as a bridge between the AIW scheduling structures and the shared WF_ACTIVITIES_VL repository supplied by Oracle Workflow. The view is documented as VALID and is treated as a read-only reporting object; it is not intended for direct DML. Its status as a view rather than a table means its contents are always derived at query time, so upstream changes to process definitions or activity versions are reflected without a separate refresh cycle.

Underlying Base Objects

The documented base objects for this view are AZ_PROCESSES (referenced through an APPS synonym) and WF_ACTIVITIES_VL (a Workflow view). The ETRM view text confirms a straightforward inner join on two key pairs: AZP.ITEM_TYPE = WAV.ITEM_TYPE and AZP.PROCESS_NAME = WAV.NAME. A filter predicate WAV.END_DATE IS NULL restricts output to currently valid activity versions, excluding superseded definitions. The DISTINCT operator eliminates duplicate rows that could otherwise result from multiple matching activity records. In effect, this view supplies the activity-level detail that AZ_PROCESSES alone does not carry, such as the activity version and its translated description, while preserving the process context stored on AZ_PROCESSES.

Key Columns

• ITEM_TYPE – The Oracle Workflow item type that identifies the application or process family; the join key to WF_ACTIVITIES_VL.
• PROCESS_NAME – The name of the Wizard process as defined in AZ_PROCESSES and matched to the Workflow activity name.
• CONTEXT_ID – Context identifier used by the implementation process definition, typically supporting multi-tenant or context-specific configuration.
• COMPLETE_FLAG – Indicator recording whether the process activity has been completed within the implementation sequence.
• COMMENTS – Free-text commentary captured against the process definition.
• VERSION – The active version of the Workflow activity, sourced from WF_ACTIVITIES_VL.
• DESCRIPTION – The translated display description of the activity, obtained from the Workflow activities view and therefore language-aware.

Common Use Cases and Queries

Consultants and administrators use this view to audit which Wizard processes are active, to verify the workflow version bound to each process, and to extract translated descriptions for documentation or gap analysis. It is also used during diagnostics when an AIW process fails, since comparing COMPLETE_FLAG and version information helps isolate stale or mismatched definitions. A typical query lists all active activities for a given item type:

SELECT item_type, process_name, version, description, complete_flag
FROM   az_process_activities_v
WHERE  item_type = '&item_type'
ORDER BY process_name;

A second common pattern checks completion status across processes:

SELECT process_name, complete_flag, comments
FROM   az_process_activities_v
WHERE  complete_flag = 'N';

Because the view filters on END_DATE IS NULL, results reflect only current activity versions, which is the desired behavior for operational reporting but may hide historical process configurations. Queries requiring an audit trail should join to WF_ACTIVITIES_VL directly without the null-date restriction.