Search Results az_product_flows




Overview
Explore in AI Chat

Overview

The AZ.AZ_PRODUCT_FLOWS table is a reference data object within the AZ – Application Implementation product of Oracle E-Business Suite. Its documented description identifies it as holding "workflow processes information for each product," meaning it defines the sequence of Oracle Workflow processes associated with each registered product or application. In practical EBS terms, this table forms part of the configuration and integration backbone for modules that orchestrate multi-step business flows — it captures which process names belong to which item type and application, together with their ordering and parent grouping.

Under the Data Vault classification heuristic applied to the foreign key structure, this table is characterized as satellite-leaning. This is a modeling suggestion rather than a prescription: the presence of a composite business key and descriptive attributes (display order, context type) is consistent with a satellite entity attached to a parent hub (the associated AZ_GROUPS record). The 12.2.2 documented physical schema records seven columns and one unique index, and the object is marked VALID in the ETRM repository.

Key Information Stored

The table's primary key is AZ_PRODUCT_FLOWS_PK, a composite surrogate defined over APPLICATION_ID, ITEM_TYPE, and PROCESS_NAME. A separate unique index, AZ_PRODUCT_FLOWS_U1, enforces the same three columns as the effective business key — a redundancy common in Oracle EBS dictionary tables where the surrogate and uniqueness constraints overlap.

  • APPLICATION_ID — Identifies the EBS application that owns the workflow process; joins to FND_APPLICATION.
  • ITEM_TYPE — The Workflow item type (process definition container) that groups the individual processes.
  • PROCESS_NAME — The specific Workflow process identifier within the item type.
  • PROCESS_TYPE — Categorizes the nature of the process, distinguishing e.g. parent, child, or sub-process flows.
  • PARENT_ID — Self-referencing grouping key that maps the flow record to a parent entry in AZ_GROUPS via the documented foreign key AZ_PRODUCT_FLOWS.PARENT_ID → AZ_GROUPS.
  • DISPLAY_ORDER — Numeric sequencing used to present or execute processes in the intended order.
  • CONTEXT_TYPE — Describes the context under which the process applies, supporting conditional flow resolution.

Common Use Cases and Queries

Typical usage centers on diagnosing workflow configuration during implementations, upgrades, and troubleshooting of product-based process launches. A common diagnostic examines which processes are defined per application and item type:

  • Inventory of flows: SELECT PROCESS_TYPE, ITEM_TYPE, PROCESS_NAME, DISPLAY_ORDER FROM AZ.AZ_PRODUCT_FLOWS WHERE APPLICATION_ID = :app_id;
  • Grouped hierarchy: join to AZ_GROUPS on AZ_PRODUCT_FLOWS.PARENT_ID = AZ_GROUPS.GROUP_ID to resolve parent grouping labels for reporting.
  • Ordering audit: order by DISPLAY_ORDER within APPLICATION_ID/ITEM_TYPE to verify the intended execution sequence against design documentation.
  • Context filtering: filter by CONTEXT_TYPE when only flows applicable to a given configuration context are relevant.

Reporting use cases include product-level implementation checklists, flow coverage matrices (which item types have complete process sets), and impact analysis before patching an item type.

Related Objects

The following objects are the most significant dependencies, based on the documented foreign key and key-column relationships:

  • AZ_GROUPS — Parent grouping table; join via AZ_PRODUCT_FLOWS.PARENT_ID = AZ_GROUPS.GROUP_ID (documented FK).
  • AZ_PRODUCT_FLOWS_PK — Composite primary key index on APPLICATION_ID, ITEM_TYPE, PROCESS_NAME.
  • AZ_PRODUCT_FLOWS_U1 — Unique index reinforcing the business key.
  • FND_APPLICATION — Lookup for APPLICATION_ID to resolve application short names and descriptions.
  • WF_ITEM_TYPES / WF_PROCESSES — Oracle Workflow dictionary views matching ITEM_TYPE and PROCESS_NAME to actual process definitions.
  • WF_PROCESS_ACTIVITIES — Activity-level detail for the processes referenced by PROCESS_NAME.

Together these objects allow a complete picture of how product flows are grouped, ordered, and executed within the EBS Workflow engine.