Search Results lns_fee_schedules




Overview
Explore in AI Chat

Overview

LNS_FEE_SCHEDULES is the core transactional table within the Oracle Loans (LNS) module of Oracle E-Business Suite, storing the fee schedule records that are attached to loan contracts. In Oracle EBS 12.1.1 and 12.2.2, the LNS schema manages the full life cycle of loan origination, servicing, and accounting, and LNS_FEE_SCHEDULES occupies a central position in that model by defining the individual fees — origination fees, processing charges, insurance premiums, and similar items — that are levied against a specific loan and scheduled for billing or amortization. Each row in this table represents one fee instance associated with one loan, with attributes controlling whether the fee is active, whether it has been billed, whether it may be waived, and how much has actually been waived.

The ETRM metadata classifies this object heuristically as a standalone data vault entity. This suggests a modeling approach in which LNS_FEE_SCHEDULES is treated as an independent satellite-like structure keyed by its own surrogate identifier, without a strong hub-and-link dependency chain to other LNS entities at the physical constraint level. The table is owned by the LNS schema and is marked VALID in the data dictionary.

Key Information Stored

The documented physical schema for ETRM 12.2.2 contains 20 columns. The most significant include:

FEE_SCHEDULE_ID should be understood as the technical surrogate key, while the combination of LOAN_ID and FEE_ID represents the practical business-key context for identifying a specific fee on a specific loan.

Common Use Cases and Queries

Typical reporting scenarios include listing all active fees for a loan, identifying unbilled fees that must be picked up by the billing process, and calculating net fee revenue after waivers. A representative query might select FEE_SCHEDULE_ID, FEE_ID, FEE_AMOUNT, WAIVED_AMOUNT, and BILLED_FLAG from LNS_FEE_SCHEDULES where LOAN_ID equals a supplied value and ACTIVE_FLAG equals 'Y'. Users also frequently aggregate FEE_AMOUNT and WAIVED_AMOUNT by LOAN_ID to reconcile fees against the loan's servicing records. Because the table participates in amortization, queries that join to LNS_AMORTIZATION_LINES help explain how a fee is recognized over the loan term. Persistent reporting views layered on top of this table are common for fee revenue dashboards and audit extracts.

Related Objects

The documented foreign key relationship shows that LNS_AMORTIZATION_LINES.FEE_SCHEDULE_ID references LNS_FEE_SCHEDULES, meaning amortization lines are downstream children of each fee schedule row. Beyond this documented link, LNS_FEE_SCHEDULES is conceptually joined by LOAN_ID to the loan header entity (LNS_LOANS) and by DISB_HEADER_ID to the disbursement header entity (LNS_DISB_HEADERS), while FEE_ID relates to the fee definition/master table. The billing and waivers processes, along with the LNS fee setup and loan servicing concurrent programs and public APIs, read and update these rows. The most significant related objects are therefore LNS_AMORTIZATION_LINES, LNS_LOANS, LNS_DISB_HEADERS, and the fee definition and billing objects that consume FEE_ID and the flag columns.