Results for “loan_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

LNS_LOAN_PAYMENT_SUMMARY_V is a public APPS schema view within the Oracle EBS Loans (LNS) module. It exposes basic billing and payment summary information for every loan recorded in the system, and it is explicitly designated as a public view intended for consumption by other applications. Because it is a view rather than a base table, it provides a consolidated, pre-joined projection of loan balances, due dates, and billing amounts without requiring external applications to reconstruct the underlying loan, amortization, and receivables relationships themselves.

The view is documented as VALID in ETRM 12.2.2 and is available in both 12.1.1 and 12.2.2 environments. Its role is primarily reporting and integration: downstream modules, custom reports, and interfaces that need a per-loan payment snapshot can query this single object rather than navigating the LNS and AR schemas directly.

Underlying Base Objects

The view is defined over the following documented base objects, referenced through synonyms in the APPS schema:

• LNS_LOAN_HEADERS_ALL — the primary loan master table. It supplies the loan identity, funded amount, loan status, current phase, last payment number, and last amortization identifier that drive the view's conditional logic.
• LNS_AMORTIZATION_SCHEDS — the amortization schedule table. It contributes due dates, principal, interest, and fee amounts, payment numbering, reversal status, phase, and the reamortization attribute.
• AR_PAYMENT_SCHEDULES_ALL — the Receivables payment schedule. It provides amount applied and amount due remaining figures used to compute outstanding balances.
• AR_RECEIVABLE_APPLICATIONS_ALL — the Receivables applications table, referenced in the application metadata for payment application detail.

The view correlates these objects on LOAN_ID, ORG_ID, and the principal, interest, and fee transaction identifiers, tying loan amortization rows to their corresponding AR payment schedules.

Key Columns

• LOAN_ID — the unique loan identifier, carried from LNS_LOAN_HEADERS_ALL and used as the join key across all underlying objects.
• Outstanding principal balance — computed as FUNDED_AMOUNT minus the sum of AMOUNT_APPLIED from AR_PAYMENT_SCHEDULES_ALL for schedules linked to amortization rows up to and including the loan's last payment number.
• Current due date — the DUE_DATE of the amortization schedule identified by the loan's LAST_AMORTIZATION_ID, returned only when the loan status is ACTIVE, DEFAULT, or DELINQUENT.
• Current billing amount — the sum of PRINCIPAL_AMOUNT, INTEREST_AMOUNT, and FEE_AMOUNT for the last payment number, excluding reversed rows and rows where REAMORTIZATION_AMOUNT is populated.
• Past due amount — the sum of AMOUNT_DUE_REMAINING for amortization rows with due dates earlier than the current date and not reversed.
• Loan status, current phase, and last payment number — control attributes that govern which conditional calculations return values and which rows participate.

Common Use Cases and Queries

Typical uses include loan servicing dashboards, delinquency monitoring, and integration feeds that must report current balance, next due date, and past due amounts. A representative query follows:

• SELECT LOAN_ID, CURRENT_DUE_DATE, CURRENT_BILLING_AMOUNT, PAST_DUE_AMOUNT FROM LNS_LOAN_PAYMENT_SUMMARY_V WHERE LOAN_ID = :p_loan_id;
• SELECT LOAN_ID, PAST_DUE_AMOUNT FROM LNS_LOAN_PAYMENT_SUMMARY_V WHERE PAST_DUE_AMOUNT > 0 ORDER BY PAST_DUE_AMOUNT DESC;

Because REAMORTIZATION_AMOUNT is used internally to exclude reamortized schedule rows from the current billing calculation, users searching on that term should note that it is a filtering predicate within the view definition rather than a projected column.