Search Results offer_response_dt




Overview
Explore in AI Chat

Overview

IGS_AD_ADMDE_INT is a reporting and integration view within the Oracle E-Business Suite Student System (IGS) module, which is documented as obsolete in release 12.2.2. The view exposes admission decision interface data used by the IGS admissions processing pipeline to stage, validate, and transfer admission decision records between external or legacy systems and the core student system tables. In EBS 12.1.1 and 12.2.2 the object is catalogued in ETRM, but the implementation metadata explicitly states "Not implemented in this database," indicating that the view is shipped as part of the IGS schema definition in some environments while remaining absent from others depending on whether the Student System product has been installed and patched.

The view is a thin projection over a single base table, IGS_AD_ADMDE_INT_ALL, exposing all of its columns plus a synthesized ROW_ID derived from the table's physical ROWID. Its principal reporting role is to give integration developers and functional analysts a stable read surface for admission decision interface records, including the RECONSIDER_FLAG column that users commonly search for when investigating waitlist, deferral, and reconsideration processing.

Underlying Base Objects

The ETRM documentation records no referenced base objects beyond the defining SELECT, which targets a single table:

  • IGS_AD_ADMDE_INT_ALL — the sole source object in the view text, aliased as TAB. No joins, unions, or subqueries appear in the definition.

The view therefore inherits the _ALL multi-organization semantics of its base table, filtered through the ORG_ID column, and subclasses of the interface entity are not introduced. Because the ROW_ID is taken directly from TAB.ROWID, updates or deletes issued through the view map to the underlying interface row. The absence of documented dependent objects is consistent with the view's role as a simple read facade rather than a denormalized reporting construct.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing reconsideration decisions, diagnosing failed interface loads, and reporting pending admissions decisions. A representative query filtering on the reconsideration column is shown below.

SELECT person_id, admission_appl_number, nominated_course_cd, adm_outcome_status, decision_date, reconsider_flag, status, error_code, error_text
FROM igs_ad_admde_int
WHERE reconsider_flag = 'Y'
AND org_id = :p_org_id;

Interface error analysis commonly selects ERROR_CODE and ERROR_TEXT for records where STATUS indicates a failure, while run-level reconciliation joins INTERFACE_RUN_ID back to the corresponding interface control table. Because the object is documented as obsolete and may not be implemented in all 12.1.1 or 12.2.2 instances, availability should be verified in DBA_OBJECTS before the view is referenced in custom reports or concurrent programs.