Search Results prin_neg_adj

Overview

APPS.LNS_AR_AMORTIZATIONS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It belongs to the Lease and Loan Management (LNS) module and is registered as FND Design Data object LNS.LNS_AR_AMORTIZATIONS_V with a status of VALID. The view presents the receivables side of loan amortization schedules, exposing the cash, credit, adjustment, and credit-memo components that make up each scheduled payment on a loan or lease contract.

The object carries the classification “Oracle Internal Use Only.” Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs. Consequently, the view should be treated as an internal integration and reporting artifact rather than a supported public API. Partner and customer reporting solutions that reference it do so at their own risk, and the Oracle-recommended alternative is to use published LNS APIs, concurrent programs, or the supported business views that surface the same information.

The presence of the column PRIN_NEG_ADJ — the term the user searched for — indicates the view’s specific purpose: aggregating the signed adjustment buckets applied against principal (and, symmetrically, interest and fees). These negative adjustments typically represent write-offs, waivers, corrections, or credit adjustments posted against a scheduled payment line.

Underlying Base Objects

The documented ETRM metadata lists only DUAL (SYNONYM) as a referenced base object, which reflects the way the dictionary entry was captured rather than the true data lineage. In practice, the view is layered over the LNS amortization and receivables distribution tables, including LNS_AMORTIZATION_SCHEDULES and its associated transaction and distribution tables that store the original billed amounts and each subsequent adjustment, credit, and application. The view consolidates these rows into a single row per amortization schedule line so that each scheduled payment can be reported with its full set of component amounts and its remaining balance.

Because it is defined as an internal view, its definition is not guaranteed to be stable across patches or point releases. Any custom object referencing it should be re-validated after applying LNS family patches or upgrading between 12.1.1 and 12.2.2.

Key Columns

• LOAN_ID, AMORTIZATION_SCHEDULE_ID, PAYMENT_NUMBER, DUE_DATE: Identify the loan, the amortization schedule row, the sequential payment number, and the scheduled due date.
• PRINCIPAL_AMOUNT, INTEREST_AMOUNT, FEE_AMOUNT: The original scheduled components of the payment before adjustments and credits.
• PRIN_CASH, PRIN_LOAN_PMT_CREDIT, PRIN_NET_CREDIT, PRIN_OTHER_CREDIT, PRIN_NEG_ADJ, PRIN_POS_ADJ: The principal receipt and adjustment buckets. PRIN_NEG_ADJ captures negative principal adjustments; PRIN_POS_ADJ captures positive ones. Parallel INT_ and FEE_ columns carry the same decomposition for interest and fees.
• *_TD_* columns: Period-to-date or transaction-date accumulations of the same cash, credit, and adjustment buckets (for example PRIN_TD_NEG_ADJ, FEE_TD_CASH).
• TOTAL_PRIN_TD_* columns: Loan-level totals of the principal transaction-date buckets.
• FUNDED_AMOUNT, TOTAL_BILLED_AMOUNT, TOTAL_AR_BILLED_AMOUNT, TOTAL_REMAINING_AMOUNT, TOTAL_APPLIED_AMOUNT, LAST_APPLIED_DATE: Status and balance metrics for the schedule line.
• TOTAL_ADJUSTED_AMOUNT, TOTAL_CREDITED_AMOUNT, LAST_CREDITED_DATE, REVERSED_CODE: Aggregate adjustment and credit-memo amounts, the date of the last credit, and an indicator that the line has been reversed.
• PARENT_AMORTIZATION_ID, BILL_TYPE_CODE, PRINCIPAL_REMAINING, CREATION_DATE: Hierarchy, billing classification, remaining principal, and row creation metadata.

Common Use Cases and Queries

The view is typically used to reconcile billed loan amortization to receivables activity, to analyze how much of each scheduled payment was settled in cash versus adjusted or credited, and to trace negative principal adjustments. A representative query isolating the PRIN_NEG_ADJ bucket is:

• SELECT LOAN_ID, AMORTIZATION_SCHEDULE_ID, PAYMENT_NUMBER, DUE_DATE, PRINCIPAL_AMOUNT, PRIN_NEG_ADJ, PRIN_POS_ADJ, TOTAL_PRIN_TD_NEG_ADJ, TOTAL_REMAINING_AMOUNT, REVERSED_CODE FROM APPS.LNS_AR_AMORTIZATIONS_V WHERE PRIN_NEG_ADJ <> 0 ORDER BY LOAN_ID, PAYMENT_NUMBER;
• Summarizing adjustments per loan: SELECT LOAN_ID, SUM(PRIN_NEG_ADJ) PRIN_NEG, SUM(INT_NEG_ADJ) INT_NEG, SUM(FEE_NEG_ADJ) FEE_NEG FROM APPS.LNS_AR_AMORTIZATIONS_V GROUP BY LOAN_ID;
• Identifying unreversed lines with an outstanding balance: SELECT LOAN_ID, PAYMENT_NUMBER, TOTAL_REMAINING_AMOUNT, LAST_CREDITED_DATE FROM APPS.LNS_AR_AMORTIZATIONS_V WHERE REVERSED_CODE IS NULL AND TOTAL_REMAINING_AMOUNT > 0;

Because the object is flagged for Oracle internal use, Production queries should be reviewed with Oracle Support, and any dependency on undocumented column semantics — particularly the exact sign convention of PRIN_NEG_ADJ — should be confirmed before the results are relied upon for financial reporting.