Search Results az_tasks_v




Overview
Explore in AI Chat

Overview

AZ_TASKS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AZ – Application Implementation product family. In both release 12.1.1 and 12.2.2 the object is documented with a status of VALID. Its stated purpose is to provide easy access to assigned use and status, as well as context names, for Wizard tasks generated by the Application Implementation (Wizard) framework.

The view consolidates data held across the Oracle Workflow runtime tables with the AZ_PROCESSES metadata table. Rather than requiring a developer to join workflow item, activity status, and item attribute tables manually, AZ_TASKS_V presents a single flattened row per Wizard task, carrying the owning item type and item key, the root activity (context) under which the task runs, the numeric context identifier, the human-readable context name, the assigned user, task status, begin and end dates, and a computed duration. Because it is defined exclusively over synonyms to base tables, it functions as a read-only reporting and integration surface; no DML is possible through the view.

Underlying Base Objects

According to the documented ETRM metadata for 12.2.2, AZ_TASKS_V references five base objects, all accessed through APPS synonyms:

The view restricts itself to Wizard item types via the predicate WI.ITEM_TYPE LIKE 'AZW%', ensuring only Application Implementation workflow instances are returned.

Key Columns

  • ITEM_TYPE / ITEM_KEY — the workflow item type (AZW-prefixed) and unique item key identifying each task instance.
  • ROOT_ACTIVITY — the top-level process name under which the task executes; effectively the Wizard context group.
  • CONTEXT_ID — the numeric context identifier, derived by converting the AZW_IA_CTXT_ID attribute TEXT_VALUE to a number.
  • CONTEXT_NAME — the descriptive context name sourced from AZ_PROCESSES, resolved by matching CONTEXT_ID.
  • ASSIGNED_USER — the role/user responsible for the task, taken from the AZW_IA_ROLE attribute TEXT_VALUE and truncated to 100 characters.
  • ACTIVITY_ID — the workflow activity instance identifier (PROCESS_ACTIVITY) for the task.
  • STATUS — a decoded single-character flag: 'A' when the activity status is ACTIVE, otherwise 'C' (complete).
  • BEGIN_DATE / END_DATE — the task's start and completion timestamps; END_DATE is NULL for tasks still open.
  • DURATION — a computed value expressed as months-to-date multiplied by 31 (approximating days), measuring either from BEGIN_DATE to SYSDATE for open tasks or from BEGIN_DATE to END_DATE for completed ones.

Common Use Cases and Queries

The view is typically used to report on the progress of Application Implementation Wizard tasks, to audit user assignments, and to feed downstream status dashboards. A common query lists all open tasks with their owners and contexts:

  • SELECT item_type, item_key, context_name, assigned_user, status, begin_date FROM az_tasks_v WHERE status = 'A' ORDER BY begin_date;
  • SELECT context_name, COUNT(*) FROM az_tasks_v GROUP BY context_name;
  • SELECT item_key, assigned_user, duration FROM az_tasks_v WHERE assigned_user = :user ORDER BY duration DESC;

When a user searches for "text_value" in connection with this object, the relevant point is that the view does not expose TEXT_VALUE directly; instead it exposes the transformed results of two WF_ITEM_ATTRIBUTE_VALUES attributes — AZW_IA_ROLE into ASSIGNED_USER and AZW_IA_CTXT_ID (numerically cast) into CONTEXT_ID. Queries filtering on the raw text_value must target the underlying WF_ITEM_ATTRIBUTE_VALUES table, since AZ_TASKS_V has already resolved and renamed those values for reporting convenience.