Results for “change_code”

5 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

IGFFV_DL_ORIGINATION_CHANGES is an Oracle E-Business Suite (EBS) view owned by the APPS schema and registered under the IGF — Financial Aid product. It presents a full, read-only view of the entity that holds Financial Aid Direct Loan origination changes. In the Oracle EBS 12.1.1 and 12.2.2 architectures, views in the IGF schema typically serve as the reporting and integration layer over the underlying transaction tables used by the Financial Aid Direct Loan processing modules. This view consolidates change records for Direct Loan origination together with the batch context in which those changes were transmitted or received, exposing both surrogate keys and descriptive attributes in a single queryable object.

The view is defined with the WITH READ ONLY clause, which enforces that all access is for query purposes only and no DML can be issued against it. This is characteristic of ETRM (Electronic Transaction Reporting/Management) and Financial Aid integration views, which are intended to support reporting, reconciliation, and downstream data extraction rather than transactional updates.

Underlying Base Objects

The view text is defined over two base tables joined on the batch identifier:

  • IGF_SL_DL_CHG_SEND_ALL — aliased as CHG; the Financial Aid Direct Loan change records table, holding the loan number, change code, new value, change number, and audit columns.
  • IGF_SL_DL_BATCH_ALL — aliased as BATCH; the Direct Loan batch table, holding batch-level attributes such as batch ID, creation date, batch type, rejection code, status, and response indicator.

The join condition is CHG.DBTH_ID = BATCH.DBTH_ID, meaning each change record is linked to its parent batch through the internal batch identifier. The view therefore returns one row per change record enriched with the corresponding batch attributes. The ETRM metadata notes that no referenced base objects are separately documented, and the owner is not restated, but the view text supplies the authoritative definitions.

Key Columns

The view exposes a mixture of physical columns and lookup-descriptor columns. The lookup-descriptor columns are expressed as literal strings of the form '_LA:<column>:IGF_LOOKUPS_VIEW:<lookup_type>:MEANING', which instruct the reporting layer to resolve coded values to their lookup meanings.

Common Use Cases and Queries

Typical uses include reconciling origination changes against batch transmission, troubleshooting rejections, and building integration extracts. Because BATCH_FILE_ID is a documented column, queries frequently filter or group on it.

  • Retrieve all changes for a given batch file:
    SELECT loan_number, change_code, new_value,
           batch_file_id, batch_file_type, batch_file_creation_date
    FROM   apps.igffv_dl_origination_changes
    WHERE  batch_file_id = :p_batch_file_id;
  • Review rejection status by batch:
    SELECT batch_file_id, "_LA:BATCH_REJECTION_CODE",
           "_LA:BATCH_STATUS", loan_number, change_code
    FROM   apps.igffv_dl_origination_changes
    WHERE  "_LA:BATCH_REJECTION_CODE" IS NOT NULL;
  • Audit recent change activity:
    SELECT loan_number, change_code, new_value,
           batch_id, creation_date, last_update_date
    FROM   apps.igffv_dl_origination_changes
    ORDER  BY last_update_date DESC;

These queries support the view's purpose as a read-only reporting and reconciliation object within Oracle EBS Financial Aid Direct Loan processing.