Search Results lns_amortization_lines




Overview
Explore in AI Chat

Overview

LNS_AMORTIZATION_LINES is a transaction-detail table in the Oracle E-Business Suite Loans (LNS) module, part of the Financial Services product family that includes Lease Management and lending operations. The table stores the individual line records that make up any given amortization defined on the parent amortization schedule. Where LNS_AMORTIZATION_SCHEDULES holds the schedule header, LNS_AMORTIZATION_LINES holds the period-by-period or event-by-event detail rows — the actual amounts, line types, and accounting references that drive amortization posting and revenue or expense recognition over the life of a loan or lease contract.

From a heuristic Data Vault modeling perspective, the mined foreign-key structure classifies this object as a link. It sits at the intersection of several business entities — amortization schedules, loans, fee schedules, and Oracle Receivables transactions — and its unique identifiers recruit business-key candidates rather than acting purely as a hub. In Oracle EBS 12.1.1 and 12.2.2 the table is owned by the LNS schema and is documented as VALID in the ETRM object registry.

Key Information Stored

The documented physical schema contains 16 columns. The most significant are:

Common Use Cases and Queries

Typical reporting retrieves the amortization detail for a single loan or schedule, reconciles amortization to Receivables invoices, or audits fee amortization. A representative query joins lines to their parent schedule and to the loan:

  • Amortization detail by loan: SELECT l.AMORTIZATION_LINE_ID, l.LINE_TYPE, l.AMOUNT FROM LNS_AMORTIZATION_LINES l WHERE l.LOAN_ID = :loan_id ORDER BY l.AMORTIZATION_SCHEDULE_ID, l.AMORTIZATION_LINE_ID;
  • Reconciliation to Receivables: join CUST_TRX_ID to RA_CUSTOMER_TRX_ALL and CUST_TRX_LINE_ID to RA_CUSTOMER_TRX_LINES_ALL to verify that each amortization amount is reflected on an AR transaction line.
  • Fee amortization reporting: join FEE_SCHEDULE_ID to LNS_FEE_SCHEDULES and FEE_ID to the fee definition to break amortization down by fee component.
  • Period-based extract for GL posting or revenue recognition schedules, aggregating AMOUNT by LINE_TYPE and schedule.

Related Objects

  • LNS_AMORTIZATION_SCHEDULES — parent header; join on AMORTIZATION_SCHEDULE_ID.
  • LNS_FEE_SCHEDULES — referenced via FEE_SCHEDULE_ID.
  • RA_CUSTOMER_TRX_ALL — Receivables transaction header; join on CUST_TRX_ID.
  • RA_CUSTOMER_TRX_LINES_ALL — Receivables transaction line; join on CUST_TRX_LINE_ID.
  • Loan master objects — referenced via LOAN_ID to the LNS loan contract tables.
  • LNS_AMORTIZATION_LINES_PK / LNS_AMORTIZATION_LINES_U1 / LNS_AMORTIZATION_LINES_U2 — primary key and unique indexes providing identity and business-key enforcement.