Search Results position_type




Overview
Explore in AI Chat

Overview

IGI_EXP_WKF_STEP_V is a reporting view in the APPS schema belonging to the IGI - Public Sector Financials International product family. It presents individual workflow step setup information as configured against position structures within the IGI expenditure (IGI_EXP) workflow framework. Rather than storing data itself, the view consolidates configuration records spanning HR job definitions, IGI position structures, HR position structure versions, and the IGI_EXP_WKF_STEP transaction table, denormalising them into a single readable projection.

Its primary role is to support inquiry, validation, and integration scenarios. Administrators and developers use it to inspect how workflow steps are sequenced for a given position structure, which job type or position type drives each step, and which flow identifier governs the approval or routing logic. Because the view joins flex value setup against HR job names, it also serves as a diagnostic aid when job naming conventions must align with the IGI_EXP_JOBS value set.

Underlying Base Objects

The view text is defined over the following documented objects:

  • IGI_EXP_WKF_STEP E — the core workflow step definition table; the driving table for the view.
  • IGI_EXP_POS_STRUCTURES P — position structure definitions, joined on POSITION_STRUCTURE_ID, supplying the job linkage.
  • HR.PER_JOBS J — HR job definitions, joined on JOB_ID, supplying the position/job name.
  • HR.PER_POS_STRUCTURE_VERSIONS V — position structure versioning, joined with an outer join (+), so structures without a matching version are still returned.
  • APPS.FND_FLEX_VALUE_SETS FFVS and APPS.FND_FLEX_VALUES_VL FFV — the flexfield value set named IGI_EXP_JOBS, joined to provide the job type description.

The join to FND_FLEX_VALUES_VL is value-prefix based: SUBSTR(J.NAME,1,LENGTH(FFV.FLEX_VALUE)) = FFV.FLEX_VALUE, meaning the HR job name must begin with a value defined in the IGI_EXP_JOBS value set for JOB_TYPE to resolve. No direct dependency on DUAL is functionally relevant beyond the documented metadata.

Key Columns

  • ROW_ID — ROWID of the underlying IGI_EXP_WKF_STEP row, useful for updates or drill-down.
  • POSITION_TYPE — the HR job name (J.NAME). This is the column users searching "position_type" typically target; it identifies the position or job category the workflow step applies to.
  • POSITION_STRUCTURE_NAME — descriptive name of the IGI position structure.
  • POSITION_STRUCTURE_ID / JOB_ID / WKF_ID / FLOW_ID — foreign keys linking the step to its structure, HR job, workflow definition, and flow.
  • STEP_NO — the sequence number of the step within the flow.
  • JOB_TYPE — description resolved from the IGI_EXP_JOBS flex value set.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include auditing workflow step configuration for a position structure, verifying job-to-value-set alignment, and feeding custom reports or interfaces that need resolved job type descriptions.

Sample query returning steps for a given position structure:

  • SELECT position_type, position_structure_name, step_no, job_type, flow_id FROM apps.igi_exp_wkf_step_v WHERE position_structure_id = :structure_id ORDER BY step_no;

Sample query resolving job types across all positions:

  • SELECT position_type, job_type, COUNT(*) FROM apps.igi_exp_wkf_step_v GROUP BY position_type, job_type;

Because the outer join permits null structure versions and the flex join depends on prefix matching, results may omit JOB_TYPE where job names fall outside the IGI_EXP_JOBS value set definitions.