Search Results lns_ar_amortizations_v

Overview

The LNS_AR_AMORTIZATIONS_V view resides in the APPS schema and belongs to the Oracle Loans (LNS) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in the ETRM metadata, its stated purpose is to expose basic billing and payment information for every loan in the system, presenting loan-level amortization data in a form suitable for Oracle Receivables (AR) integration and downstream reporting. The view is registered as VALID, confirming that it compiles successfully against the EBS data dictionary in supported releases.

Functionally, the view acts as a reporting and integration surface rather than a transactional table. It consolidates loan identity, payment scheduling, and the numerous credit and adjustment buckets that Loans maintains against principal, interest, and fee components. Consumers of this view typically include AR invoice generation routines, collections and delinquency reporting, and custom extract programs. Users searching for the TOTAL_ADJUSTED_AMOUNT column should note that this identifier does not appear in the documented column list for the view; the adjustment information is instead distributed across the principal, interest, and fee adjustment columns described below.

Underlying Base Objects

The documented view metadata for 12.2.2 records a single referenced base object: the DUAL synonym. This is a significant characteristic. The documented view text consists exclusively of TO_NUMBER(NULL), TO_DATE(NULL), and NULL projections selected FROM DUAL, producing a structurally complete but empty result set. In other words, the shipped definition in the EBS data dictionary is a placeholder or stub, not a populated query against an amortization base table.

This pattern is common in EBS where a view is delivered as a stub to satisfy dependency and compilation requirements, and is subsequently replaced or overridden by customer-specific implementations, product patches, or by the operational logic of the Loans module. Practically, this means that any query against the view in a stock environment returns no rows, and the columns listed in the metadata describe the intended interface contract rather than a guaranteed live data source. Implementers should verify the actual view text in their environment and confirm whether the installation has customized or extended the definition.

Key Columns

The documented column list defines the semantic contract of the view, organized into loan identification, schedule, and monetary buckets:

• LOAN_ID — Identifier of the loan record.
• AMORTIZATION_SCHEDULE_ID — Surrogate key for the amortization schedule line.
• PAYMENT_NUMBER and DUE_DATE — Payment sequence and scheduled due date.
• PRINCIPAL_AMOUNT, INTEREST_AMOUNT, FEE_AMOUNT — Scheduled amounts by component.
• PRIN_CASH, INT_CASH, FEE_CASH — Cash applications against principal, interest, and fees.
• PRIN_LOAN_PMT_CREDIT, INT_LOAN_PMT_CREDIT, FEE_LOAN_PMT_CREDIT — Credits generated by loan payments.
• PRIN_NET_CREDIT, INT_NET_CREDIT, FEE_NET_CREDIT — Net credit amounts following offsetting activity.
• PRIN_NEG_ADJ, PRIN_POS_ADJ, INT_NEG_ADJ, INT_POS_ADJ, FEE_NEG_ADJ, FEE_POS_ADJ — Negative and positive adjustments by component; these are the columns that carry the adjustment semantics a user might associate with a "total adjusted amount."
• PRIN_TD_CASH, PRIN_TD_LOAN_PMT_CREDIT, PRIN_TD_NET_CREDIT, PRIN_TD_OTHER_CREDIT, PRIN_TD_NEG_ADJ, PRIN_TD_POS_ADJ, INT_TD_CA — To-date (TD) cumulative counterparts of the period amounts.

Common Use Cases and Queries

Because the documented definition is a stub over DUAL, the primary practical use case is validation and dependency checking rather than data extraction. A standard query is shown below:

• SELECT loan_id, amortization_schedule_id, payment_number, due_date, principal_amount, interest_amount, fee_amount FROM apps.lns_ar_amortizations_v;
• SELECT loan_id, (prin_pos_adj - prin_neg_adj) prin_adj, (int_pos_adj - int_neg_adj) int_adj, (fee_pos_adj - fee_neg_adj) fee_adj FROM apps.lns_ar_amortizations_v WHERE loan_id = :loan_id; — derives component-level net adjustments, the closest analogue to a total adjusted amount.
• Verification query: SELECT text FROM dba_views WHERE owner='APPS' AND view_name='LNS_AR_AMORTIZATIONS_V'; to confirm whether a site-specific implementation replaces the stub.

Where a total adjusted amount is required, it must be synthesized by summing the positive adjustment columns and subtracting the negative adjustment columns across the principal, interest, and fee groups, optionally using the to-date columns for cumulative balances. Implementers should not assume the view returns rows without first confirming the deployed definition.