Search Results oldest_overdue_date




Overview
Explore in AI Chat

Overview

APPS.LNS_PAY_SUM_OVERDUE_V is a predefined Oracle E-Business Suite view owned by the APPS schema within the Loans (LNS) module. Its FND Design Data identifier is LNS.LNS_PAY_SUM_OVERDUE_V, and its status is VALID in both Oracle EBS 12.1.1 and 12.2.2. The view consolidates overdue loan receivables into a single summarized row per loan, exposing aggregated principal, interest, and fee past-due balances together with bill counts and payment history indicators. It is an internal, Oracle-only object; Oracle Corporation explicitly does not support direct customer access to applications data through this view except via standard Oracle Applications programs.

The view is catalogued with the warning "Oracle Internal Use Only," meaning it should be treated as a read-only reporting and integration surface rather than a supported customization target. The user search term "oldest_overdue_date" maps directly to the OLDEST_OVERDUE_DATE column, which returns the earliest due date among the overdue amortization lines for each loan — a common aging and delinquency metric in lending operations.

Underlying Base Objects

According to ETRM metadata, LNS_PAY_SUM_OVERDUE_V references the following base objects, all resolved as synonyms under APPS:

  • AR_PAYMENT_SCHEDULES_ALL — the Receivables payment schedule table, which supplies individual installment due dates, amounts due, and status used to identify overdue lines.
  • AR_RECEIVABLE_APPLICATIONS_ALL — the Receivables application table, which links payments to invoices and installment lines and provides the basis for last payment amount and date.
  • LNS_AMORTIZATION_SCHEDS — the Loans amortization schedule table, which holds the loan-level amortization breakdown of principal, interest, and fees.
  • LNS_LOAN_HEADERS_ALL — the Loans header table, which supplies the LOAN_ID that keys every summarized row.

The view is joined primarily on LOAN_ID and the associated payment schedule identifiers, aggregating overdue amounts across the amortization and payment schedule detail to produce one summary record per loan. It is referenced by the APPS packages LNS_OCM_ADP_PUB and LNS_WORK_FLOW, confirming its role inside the Loan workflow and Origination/Contract Management public APIs.

Key Columns

  • LOAN_ID (NUMBER(15)) — the numeric identifier of the loan; the primary grouping key.
  • PRINCIPAL_OVERDUE, INTEREST_OVERDUE, FEE_OVERDUE — the overdue components broken out by amount type.
  • TOTAL_OVERDUE — the sum of principal, interest, and fee overdue amounts.
  • NUMBER_OVERDUE_BILLS — the count of overdue installments or bills for the loan.
  • LAST_OVERDUE_DATE — the most recent overdue due date (latest delinquent installment).
  • OLDEST_OVERDUE_DATE — the earliest overdue due date, used for aging buckets and delinquency reporting.
  • LAST_PAYMENT_AMOUNT and LAST_PAYMENT_DATE — the amount and date of the most recent payment applied against the loan.

Common Use Cases and Queries

Typical uses include delinquency reporting, aging analysis, and feeding downstream collections or workflow logic. The following query demonstrates the query text documented in ETRM:

SELECT LOAN_ID,
       PRINCIPAL_OVERDUE,
       INTEREST_OVERDUE,
       FEE_OVERDUE,
       TOTAL_OVERDUE,
       NUMBER_OVERDUE_BILLS,
       LAST_OVERDUE_DATE,
       OLDEST_OVERDUE_DATE,
       LAST_PAYMENT_AMOUNT,
       LAST_PAYMENT_DATE
FROM   APPS.LNS_PAY_SUM_OVERDUE_V;

To isolate the oldest delinquent exposure, filter by the user's searched column:

SELECT LOAN_ID, TOTAL_OVERDUE, OLDEST_OVERDUE_DATE
FROM   APPS.LNS_PAY_SUM_OVERDUE_V
WHERE  OLDEST_OVERDUE_DATE = (SELECT MIN(OLDEST_OVERDUE_DATE)
                              FROM   APPS.LNS_PAY_SUM_OVERDUE_V)
AND    TOTAL_OVERDUE > 0;

Because the view is Oracle-internal and read-only, any integration should consume it through supported Oracle programs or the documented LNS public APIs rather than through direct DML.