Search Results transaction_num_txt




Overview
Explore in AI Chat

Overview

The IGF_AP_LI_ISIR_ACT_INTS table is a legacy interface table within the Oracle E-Business Suite's Institutional Grants and Financial Aid (IGF) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to serve as a staging area for data that controls the process of designating a specific Institutional Student Information Record (ISIR) as the active record for a student. The ISIR is a critical data set in U.S. federal student aid processing, and determining the active ISIR is essential for accurate financial aid packaging and need analysis. This table facilitates a batch-oriented process, allowing administrators to specify which ISIR records should be promoted to active status based on criteria like award year and transaction number.

Key Information Stored

The table stores control data for the "Make ISIR Active" process. Key columns include the ACTINT_ID, which is the primary key and uniquely identifies each interface record. The BATCH_NUM groups records for collective processing, linking to the master batch interface table. Student identification is provided via PERSON_NUMBER and the relevant CI_ALTERNATE_CODE (Award Year). The specific ISIR to be activated is identified by the TRANSACTION_NUM_TXT and BATCH_YEAR_NUM. The IMPORT_STATUS_TYPE column tracks the processing state of each record (e.g., pending, processed, error). The table also contains standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, etc.) for auditing and the standard program columns for concurrent request integration.

Common Use Cases and Queries

The primary use case is the batch activation of ISIR records, often initiated via a concurrent program that reads from this interface table. Common operational queries involve monitoring the status of batch submissions and troubleshooting failed records. A typical query to review pending records for a specific batch would be:

  • SELECT PERSON_NUMBER, CI_ALTERNATE_CODE, TRANSACTION_NUM_TXT, IMPORT_STATUS_TYPE FROM IGF.IGF_AP_LI_ISIR_ACT_INTS WHERE BATCH_NUM = &BATCH_NUMBER AND IMPORT_STATUS_TYPE = 'PENDING';

For reporting and reconciliation, administrators may join this table with core ISIR transaction tables to verify which interface records successfully triggered an active ISIR change. Checking for records associated with a specific concurrent request is another common pattern, utilizing the REQUEST_ID column.

Related Objects

The table has a documented foreign key relationship, indicating its dependency on a master batch control table. The BATCH_NUM column in IGF_AP_LI_ISIR_ACT_INTS references the IGF_AP_LI_BAT_INTS table. This relationship ensures that interface records belong to a valid, submitted batch. The table's primary key, IGF_AP_LI_ISIR_ACT_INTS_PK, is defined uniquely on the ACTINT_ID column. While the provided metadata does not list objects that reference this table, it is intrinsically linked to the core ISIR transaction and student data tables within the IGF module, which are updated by the downstream "Make ISIR Active" process that consumes this interface's data.