Search Results igs_ad_appl_hist




Overview
Explore in AI Chat

Overview

IGS_AD_APPL_HIST is a reporting and inquiry view belonging to the IGS product family, the Oracle E-Business Suite Student System module. In EBS 12.1.1 and 12.2.2, IGS is classified as an obsolete product; Oracle no longer ships or supports the Student System application in these releases, and the ETRM documentation explicitly marks the underlying object as "Not implemented in this database." The view therefore exists only as a legacy metadata artifact carried forward from earlier EBS releases (notably 11i), where the Student System was a licensable module.

The view exposes historical admissions application data. Its name follows the IGS convention: AD for admissions, APPL for application, HIST for history. It presents a denormalized, operating-unit-scoped projection intended for reporting on the lifecycle of an applicant's admission application, including the dates that each historical version became effective. Because the object is obsolete in 12.1.1 and 12.2.2, it is relevant almost exclusively to upgrade analysis, custom code remediation, and documentation of legacy extensions.

Underlying Base Objects

The view is defined over a single base object, IGS_AD_APPL_HIST_ALL, which stores the multi-organization (operating unit) rows. The _ALL suffix indicates the table retains ORG_ID and is filtered at runtime. The view text applies a security predicate on ORG_ID derived from the session's USERENV('CLIENT_INFO') value:

  • The first ten characters of CLIENT_INFO are decoded to a number; a leading space yields NULL.
  • The decoded value is wrapped in NVL(..., -99), producing a sentinel of -99 when no operating unit context is established.
  • The predicate compares this value against NVL(TAB.ORG_ID, -99), so rows with a NULL ORG_ID are returned only when no operating unit is set.

The ETRM record documents no referenced base objects, consistent with the obsolete status and with the fact that the view is not installed in the database. Consequently, no validation of the base table or its indexes can be performed in a 12.1.1 or 12.2.2 instance.

Key Columns

The view exposes twenty-two columns. The most significant are:

Common Use Cases and Queries

In legacy 11i environments, the view supported point-in-time reporting on admission applications, status-change auditing, and applicant tracking. Typical query patterns include:

SELECT person_id, admission_appl_number, adm_appl_status,
  hist_start_dt, hist_end_dt
FROM igs_ad_appl_hist
WHERE person_id = :person_id;

SELECT admission_appl_number, adm_appl_status,
  COUNT(*) hist_versions
FROM igs_ad_appl_hist
GROUP BY admission_appl_number, adm_appl_status;

In EBS 12.1.1 and 12.2.2, these queries fail with ORA-00942 because the view is not implemented. The correct remediation for upgraded instances is to remove or re-point any custom code, concurrent programs, or reports referencing IGS_AD_APPL_HIST and to confirm that no synonym or APPS-registered definition remains in the target schema.