Search Results igi_exp_wkf_step




Overview
Explore in AI Chat

Overview

The IGI_EXP_WKF_STEP view is a multi-organization (multiorg) security view owned by the APPS schema within the Oracle E-Business Suite environment. It belongs to the IGI - Public Sector Financials International product family and carries a documented status of VALID. As a multiorg view, its principal function is to present a filtered, organization-scoped projection of the underlying workflow step data so that users querying through Oracle Forms, concurrent programs, or ad hoc reporting tools see only the rows relevant to their currently selected operating unit. This filtering mechanism is enforced at the database level through the ORG_ID predicate rather than at the application layer, which centralizes and standardizes data access control across reporting and integration touchpoints. Because the view exposes workflow step information — identifiers for workflows, flows, step numbers, and position structures — it supports visibility into the configuration and sequencing of expense-related workflow processing in the Public Sector Financials International module.

Underlying Base Objects

According to the documented ETRM metadata, IGI_EXP_WKF_STEP is defined over a single referenced base object: IGI_EXP_WKF_STEP_ALL, which is exposed as a SYNONYM. The _ALL suffix indicates that the base table holds data across all operating units, with each row tagged by its ORG_ID. The view selects the same ten columns from the base object and applies a restrictive WHERE clause that compares the row's ORG_ID against the operating unit currently established in the session. The session value is derived by parsing USERENV('CLIENT_INFO'): the first character is inspected for a blank, and if not blank, the first ten characters are converted to a number. When either the row's ORG_ID or the session-derived value cannot be resolved, the expression collapses to the sentinel value -99. This standard multiorg pattern ensures that the view returns only records belonging to the active organization context, preventing cross-organization data leakage in multi-org deployments.

Key Columns

  • WKF_ID — Identifier of the parent workflow definition to which the step belongs.
  • FLOW_ID — Identifier of the flow within the workflow that this step participates in.
  • STEP_NO — Ordinal position of the step within its flow, defining execution sequence.
  • POSITION_STRUCTURE_ID — Reference to the position structure associated with the step, supporting organizational routing logic.
  • LAST_UPDATE_DATE — Timestamp of the most recent modification to the row.
  • LAST_UPDATED_BY — Application user who performed the last update.
  • CREATED_BY — Application user who created the row.
  • CREATION_DATE — Timestamp when the row was created.
  • LAST_UPDATE_LOGIN — Login session identifier associated with the last update.
  • ORG_ID — Operating unit identifier used by the multiorg predicate to scope rows to the active organization.

Common Use Cases and Queries

Typical uses of this view include diagnosing workflow configuration for expense processing, validating step sequencing, and auditing organization-specific step definitions. Because the view automatically applies organization security, reporting queries need not add their own ORG_ID filter when the correct operating unit is set in the session.

  • Listing all steps for a given workflow: SELECT WKF_ID, FLOW_ID, STEP_NO FROM IGI_EXP_WKF_STEP WHERE WKF_ID = :p_wkf_id ORDER BY FLOW_ID, STEP_NO;
  • Inspecting position routing for a flow: SELECT STEP_NO, POSITION_STRUCTURE_ID FROM IGI_EXP_WKF_STEP WHERE FLOW_ID = :p_flow_id ORDER BY STEP_NO;
  • Auditing recent changes: SELECT WKF_ID, STEP_NO, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGI_EXP_WKF_STEP WHERE LAST_UPDATE_DATE > SYSDATE - 30;

Consult the _ALL base object directly only when cross-organization visibility is required and appropriate privileges exist.