Search Results igf_sl_dl_lor_resp

Overview

IGF_SL_DL_LOR_RESP is a Financial Aid (IGF) view within Oracle E-Business Suite, exposed by the Student Loans (SL) submodule for Direct Loan (DL) processing. The view surfaces loan origination response (LOR) records returned by the Common Origination and Disbursement (COD) system, allowing institutions to reconcile the status of loan submissions, acknowledgements, and accepted amounts. Its role is primarily reporting and integration: it presents acknowledgement-level data—origination acknowledgements, rejection reasons, and Promissory Note (PNOTE) responses—in a form that downstream reports, extracts, and reconciliation programs can consume. In the ETRM 12.2.2 documentation set, the object is flagged as part of the Financial Aid product area, which Oracle marks as obsolete. The view is documented but not implemented in the reference database, meaning the view text is preserved for lineage and documentation purposes while no physical object exists in that environment.

Underlying Base Objects

The view is defined over a single table, IGF_SL_DL_LOR_RESP_ALL, which is the multi-organization base table holding Direct Loan origination response rows. The ETRM metadata records “Referenced base objects: none documented,” so no other tables, synonyms, or joins are declared in the catalogue. Functionally, the view is a filtering and column-mapping layer: it selects a fixed set of columns from the base table and applies an organization security predicate rather than joining to additional entities. The row identifier is derived from the base table’s ROWID, aliased as ROW_ID.

Key Columns

• ROW_ID – the base table ROWID, providing a unique physical locator.
• LOR_RESP_NUM and DBTH_ID – identifiers for the origination response and its associated disbursement batch.
• ORIG_BATCH_ID, LOAN_NUMBER, ORIG_ACK_DATE – the originating submission batch, loan identifier, and acknowledgement date returned by COD.
• ORIG_STATUS_FLAG and ORIG_REJECT_REASONS – the acknowledgement status and any COD rejection cause codes.
• PNOTE_ID, PNOTE_STATUS, PNOTE_ACCEPT_AMT – Promissory Note identification, its status, and the accepted amount. PNOTE_ID is the column most commonly used to trace a response back to a specific MPN.
• LOAN_AMOUNT_ACCEPTED and STATUS – the accepted loan amount and record-level processing status.
• ELEC_MPN_IND – indicates whether an electronic MPN applies.
• Standard WHO/audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and concurrent request context columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE).
• ORG_ID – the operating unit key used by the view’s security predicate.

Common Use Cases and Queries

The view is typically used to reconcile COD acknowledgements, report rejected originations, and confirm accepted MPN amounts. The governing predicate resolves ORG_ID against the client information session value, defaulting unmatched rows to -99, which enforces operating-unit isolation. A representative query retrieving responses for a given Promissory Note is:

SELECT lor_resp_num, loan_number, pnote_status, pnote_id,
       pnote_accept_amt, loan_amount_accepted, status
  FROM igf_sl_dl_lor_resp
 WHERE pnote_id = :p_pnote_id;

A second common pattern identifies rejected originations for follow-up:

SELECT loan_number, orig_ack_date, orig_reject_reasons
  FROM igf_sl_dl_lor_resp
 WHERE orig_status_flag = 'R';

Because the object is documented as not implemented in the reference database and the surrounding product area is obsolete, these queries are best treated as historical reference for environments where the Student Loans Direct Loan features remain deployed.