Search Results lns_amortization_lines_u1

Overview

The LNS.LNS_AMORTIZATION_LINES table is a core transactional object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Leasing and Loans (LNS) module, part of the Enterprise Treasury and Risk Management (ETRM) application family. It stores the individual accounting lines that make up each amortization schedule, decomposing a schedule into discrete INTEREST, PRINCIPAL, and FEES components. Where LNS_AMORTIZATION_SCHEDS records the header-level amortization definition, LNS_AMORTIZATION_LINES captures the granular detail required for interest accrual, principal reduction, fee recognition, and downstream receivables generation.

Based on the foreign key topology documented in the ETRM metadata, this object can be characterized as a Data Vault link table. It connects a loan header (LNS_LOAN_HEADERS_ALL), an amortization schedule, a fee schedule, and Oracle Receivables transaction lines (RA_CUSTOMER_TRX_LINES_ALL) in a single associative structure. This link classification is a modeling suggestion derived heuristically from the FK structure, not a functional designation. The table resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10, and its indexes reside in APPS_TS_TX_IDX. The object is registered against FND Design Data as LNS.LNS_AMORTIZATION_LINES with status VALID.

Key Information Stored

Each row carries a 16-column physical schema, of which the following are most significant:

• AMORTIZATION_LINE_ID — the surrogate primary key of the table, a NUMBER(15). It is the leading column of the unique index LNS_AMORTIZATION_LINES_U1 and the basis of the primary key constraint LNS_AMORTIZATION_LINES_PK.
• CUST_TRX_LINE_ID — foreign key to RA_CUSTOMER_TRX_LINES_ALL. This is the documented business-key candidate: it forms the unique index LNS_AMORTIZATION_LINES_U2, which is the specific index most frequently referenced by searches such as "lns_amortization_lines_u2". This uniqueness constraint ensures one amortization line per receivables transaction line.
• AMORTIZATION_SCHEDULE_ID — identifies the parent amortization schedule (foreign key to LNS_AMORTIZATION_SCHEDS).
• LOAN_ID — identifies the originating loan (foreign key to LNS_LOAN_HEADERS_ALL), also part of the non-unique index LNS_AMORTIZATION_LINES_N1 alongside AMORTIZATION_SCHEDULE_ID.
• LINE_TYPE — a VARCHAR2(30) classifying the line as INTEREST, PRINCIPAL, or FEES.
• AMOUNT — the monetary value of the amortization line.
• CUST_TRX_ID — foreign key to RA_CUSTOMER_TRX_ALL, tying the line to its receivables transaction.
• FEE_SCHEDULE_ID and FEE_ID — foreign keys linking to fee structures (LNS_FEE_SCHEDULES and LNS_FEE_ASSIGNMENTS respectively).
• OBJECT_VERSION_NUMBER and the standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) — audit and optimistic locking attributes.
• LINE_DETAILS — appears in the documented physical schema (16 columns) and holds supplementary descriptive attributes for the line.

Common Use Cases and Queries

Typical usage centers on extracting amortization detail for a loan, schedule, or receivables transaction. A common pattern retrieves all lines for a schedule grouped by line type:

• Interest and principal roll-forward reporting: filter by LOAN_ID and AMORTIZATION_SCHEDULE_ID, aggregating AMOUNT by LINE_TYPE.
• Reconciliation between the LNS module and Oracle Receivables: join CUST_TRX_LINE_ID to RA_CUSTOMER_TRX_LINES_ALL to confirm that every amortization line has a corresponding AR line.
• Fee recognition analysis: join FEE_SCHEDULE_ID and FEE_ID to LNS_FEE_SCHEDULES and LNS_FEE_ASSIGNMENTS to trace fee-based amortization.

A representative query: SELECT aml.LINE_TYPE, SUM(aml.AMOUNT) FROM lns_amortization_lines aml WHERE aml.AMORTIZATION_SCHEDULE_ID = :p_sched GROUP BY aml.LINE_TYPE. Lookups by the AMORTIZATION_LINE_ID or CUST_TRX_LINE_ID unique keys resolve to a single row, consistent with the U1 and U2 indexes.

Related Objects

The metadata documents five key FK relationships that anchor this table:

• LNS_LOAN_HEADERS_ALL — joined via LOAN_ID; the loan header that drives the schedule.
• LNS_AMORTIZATION_SCHEDS — joined via AMORTIZATION_SCHEDULE_ID; the parent schedule holding the line set.
• RA_CUSTOMER_TRX_ALL — joined via CUST_TRX_ID; the AR transaction header.
• RA_CUSTOMER_TRX_LINES_ALL — joined via CUST_TRX_LINE_ID; the AR transaction line uniquely linked by LNS_AMORTIZATION_LINES_U2.
• LNS_FEE_SCHEDULES — joined via FEE_SCHEDULE_ID; the fee schedule referenced for fee lines, with LNS_FEE_ASSIGNMENTS referenced through FEE_ID.