Search Results mpn_type

Overview

IGF_SL_DL_LOR_CRRESP is an APPS-owned database view within the Oracle E-Business Suite (EBS) Financial Aid module, part of the Student Loan (IGF) schema family. Its name indicates its function: "SL" denotes Student Loan processing, "DL" refers to Direct Loan handling, and "LOR_CRRESP" designates a Letter of Response / Credit Response record. The view exposes credit decision and credit override information associated with Direct Loan originations, including the all-important CREDIT_DECISION_DATE column that users commonly search on when auditing or reporting loan approval activity.

The view is defined as a multi-org view, meaning it automatically filters data according to the operating unit of the session's current context. Rows pertaining to other operating units are invisible to the querying user unless the multi-org profile settings are adjusted. The object is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and its FND Design Data entry (IGF.IGF_SL_DL_LOR_CRRESP) confirms its registration within the application metadata layer.

Underlying Base Objects

Per the documented dependency information, IGF_SL_DL_LOR_CRRESP is defined over a single base object: APPS.IGF_SL_DL_LOR_CRRESP_ALL. The "_ALL" suffix is the standard EBS convention indicating a multi-org (partitioned by ORG_ID) table, and the corresponding view without the suffix applies the operating-unit security predicate MO_GLOBAL / ORG_ID filter. This explains the "View Type" annotation in the metadata, which explicitly states the view "will retrieve data for your current operating unit and ignore data in other operating units."

The view is further referenced by APPS.IGF_SL_DL_ORIG_ACK, another Student Loan object concerned with origination acknowledgements, indicating that credit-response data feeds into loan acknowledgement processing within the Direct Loan lifecycle.

Key Columns

• CREDIT_DECISION_DATE (DATE) — The date on which the credit decision was rendered for the associated loan. This is the column most commonly used for point-in-time reporting and audit trails.
• CREDIT_OVERRIDE (VARCHAR2, 30) — Indicates whether the credit result was overridden, and the nature of that override.
• LOR_RESP_NUM (NUMBER, 15) — Surrogate identifier for the Letter of Response / credit response record.
• DBTH_ID (NUMBER, 15) — Foreign key linking to the debtor (student/borrower) record.
• LOAN_NUMBER (VARCHAR2, 30) — The loan identifier for the associated Direct Loan.
• STATUS (VARCHAR2, 30) — Current processing status of the credit response record.
• MPN_ID, MPN_STATUS, MPN_TYPE, MPN_INDICATOR — Master Promissory Note detail: identifier, lifecycle status, note type, and a control indicator.
• ENDORSER_AMOUNT (NUMBER) — The amount underwritten or endorsed for the loan.
• Standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and concurrent request columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) support audit and process lineage.
• ORG_ID (NUMBER, 15) — The operating unit whose data the view exposes.

Common Use Cases and Queries

A frequent requirement is to identify loans whose credit decision fell within a specific window, or to reconcile credit overrides against expected outcomes. The following query lists credit responses for the current operating unit within a date range:

SELECT LOAN_NUMBER, DBTH_ID, CREDIT_DECISION_DATE, CREDIT_OVERRIDE, STATUS, MPN_STATUS, ENDORSER_AMOUNT
FROM APPS.IGF_SL_DL_LOR_CRRESP
WHERE CREDIT_DECISION_DATE BETWEEN :p_from_date AND :p_to_date
ORDER BY CREDIT_DECISION_DATE DESC;

For MPN reconciliation, filter on MPN_INDICATOR and MPN_TYPE to isolate promissory-note records awaiting acknowledgement, often in conjunction with IGF_SL_DL_ORIG_ACK. Because the view is multi-org, ensure the MO: Operating Unit (or MO: Security Profile) profile option is correctly set for the desired business unit before executing these queries in a reporting or integration context.