Search Results academic_year_txt

Overview

The IGF_AP_LI_CSS_ACT_INTS table is a critical interface table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Institutional Grants and Financial Aid (IGF) product. Its designated role is to serve as the staging area for the "Legacy - Make PROFILE Active Process." This process is responsible for identifying and flagging a specific student financial aid profile as the active record for processing. The table acts as a temporary holding area where data is loaded before being validated and processed by a concurrent program, which then updates the status in the core application tables. Its storage in the APPS_TS_INTERFACE tablespace further confirms its transient, interface-specific nature.

Key Information Stored

The table stores a batch of records intended for the profile activation process. Each record is uniquely identified by the mandatory CSAINT_ID column, which serves as the primary key. Key business data columns include BATCH_NUM for grouping records, PERSON_NUMBER and CSS_ID_NUMBER_TXT for student identification, and CI_ALTERNATE_CODE (Award Year) and ACADEMIC_YEAR_TXT for temporal context. The STU_RECORD_TYPE and IMPORT_STATUS_TYPE columns are crucial for defining the profile type and tracking the success or failure of the record's processing by the concurrent program. The table also includes a full complement of Standard Who columns (CREATED_BY, CREATION_DATE, etc.) for auditability.

Common Use Cases and Queries

The primary use case is the execution of the "Make PROFILE Active" concurrent request. A typical workflow involves: 1) Truncating the interface table, 2) Inserting a set of candidate profile records via a custom program or SQL*Loader, 3) Running the concurrent process to validate and activate the specified profiles, and 4) Querying the interface table to review the import status. Common diagnostic queries include checking for records with errors or pending status, and tracing records by batch or student.

• Reviewing processing status for a specific batch: SELECT person_number, css_id_number_txt, import_status_type FROM igf.igf_ap_li_css_act_ints WHERE batch_num = &batch_id;
• Identifying failed records for data fix and re-submission: SELECT * FROM igf.igf_ap_li_css_act_ints WHERE import_status_type = 'ERROR';

Related Objects

The table has a documented foreign key relationship, indicating a direct data dependency. The BATCH_NUM column references the IGF_AP_LI_BAT_INTS table. This relationship ensures that every set of records processed through IGF_AP_LI_CSS_ACT_INTS is linked to a valid, controlling batch header record, which is a common pattern for managing interface data loads in EBS. The primary key constraint IGF_AP_LI_CSS_ACT_INTS_PK is defined on the CSAINT_ID column to enforce record uniqueness.