Results for “lns_terms”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

LNS_TERMS is the Loans Terms table in the Oracle E-Business Suite Loans (LNS) module. It stores the contractual and financial terms that govern how a loan behaves over its life — rate mechanics, payment scheduling, amortization, prepayment penalties, and delinquency thresholds. In releases 12.1.1 and 12.2.2 the table resides in the LNS schema and is documented as VALID with 71 columns. Each row represents the term definition associated with a specific loan header, and the object is therefore a child of LNS_LOAN_HEADERS_ALL.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is satellite-leaning. Although the table carries a surrogate primary key (TERM_ID), its operative relationship to LNS_LOAN_HEADERS_ALL via LOAN_ID means it functions as a descriptive satellite hanging off the loan hub/link, rather than as an independent hub or a connecting link.

Key Information Stored

The surrogate primary key is TERM_ID, enforced by LNS_TERMS_PK; a unique index LNS_TERMS_U1 also exists on TERM_ID, making it the only documented business-key candidate. The foreign key LOAN_ID ties each term row to its parent loan header. Among the 71 columns, the following are the most significant:

• LOAN_ID — foreign key to LNS_LOAN_HEADERS_ALL; identifies the loan whose terms are being defined.
• DAY_COUNT_METHOD — basis for day-count interest accrual.
• RATE_TYPE, INDEX_RATE_ID, INDEX_NAME — indicate fixed, floating, or indexed pricing and the reference index.
• CEILING_RATE, FLOOR_RATE, OPEN_CEILING_RATE, OPEN_FLOOR_RATE — interest-rate caps and floors, open versus term values.
• FIRST_RATE_CHANGE_DATE, NEXT_RATE_CHANGE_DATE, RATE_CHANGE_FREQUENCY — rate-reset schedule.
• LOAN_PAYMENT_FREQUENCY, FIRST_PAYMENT_DATE, NEXT_PAYMENT_DUE_DATE, AMORTIZATION_FREQUENCY — payment and amortization timing.
• PAYMENT_CALC_METHOD, ORIG_PAY_CALC_METHOD, CUSTOM_CALC_METHOD — how scheduled payment amounts are derived.
• PREPAY_PENALTY_FLAG, PREPAY_PENALTY_DATE, PENAL_INT_RATE, PENAL_INT_GRACE_DAYS — prepayment and penalty interest treatment.
• DELINQUENCY_THRESHOLD_NUMBER, DELINQUENCY_THRESHOLD_AMOUNT, DEFAULT_THRESHOLD_AMOUNT — delinquency and default triggers.
• REAMORTIZE_OVER_PAYMENT, REAMORTIZE_UNDER_PAYMENT, REAMORTIZE_WITH_INTEREST, REAMORTIZE_ON_FUNDING — re-amortization behavior flags.
• Standard WHO columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and the optimistic-locking column OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

The table is queried whenever loan terms must be displayed or audited — in loan servicing screens, rate-reset reporting, amortization-schedule re-derivation, and prepayment/prepayment-penalty analysis. A typical join resolves the loan number from the parent header:

• Retrieve all terms for a loan: SELECT t.* FROM LNS.LNS_TERMS t WHERE t.LOAN_ID = :loan_id;
• Join to the loan header: SELECT h.LOAN_NUMBER, t.RATE_TYPE, t.CEILING_RATE, t.FLOOR_RATE, t.NEXT_RATE_CHANGE_DATE FROM LNS.LNS_TERMS t JOIN LNS.LNS_LOAN_HEADERS_ALL h ON h.LOAN_ID = t.LOAN_ID;
• Report loans with upcoming rate changes: filter on NEXT_RATE_CHANGE_DATE within a date range.
• Identify floating-rate loans by joining to the index definition through INDEX_RATE_ID.

Reporting use cases include term-schedule variance analysis, compliance review of rate caps and floors, and reconciliation of payment-calculation methods against actual payment records.

Related Objects

• LNS.LNS_LOAN_HEADERS_ALL — the parent loan header; joined on LNS_TERMS.LOAN_ID = LNS_LOAN_HEADERS_ALL.LOAN_ID.
• Financial/interest index definitions referenced by INDEX_RATE_ID and INDEX_NAME.
• Loan payment and schedule tables in the LNS schema that derive from PAYMENT_CALC_METHOD and LOAN_PAYMENT_FREQUENCY.
• Rate-history and rate-reset tables driven by FIRST_RATE_CHANGE_DATE and RATE_CHANGE_FREQUENCY.
• LNS loan transaction and funding tables that consume REAMORTIZE_ON_FUNDING and related flags.

Because LNS_TERMS is the principal terms object for a loan, it is the primary source for any process requiring the loan's contractual pricing and payment behavior.