Search Results az_product_flows_u1

Overview

AZ.AZ_PRODUCT_FLOWS is an Oracle E-Business Suite table owned by the AZ schema, classified as VALID in the ETRM 12.1.1 / 12.2.2 data model. It stores information about the runnable workflow processes for each application. Each record contains the unique identifier of the application, the item type, the process name, and the context type, together with the parent process group to which the process belongs and its display order within the hierarchy tree. In practice, the table acts as the configuration repository that drives how runnable process groups are presented and sequenced for a given application and item type.

The table resides in the APPS_TS_ARCHIVE tablespace with a PCT Free of 10. Its documented primary key is AZ_PRODUCT_FLOWS_PK, comprising APPLICATION_ID, ITEM_TYPE, and PROCESS_NAME. The unique index AZ_PRODUCT_FLOWS_U1 mirrors this same column combination, confirming it as the business-key candidate for the table. Based on the foreign key relationship and the table's role as a dependent descriptor holding descriptive attributes around a parent process group, the heuristic Data Vault classification is satellite-leaning; this should be treated as a modeling suggestion rather than a definitive architectural statement.

Key Information Stored

Seven columns are documented for this table. The most significant are:

• APPLICATION_ID (NUMBER, 15): The application identifier. Part of the composite primary key and of the unique index AZ_PRODUCT_FLOWS_U1.
• ITEM_TYPE (VARCHAR2, 30): The item type associated with the process. Also part of the primary key and unique index.
• PROCESS_NAME (VARCHAR2, 30): The internal name of the process activity. The third component of the primary key and unique index.
• PROCESS_TYPE (VARCHAR2, 30): The implementation type for the process, distinguishing Fresh from Upgrade variants.
• DISPLAY_ORDER (NUMBER, 15): The display order of the process within the hierarchy tree, controlling presentation sequence.
• CONTEXT_TYPE (VARCHAR2, 30): The context type of the process, coded as BG for business group, IO for inventory organization, OU for operating unit, or SOB for set of books.
• PARENT_ID (VARCHAR2, 240): The parent process group to which the process is associated. This column carries the foreign key relationship to AZ_GROUPS.

The surrogate identity of a row is effectively the composite of APPLICATION_ID, ITEM_TYPE, and PROCESS_NAME; AZ_PRODUCT_FLOWS_U1 is the documented unique index that enforces this business key. Two non-unique indexes support access paths: AZ_PRODUCT_FLOWS_N1 on PARENT_ID and PROCESS_TYPE, and AZ_PRODUCT_FLOWS_N2 on ITEM_TYPE and PROCESS_NAME.

Common Use Cases and Queries

Typical reporting scenarios involve enumerating runnable processes per application and item type, reconstructing the process hierarchy from PARENT_ID, and filtering by context type or process type. A standard retrieval pattern is:

• Select all columns for a given application: SELECT PROCESS_TYPE, APPLICATION_ID, ITEM_TYPE, PROCESS_NAME, DISPLAY_ORDER, CONTEXT_TYPE, PARENT_ID FROM AZ.AZ_PRODUCT_FLOWS; with a WHERE clause on APPLICATION_ID and ITEM_TYPE.
• List children of a process group by joining or filtering on PARENT_ID, leveraging index AZ_PRODUCT_FLOWS_N1.
• Order output by DISPLAY_ORDER to reproduce the hierarchy tree sequence as presented to users.
• Segment processes by CONTEXT_TYPE (BG, IO, OU, SOB) for setup and security reviews.
• Distinguish Fresh versus Upgrade process variants using PROCESS_TYPE.

Because PARENT_ID is a VARCHAR2 of length 240, hierarchy traversal is best performed with recursive queries or application-tier logic rather than simple self-joins on a numeric key.

Related Objects

The metadata documents one explicit foreign key relationship and one dependent object. The most significant related objects are:

• AZ.AZ_GROUPS: Referenced through the foreign key AZ_PRODUCT_FLOWS.PARENT_ID → AZ_GROUPS, linking each process to its parent process group.
• AZ.AZ_PRODUCT_FLOWS#: A dependent object that references AZ_PRODUCT_FLOWS.
• AZ.AZ_PRODUCT_FLOWS_U1: The unique index on APPLICATION_ID, ITEM_TYPE, and PROCESS_NAME.
• AZ.AZ_PRODUCT_FLOWS_N1: The non-unique index on PARENT_ID and PROCESS_TYPE.
• AZ.AZ_PRODUCT_FLOWS_N2: The non-unique index on ITEM_TYPE and PROCESS_NAME.

No additional database objects are referenced by AZ_PRODUCT_FLOWS per the documented dependency information; the table functions primarily as a dependent child of AZ_GROUPS and as a configuration source for workflow process presentation.