Search Results igs_ad_prcs_cat_step




Overview
Explore in AI Chat

Overview

The view IGS_AD_PRCS_CAT_STEP belongs to the IGS (Student System) product family within Oracle E-Business Suite. In the ETRM metadata for both release 12.1.1 and 12.2.2, the product is flagged as Obsolete, and the view itself is documented as Not implemented in this database. This designation indicates that the object is retained primarily for historical or reference purposes and is not expected to be present in a standard, supported EBS installation.

Functionally, the view exposes configuration data that maps admissions process categories to the individual steps that make up an admissions workflow. Each row represents one step, or step grouping, that applies to a given admission category and admission process type. The view provides an organization-scoped, filtered presentation of this configuration, applying a Multi-Org security predicate so that a session sees only rows belonging to its current operating unit context. In reporting and integration terms, it would have served as a read-only interface for extracting, validating, or migrating admissions step definitions without touching the underlying _ALL table directly.

Underlying Base Objects

The single documented base object referenced by the view text is the table IGS_AD_PRCS_CAT_STEP_ALL. The view is a straightforward projection over that table, selecting a fixed column list and applying a WHERE clause that enforces organization-level access control. No additional joins, views, or synonyms are documented among the referenced base objects.

The view's own name carries no _ALL suffix, which signals that it delivers the operating-unit-filtered subset of the multi-org table. The _ALL table stores rows across all organizations; the view removes that cross-organization visibility and returns only the rows matching the caller's current organization identifier, or rows with a null organization identifier treated as global. Aside from this filtering, the column set is identical to that of the base table, with the addition of a ROW_ID column derived from the table's physical row identifier.

Key Columns

  • ROW_ID — The physical row identifier from the base table, exposed for row-level addressing and certain updatable-view or integration scenarios.
  • ORG_ID — The operating unit identifier that scopes each configuration record; drives the Multi-Org filter applied in the view.
  • ADMISSION_CAT — The admission category to which the step configuration applies, linking the step to a category of applicant or admission track.
  • S_ADMISSION_PROCESS_TYPE — The admissions process type, identifying the broader process within which the step is executed.
  • S_ADMISSION_STEP_TYPE — The specific step type performed within the process.
  • MANDATORY_STEP_IND — Indicates whether the step is mandatory for the associated category and process combination.
  • STEP_TYPE_RESTRICTION_NUM — A numeric restriction qualifying or limiting the step type's applicability.
  • STEP_ORDER_NUM — The sequence in which the step occurs relative to other steps in the process.
  • STEP_GROUP_TYPE — Classifies the step into a grouping used to organize related steps.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified the row and when.

Common Use Cases and Queries

Because the view filters on ORG_ID using the session's client information, queries are typically executed after the correct operating unit context is set. A representative query retrieving ordered steps for a category and process is:

  • SELECT ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE, S_ADMISSION_STEP_TYPE, MANDATORY_STEP_IND, STEP_ORDER_NUM, STEP_GROUP_TYPE FROM IGS_AD_PRCS_CAT_STEP WHERE ADMISSION_CAT = :category ORDER BY STEP_ORDER_NUM;
  • SELECT S_ADMISSION_STEP_TYPE, STEP_ORDER_NUM, MANDATORY_STEP_IND FROM IGS_AD_PRCS_CAT_STEP WHERE ADMISSION_CAT = :category AND S_ADMISSION_PROCESS_TYPE = :process AND MANDATORY_STEP_IND = 'Y' ORDER BY STEP_ORDER_NUM;
  • SELECT ORG_ID, COUNT(*) FROM IGS_AD_PRCS_CAT_STEP GROUP BY ORG_ID; — used to confirm organization coverage and validate Multi-Org partitioning.

Practical scenarios include auditing the ordered set of mandatory steps per category, migrating step configuration between environments, and producing documentation of the admissions workflow. Given the obsolete status and the "not implemented" designation in the ETRM metadata, any reliance on this view should be confirmed against the target instance before use; where it is absent, the equivalent data must be sourced from IGS_AD_PRCS_CAT_STEP_ALL with an explicit organization predicate.