Search Results igs_or_inst_addr




Overview
Explore in AI Chat

Overview

IGS_OR_INST_ADDR is a reporting view within the Oracle E-Business Suite IGS (Student System) product family, which is documented in ETRM as obsolete for releases 12.1.1 and 12.2.2. The view is defined to capture the address of the institution, consolidating institution address data that originates from the Oracle Trading Community Architecture (TCA) party and location model together with IGS-specific party-site extensions.

The view was designed to expose institution addresses in a form suitable for reporting and integration, presenting each institution party site as a discrete address record with descriptive address attributes, site-use classification, institution code, and effective dating. Because IGS is flagged as obsolete, the view carries no active implementation in a standard 12.2.2 environment, and the ETRM record notes "Not implemented in this database." Organizations that still reference this object are typically maintaining legacy Student System customizations, historical extracts, or migration artifacts.

Underlying Base Objects

The view is defined over six underlying objects. Four are TCA entities and two are IGS-specific cross-reference tables:

Joins to IGS_PE_HZ_PARTIES and IGS_PE_HZ_PARTY_SITES are outer joins, so parties and sites without IGS extension rows are still returned. The join to HZ_PARTY_SITE_USES is also an outer join. The ETRM record lists no referenced base objects separately, so the view text above is the authoritative definition.

Key Columns

Note the column list in the ETRM documentation shows ADDR_TYPE and CORRESPONDENCE_IND, whereas the view text emits SITE_USE_TYPE and IDENTIFYING_ADDRESS_FLAG; the view text should be treated as authoritative where they conflict.

Common Use Cases and Queries

Typical use cases include institutional address listings, integration extracts that feed external systems with institution contact information, and migration reconciliation between legacy IGS address data and TCA. A representative query is:

  • SELECT INSTITUTION_CD, TCA_PARTY_NUMBER, ADDRESS1, ADDRESS2, CITY, STATE, POSTAL_CODE, COUNTRY, SITE_USE_TYPE, START_DT, END_DT, STATUS FROM IGS_OR_INST_ADDR ORDER BY INSTITUTION_CD, START_DT;
  • To retrieve only the current, active addresses: SELECT * FROM IGS_OR_INST_ADDR WHERE SYSDATE BETWEEN START_DT AND NVL(END_DT, SYSDATE) AND STATUS = 'A';
  • To join to other IGS entities by institution: SELECT a.INSTITUTION_CD, a.ADDRESS1, a.CITY FROM IGS_OR_INST_ADDR a WHERE a.INSTITUTION_CD = :institution_code;

Because the view is documented as obsolete and not implemented in the 12.2.2 database, queries against it will fail unless the underlying IGS objects and the view itself have been manually retained or recreated. In supported configurations, equivalent institution address data should be sourced directly from the TCA tables (HZ_PARTIES, HZ_PARTY_SITES, HZ_LOCATIONS, HZ_PARTY_SITE_USES).