Search Results interface_spltal_id




Overview
Explore in AI Chat

Overview

The view IGS_AD_SPLTAL_INT belongs to the Oracle EBS IGS – Student System product family, a module now classified as obsolete in the Applications Technology Reference Manual (ETRM). It functions as a reporting and integration layer exposing the contents of the admissions special talent interface staging table. In the Oracle EBS architecture, interface views of this naming convention (suffix _INT) surface rows that have been loaded by an external process — typically a SQL*Loader or concurrent program import — and that await validation, matching, and transfer into the base application tables.

The primary identifier exposed by the view is INTERFACE_SPLTAL_ID, which is the surrogate key of each staged special talent interface record. Users searching for this column are generally tracing how applicant special talent data flows from a flat-file or legacy source into the Oracle Student System tables. The ETRM metadata records that the object is not implemented in the documented database, meaning the view exists in the data dictionary definition but is absent at runtime in a standard installation.

Underlying Base Objects

The view is defined exclusively over the single base object IGS_AD_SPLTAL_INT_ALL. The _ALL suffix confirms that the table carries an ORG_ID column and therefore participates in the Multi-Org (Operating Unit) security model. The ETRM "Referenced base objects" field documents no additional dependencies, so the view performs a straightforward column projection with no joins, unions, or aggregations. Because it selects TAB.ROWID as ROW_ID, the view is updatable in principle, allowing Oracle Forms or PL/SQL logic to modify staged rows through the view where grants permit.

Key Columns

  • ROW_ID — the physical ROWID of the underlying table row, enabling direct row access for update/delete operations during interface processing.
  • ORG_ID — the operating unit identifier, enforcing Multi-Org access control.
  • INTERFACE_SPLTAL_ID — the unique interface record identifier and the column most frequently searched by developers and support analysts.
  • INTERFACE_APPL_ID and INTERFACE_ID — foreign references linking the talent row to its parent application and interface batch records.
  • SPECIAL_TALENT_TYPE_ID — identifies the specific talent category (for example, athletic, musical, or artistic aptitude) captured for the applicant.
  • MATCH_IND, STATUS, ERROR_CODE — control columns indicating whether the row matched a valid reference, its processing state, and any validation failure details.
  • Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit tracking.
  • Concurrent request columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — identify the interface import or validation program that last touched the row.

Common Use Cases and Queries

The view is used to monitor and diagnose the special talent import process, most commonly to detect rows stuck in an error state before the transfer step pushes data into the applicant talent tables.

SELECT interface_spltal_id,
       interface_id,
       special_talent_type_id,
       status,
       error_code,
       creation_date
FROM   igs_ad_spltal_int
WHERE  status = 'E'
ORDER BY creation_date;

A second frequent pattern traces a single interface record back to the program that created it:

SELECT interface_spltal_id,
       request_id,
       program_id,
       program_application_id
FROM   igs_ad_spltal_int
WHERE  interface_spltal_id = :p_id;

Because the documented metadata records the view as not implemented, any query referencing it in a live 12.1.1 or 12.2.2 environment should first be validated against DBA_VIEWS and DBA_OBJECTS. Where the object is absent, equivalent data must be sourced directly from IGS_AD_SPLTAL_INT_ALL if that table has been deployed.