Search Results igf_sl_rep_smry_v

Overview

IGF_SL_REP_SMRY_V is a reporting view in the Oracle E-Business Suite Financial Aid module (IGF), delivered within the Student Loan / Direct Loan processing functionality. Its documented purpose is to support the financial summary tag written into the outbound XML file transmitted for Direct Loan processing. In the context of Oracle EBS 12.1.1 and 12.2.2, this view acts as an aggregation layer that consolidates loan award and disbursement data into the summarized figures required by the Common Origination and Disbursement (COD) reporting schema.

The view is classified under IGF – Financial Aid, which carries an obsolete designation in current ETRM documentation. Organizations upgrading or maintaining older 12.1.1 environments that still process Direct Loans may still encounter references to this object, whereas environments that have transitioned off the legacy Direct Loan integration will find it unused. Note that the ETRM metadata states the object is not implemented in the reference database, meaning it exists as documented source but may not be deployed in every instance.

Underlying Base Objects

The view is defined over two base tables within the IGF schema:

• IGF_SL_LOR_LOC_ALL — the loan origination record and location table, which holds award-level loan records and is aliased as LOC1 (and LOC2 in the subquery).
• IGF_AW_DB_COD_DTLS — the COD disbursement detail table, aliased as DISB2, which stores accepted disbursement amounts per award.

The view joins these objects in two logical steps. The inner inline subquery aggregates accepted disbursement amounts from IGF_AW_DB_COD_DTLS joined to IGF_SL_LOR_LOC_ALL by AWARD_ID, producing a single disbursement total per award. The outer query then joins the main loan record set to this aggregated result through an outer join on AWARD_ID, using the (+) operator. A filter restricts the outer query to loan types 'DLP', 'DLS', and 'DLU' before grouping. No documented referenced base objects beyond these appear in the metadata.

Key Columns

• DOCUMENT_ID_TXT — the originating document identifier for the loan record, used to correlate the summary to the outbound XML document.
• REP_ENTITY_ID_TXT — the reporting entity identifier, typically the school or institution code reported to COD.
• FIN_AWARD_YEAR — the financial aid award year the loan belongs to.
• LOAN_TYPE — the coded loan type ('DLS', 'DLP', 'DLU').
• FIN_AWARD_TYPE — a decoded value derived via DECODE, translating 'DLS' to DLSUBSIDIZED, 'DLP' to DLPLUS, and 'DLU' to DLUNSUBSIDIZED.
• TOT_CNT_NUM — the distinct count of BASE_ID values, representing the number of borrowers or base records in the group.
• TOT_REP_AWD_AMT — the sum of LOAN_AMT_ACCEPTED, the total reported accepted award amount.
• TOT_REP_DISB_AMT — the sum of NVL(DISB_AMT, 0), the total reported disbursed amount, safely defaulting to zero where no disbursement exists.

Common Use Cases and Queries

The primary use case is generating the financial summary block of the Direct Loan outbound XML. A typical query retrieves aggregated figures grouped by document, entity, and award year:

• Reconciling accepted versus disbursed totals per loan type before transmission.
• Auditing counts of distinct borrowers by award year and reporting entity.
• Populating the summary tag values in the COD outbound interface.

A representative query:

SELECT DOCUMENT_ID_TXT, REP_ENTITY_ID_TXT, FIN_AWARD_YEAR, FIN_AWARD_TYPE, TOT_CNT_NUM, TOT_REP_AWD_AMT, TOT_REP_DISB_AMT FROM IGF_SL_REP_SMRY_V WHERE FIN_AWARD_YEAR = :p_award_year AND REP_ENTITY_ID_TXT = :p_entity; Because the view already performs the grouping and decode, callers need only filter and project. Given its obsolete status, new development should prefer current COD reporting objects, and verification of deployment against each target instance is advisable.