Search Results memo_fee_billing_option

Overview

The LNS.LNS_FEE_ASSIGNMENTS table is a core transactional object within the Oracle E-Business Suite (EBS) Lease and Loan Management (LNS) module, available in releases 12.1.1 and 12.2.2. It stores the assignment of fees to existing loans, functioning as the bridge between a loan record and a fee definition. Where LNS_FEES defines the default properties of a fee product, LNS_FEE_ASSIGNMENTS records the loan-specific instance of that fee and, critically, the user's ability to override default attributes. The overridable properties include Fee Type, Fee, Fee Basis, Number of Grace Days, Collected for Third Party Flag, Billing Option, and Rate Type.

The table is registered in FND Design Data as LNS.LNS_FEE_ASSIGNMENTS and resides in the APPS_TS_TX_DATA tablespace with PCT Free of 10. Its primary key is LNS_FEE_ASSIGNMENTS_PK on FEE_ASSIGNMENT_ID. From a Data Vault modeling perspective, the mined relationship classification is satellite-leaning: the table is keyed by its own surrogate identifier, carries descriptive and override attributes, and includes a foreign key reference to the parent loan. This suggests a design where fee assignment attributes are versioned context around a central loan hub rather than independent hubs or links.

Key Information Stored

The table contains 26 documented columns. The most significant are:

• FEE_ASSIGNMENT_ID — surrogate primary key (unique index LNS_FEE_ASSIGNMENTS_U1); no other business-key candidate is documented as unique.
• LOAN_ID — foreign key to the loan; indexed non-uniquely via LNS_FEE_ASSIGNMENTS_N1.
• FEE_ID — reference to the fee definition; indexed non-uniquely via LNS_FEE_ASSIGNMENTS_N2.
• FEE_TYPE and FEE — the fee classification (lookup type FEE_TYPE) and the amount or rate percentage, interpreted according to RATE_TYPE.
• FEE_BASIS — the basis on which the fee is computed (lookup type FEE_BASIS).
• BILLING_OPTION — the billing behavior, drawing on lookup types ORIGINATION_FEE_BILLING_OPTION, SERVICING_FEE_BILLING_OPTION, and MEMO_FEE_BILLING_OPTION. This is the column most relevant to the search term memo_fee_billing_option.
• NUMBER_OF_PAYMENTS — required for Memo Fees whose Billing Option is "Due Before First Loan Payment".
• BEGIN_INSTALLMENT_NUMBER and END_INSTALLMENT_NUMBER — mandatory when the Billing Option is "Amortize".
• NUMBER_GRACE_DAYS, COLLECTED_THIRD_PARTY_FLAG, and RATE_TYPE — additional overridable properties.
• DISB_HEADER_ID — indexed non-uniquely via LNS_FEE_ASSIGNMENTS_N3, associating the fee with disbursement activity.
• Standard Who columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) plus OBJECT_VERSION_NUMBER.
• Lifecycle and control columns: START_DATE_ACTIVE, END_DATE_ACTIVE, OPEN_PHASE_FLAG, DELETE_DISABLED_FLAG, PHASE, and CUSTOM_PROCEDURE.

Common Use Cases and Queries

Typical uses include reconstructing the fee schedule for a loan, auditing overridden fee properties, and reporting on memo-fee billing configurations. A common query filters on the billing option to locate memo fees:

SELECT fa.fee_assignment_id, fa.loan_id, fa.fee_id,
       fa.fee_type, fa.fee, fa.billing_option,
       fa.number_of_payments
  FROM lns_fee_assignments fa
 WHERE fa.billing_option = 'MEMO_FEE_BILLING_OPTION';

Because the lookup type is MEMO_FEE_BILLING_OPTION, applications frequently resolve the stored code through FND_LOOKUPS. Joining to the loan and fee parent tables supports attribution reporting, while the START_DATE_ACTIVE and END_DATE_ACTIVE range enables point-in-time analysis of active fee assignments. The PHASE and OPEN_PHASE_FLAG columns support open-item and phase-based processing reports.

Related Objects

• LNS.LNS_LOANS — parent loan record, joined on LOAN_ID.
• LNS.LNS_FEES — the fee definition supplying default properties, joined on FEE_ID.
• LNS.LNS_DISBURSEMENTS (disbursement header) — joined via DISB_HEADER_ID (index LNS_FEE_ASSIGNMENTS_N3).
• FND_LOOKUPS — resolves BILLING_OPTION, FEE_TYPE, and FEE_BASIS codes.
• LNS Fee Assignment public APIs — the supported interfaces for inserting and maintaining rows, which enforce the mandatory-column rules for the Amortize and Memo Due Before First Payment options.