Search Results offer_response_offset




Overview
Explore in AI Chat

Overview

IGS_AD_PRCS_CAT is a Multi-Org secured (MOAC) reporting view within the obsolete IGS — Student System product family of Oracle E-Business Suite, historically released as the Oracle Student System (OSS) and subsequently folded into Oracle's higher-education offerings. The view exposes admission process categories and their associated processing attributes, providing a filtered, organization-scoped read interface over the underlying _ALL table. Its principal role is to present admission category configuration data to forms, concurrent programs, and ad-hoc reports while enforcing the operating unit (ORG_ID) security model that governs the Student System schema. ETRM metadata for 12.2.2 documents this object but explicitly records it as "Not implemented in this database," reflecting the product's retired status rather than any defect in the view definition itself.

Underlying Base Objects

The view is defined over a single base table, IGS_AD_PRCS_CAT_ALL, which stores admission process category definitions across all operating units. The view selects every row from that table but applies a WHERE clause that restricts results to the operating unit of the current session. This predicate is derived from the standard MOAC pattern used throughout EBS 12.1.1 and 12.2.2: the ORG_ID column is compared against the value extracted from USERENV('CLIENT_INFO'), with NVL logic defaulting to -99 when no organization context is established. Because the view carries the ORG_ID column and the associated security predicate, it is registered as an organization-sensitive view, allowing it to be queried safely from Multi-Org enabled responsibilities. ETRM documentation lists no other referenced base objects, so the relationship is a straightforward one-to-one projection with row-level filtering.

Key Columns

  • ROW_ID — The ROWID of the underlying table row, enabling the view to support updateable-form behavior and row identification in the Apps framework.
  • ORG_ID — The operating unit that owns the admission process category record; the driver of the MOAC filter.
  • ADMISSION_CAT — The admission category code, the primary business identifier for the record.
  • S_ADMISSION_PROCESS_TYPE — The admission process type associated with the category, defining how an application proceeds through the admissions lifecycle.
  • OFFER_RESPONSE_OFFSET — A numeric offset controlling the timing (typically days) within which an applicant must respond to an offer; used by offer and response processing logic.
  • RATING_SCALE_ID — Foreign key to the rating scale applied when evaluating applicants within this category.
  • CLOSED_IND — Indicator marking whether the admission process category is closed to new use.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified the record and when.

Common Use Cases and Queries

Typical use cases include validating the admission categories available to a given operating unit, driving offer-response deadline calculations from OFFER_RESPONSE_OFFSET, and joining to rating scale definitions for applicant evaluation. Because the view is MOAC-secured, queries return only rows for the session's operating unit. A representative query is:

SELECT admission_cat, s_admission_process_type, offer_response_offset, closed_ind FROM igs_ad_prcs_cat WHERE closed_ind = 'N' ORDER BY admission_cat;

For a cross-organization administrative report, the base table should be queried directly with an explicit ORG_ID predicate, since the view intentionally suppresses rows outside the current organization context. Administrators should note that the object is documented as obsolete and not implemented in current 12.2.2 environments, so any integration depending on it must be remediated or replaced.