Search Results igs_ad_othinst_int




Overview
Explore in AI Chat

Overview

The view IGS_AD_OTHINST_INT belongs to the IGS (Student System) product family within Oracle E-Business Suite. In ETRM metadata for release 12.2.2, the owning product is explicitly flagged as obsolete, and the object is recorded as "Not implemented in this database." This status is significant: the view is a legacy artifact originating from the Oracle Student System data model, which was never fully delivered or was withdrawn from the supported EBS footprint. In 12.1.1 and 12.2.2 environments, the view will therefore typically be absent unless a site has retained a custom or historical installation of the student modules.

Functionally, IGS_AD_OTHINST_INT is an interface view rather than an operational reporting view. Its name follows the IGS convention for interface staging objects, where the _INT suffix denotes data awaiting validation and transfer into the base admissions tables. The view exposes the "_ALL" variant of the underlying interface table, making it multi-organization aware through the ORG_ID column. The subject matter — other institutions (OTHINST) — indicates that the view carries records describing external academic institutions associated with an applicant or student, such as prior schools or transferring institutions.

Underlying Base Objects

According to the documented view text, IGS_AD_OTHINST_INT is defined as a simple projection over a single base object: IGS_AD_OTHINST_INT_ALL. The ETRM metadata lists no other referenced base objects, confirming that the view performs no joins, unions, or aggregations. Its purpose is to present the _ALL table with a synthesized ROW_ID based on TAB.ROWID, which allows interactive applications such as Oracle Forms to identify rows uniquely without depending on a single primary key column.

Because the definition is a one-to-one column mapping, the view behaves as a filtered or presentation-layer alias. Any row-level security or org-striping logic applied to the _ALL table at the table or synonym level would be inherited by the view. No documented dependencies on additional IGS tables, lookups, or APIs are recorded.

Key Columns

Common Use Cases and Queries

In installations where the IGS schema is present, this view is used to inspect staged other-institution data before or after the admissions interface concurrent program processes it. Typical operational queries check for rows that failed validation or remain unprocessed.

  • Reviewing error records: SELECT INTERFACE_ID, INSTITUTION_CD, ERROR_CODE FROM IGS_AD_OTHINST_INT WHERE STATUS = 'ERROR';
  • Auditing a specific concurrent request: SELECT * FROM IGS_AD_OTHINST_INT WHERE REQUEST_ID = :request_id;
  • Checking match outcomes for an org: SELECT INSTITUTION_CD, MATCH_IND FROM IGS_AD_OTHINST_INT WHERE ORG_ID = :org_id;

Given the obsolete and unimplemented status in 12.1.1 and 12.2.2, these queries are relevant primarily to legacy or custom deployments. In standard supported environments, the view should not be expected to exist, and no Oracle-supported interface process depends on it.