Search Results lodisbh_id

Overview

The IGF_SL_DISB_LOC_HISTORY table is a core data repository within the Oracle E-Business Suite (EBS) Student Loan (SL) module, specifically for releases 12.1.1 and 12.2.2. It functions as a historical audit trail for loan disbursement transactions communicated to external lending agencies or guarantors. The table's primary role is to persistently store a record of each disbursement detail sent for external processing, capturing both the initial submission data and subsequent updates or responses. This ensures a complete, immutable history for compliance, reconciliation, and troubleshooting purposes within the financial aid lifecycle.

Key Information Stored

The table stores detailed financial and transactional data for each disbursement event. The LODISBH_ID column serves as the unique, system-generated primary key for each history record. Critical identifiers include AWARD_ID and DISBURSEMENT_NUMBER, which link the history to a specific award disbursement. Core financial amounts are captured in columns such as DISBURSEMENT_GROSS_AMT, DISBURSEMENT_NET_AMT, ORIGINATION_FEE_AMT, and GUARANTEE_FEE_AMT. The table also records the transactional context via DISBURSEMENT_DATE, DISBURSEMENT_HOLD_REL_IND, and SOURCE_TXT, which indicates whether the record originated from the system or was a response from an external agency. Standard EBS "Who" and concurrent program columns (CREATED_BY, REQUEST_ID, etc.) provide auditability for the record's creation and modification.

Common Use Cases and Queries

This table is central to reconciliation and reporting processes. Common use cases include auditing the sequence of disbursement submissions to an external servicer, verifying fee calculations, and investigating discrepancies between the system's intended disbursement amounts and the amounts acknowledged or paid by the external agency. A typical query retrieves the full history for a specific award disbursement to trace its processing lifecycle.

• Retrieve Disbursement History for an Award:
  SELECT lodisbh_id, disbursement_date, disbursement_gross_amt, disbursement_net_amt, source_txt, creation_date FROM igf.igf_sl_disb_loc_history WHERE award_id = &AWARD_ID ORDER BY creation_date;
• Audit Fee Amounts for Reconciliation:
  SELECT award_id, disbursement_number, SUM(origination_fee_amt) total_orig_fee, SUM(origination_fee_paid_amt) total_orig_fee_paid FROM igf.igf_sl_disb_loc_history GROUP BY award_id, disbursement_number;

Related Objects

The IGF_SL_DISB_LOC_HISTORY table maintains a direct foreign key relationship to the core award disbursement table. This relationship is fundamental for joining historical records to current award data.

• Primary Key: IGF_SL_DISB_LOC_HISTORY_PK on the LODISBH_ID column.
• Foreign Key (References): The AWARD_ID column in IGF_SL_DISB_LOC_HISTORY references the IGF_AW_AWD_DISB_ALL table. This links each historical disbursement record to its originating award disbursement definition within the EBS system.