Search Results igi_exp_wkf_step_pk

Overview

The IGI.IGI_EXP_WKF_STEP_ALL table is a core workflow configuration object within the Oracle EBS Enterprise Tax, Property, and Treasury Management (formerly iExpenses-related, now under the IGI schema) module. It stores the definition of individual steps within export workflow flows, allowing the system to route workflow activities to specific organizational positions during processing. Each row represents a single step at a given position within a workflow flow. The table resides in the APPS_TS_TX_DATA tablespace and is documented as Oracle Internal Use Only, meaning direct access should be restricted to standard Oracle Applications programs.

From a heuristic Data Vault modeling perspective, this object is best classified as a link or satellite entity. It does not represent a single business entity (hub) but rather associates multiple business keys—workflow identifier, flow identifier, step number, and position structure identifier—forming the composite unique key IGI_EXP_WKF_STEP_PK. This structure suggests a link table connecting workflow definitions to human resource positions.

Key Information Stored

The table contains ten columns. The most operationally significant include:

• WKF_ID (NUMBER) — Workflow identifier, the primary grouping key for a workflow definition.
• FLOW_ID (NUMBER) — Individual flow identifier, uniquely identifying a specific flow within a workflow.
• STEP_NO (NUMBER) — Step number, defining the ordinal sequence of the step within the flow.
• POSITION_STRUCTURE_ID (NUMBER) — Human resource position structure identifier as defined through the position hierarchy form. This is a foreign key to PER_POSITION_STRUCTURES.
• ORG_ID (NUMBER) — Organization identifier, supporting multi-org data partitioning.
• LAST_UPDATE_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking row creation and modification metadata.

The surrogate primary key is not a single column; rather, the unique index IGI_EXP_WKF_STEP_PK spans all four business-key columns: WKF_ID, FLOW_ID, STEP_NO, and POSITION_STRUCTURE_ID. This composite key enforces that no two rows define the same step position within the same flow of a workflow. The table is classified as standalone in the data vault, with no child tables referencing it, though it references PER_POSITION_STRUCTURES.

Common Use Cases and Queries

This table is primarily queried to determine workflow routing configurations—specifically, which position is responsible for a given step in a flow. A typical query to retrieve all steps for a workflow might appear as:

• SELECT WKF_ID, FLOW_ID, STEP_NO, POSITION_STRUCTURE_ID FROM IGI.IGI_EXP_WKF_STEP_ALL WHERE WKF_ID = :p_wkf_id ORDER BY FLOW_ID, STEP_NO;
• Joining to PER_POSITION_STRUCTURES to resolve position names for reporting: SELECT s.STEP_NO, p.NAME FROM IGI.IGI_EXP_WKF_STEP_ALL s, PER_POSITION_STRUCTURES p WHERE s.POSITION_STRUCTURE_ID = p.POSITION_STRUCTURE_ID AND s.WKF_ID = :p_wkf_id;
• Auditing changes using the WHO columns: SELECT * FROM IGI.IGI_EXP_WKF_STEP_ALL WHERE LAST_UPDATE_DATE > SYSDATE - 30;

Reporting use cases include workflow step inventory, organizational responsibility mapping, and configuration migration validation between environments. Because the table is internal, direct DML should be avoided; use Oracle-provided APIs or forms for maintenance.

Related Objects

The table has documented relationships to the following objects:

• PER_POSITION_STRUCTURES — Referenced by POSITION_STRUCTURE_ID, providing the position hierarchy definition for each workflow step.
• IGI_EXP_WKF_STEP_ALL# — The internal editioning view or shadow object associated with the table.
• IGI_EXP_WKF_ALL (implied) — Parent workflow definition table, joined via WKF_ID.
• IGI_EXP_WKF_FLOW_ALL (implied) — Flow-level definition table, joined via FLOW_ID.
• FND_USER — Referenced by CREATED_BY and LAST_UPDATED_BY foreign keys.
• FND_LOGINS — Referenced by LAST_UPDATE_LOGIN for session tracking.

These relationships confirm the table's role as a configuration link between workflow definitions and HR position structures, enabling position-based routing within Oracle EBS export workflows.