Search Results igs_ad_interface_ctl




Overview
Explore in AI Chat

Overview

The IGS_AD_INTERFACE_CTL view is a data object within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2, specifically belonging to the now-obsolete IGS (Student System) module. Its primary function is to store and provide access to control and audit details for each execution of the admissions data import interface. This interface is responsible for bringing external admissions application data into the core EBS system. The view acts as a critical log, tracking the status, source, and context of each import run to facilitate monitoring, troubleshooting, and ensuring data integrity during the transfer process.

Key Information Stored

The view consolidates key identifiers and audit columns from its underlying table. The most critical columns for process control include INTERFACE_RUN_ID (the primary key uniquely identifying an import execution), STATUS (indicating the success or stage of the run), and SOURCE_TYPE_ID (a foreign key classifying the origin system or feed of the imported data, which was the user's specific search term). Other essential fields are BATCH_ID (linking to a specific data batch), MATCH_SET_ID (referencing the rule set used for matching person records), and ORG_ID (identifying the operating unit). Standard EBS audit columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE are also present, along with Concurrent Program tracking columns like REQUEST_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

This view is primarily used for operational reporting and support of the admissions import process. Administrators query it to monitor the history and current state of data loads. A common reporting use case is to identify recent failed or in-progress interface runs for investigation. A sample query to find runs for a specific source type that have not completed successfully would be:

  • SELECT interface_run_id, batch_id, status, creation_date FROM igs_ad_interface_ctl WHERE source_type_id = <source_type_value> AND status != 'COMPLETE' ORDER BY creation_date DESC;

Another typical scenario involves joining with the related batch detail table to get a comprehensive view of an import's metadata and the volume of records processed within a specific run identified by its INTERFACE_RUN_ID.

Related Objects

Based on the provided foreign key relationship data, the IGS_AD_INTERFACE_CTL view has defined relationships with three key tables in the obsolete Student System module:

  • IGS_PE_SRC_TYPES_ALL: Joined via SOURCE_TYPE_ID. This table defines the valid source systems (e.g., "Common Application," "Internal Web Form") from which admissions data can originate.
  • IGS_PE_MATCH_SETS_ALL: Joined via MATCH_SET_ID. This table holds the definition of rule sets used to prevent duplicate person records by matching incoming data against existing entities.
  • IGS_AD_IMP_BATCH_DET: Joined via BATCH_ID. This table contains the detailed header information for a specific batch of imported admissions data associated with an interface run.

The primary key for this view is IGS_AD_INTERFACE_CTL_PK on the INTERFACE_RUN_ID column.