Search Results orig_batch_date




Overview
Explore in AI Chat

Overview

IGF_SL_COD_REP_V is a reporting view in the Oracle E-Business Suite Financial Aid module (IGF), part of the Student Loan processing functionality. The view presents a flattened, report-oriented projection of student loan origination and disbursement data, combining loan-level attributes with borrower, student, and entity identification details. Its naming convention (COD_REP) indicates it supports Common Origination and Disbursement (COD) reporting, the federal-style loan reporting interface used by institutions participating in Title IV loan programs. In EBS 12.1.1 and 12.2.2 the view is owned by the APPS schema and is intended for read-only reporting, integration extracts, and downstream reconciliation. Because the underlying table is a multi-org (All) table, the view inherits organization-level security filtering through the MLS (Multi-Org) rules applied at the session level.

Underlying Base Objects

The view is defined over a single documented base object: IGF_SL_LOR_LOC_ALL (Loan Origination/Original Loan Record, All Organizations). No joins to other base tables are documented; the view is a straightforward SELECT-projecting transformation of that table. However, the view applies several column-level transformations rather than returning raw columns, including date formatting and character extraction. No explicit WHERE clause is shown in the excerpt, so filtering (for example by org_id or business group) is expected to be applied by the multi-org view wrapper or by the consuming report. From an ETRM metadata standpoint, no additional referenced base objects are documented.

Key Columns

The view exposes a large, report-oriented column set. Notable columns relevant to the loan_number search term and loan reporting are:

Common Use Cases and Queries

Typical uses include COD reporting extracts, loan reconciliation, and borrower notification or disclosure processing. A representative query retrieving a loan by loan number might be:

SELECT LOAN_NUMBER_TXT, FIN_AWD_NUM, LOAN_TYPE, LOAN_AMT_ACCEPTED, LOAN_STATUS, P_LAST_NAME, P_FIRST_NAME, LOAN_PER_BEGIN_DATE FROM APPS.IGF_SL_COD_REP_V WHERE LOAN_NUMBER_TXT = :p_loan_number;

Other common patterns filter by FIN_AWARD_YEAR and LOAN_STATUS for period reporting, or by REP_ENTITY_ID_TXT for entity-specific extracts. Because date fields are returned as formatted character strings, consumers must apply appropriate TO_DATE conversions when performing range comparisons.