Search Results lns_fee_engine




Overview
Explore in AI Chat

Overview

The APPS.LNS_FEE_ENGINE package is the core PL/SQL engine within the Oracle E-Business Suite (EBS) Lease and Loan Management (LNS) module responsible for the calculation, scheduling, processing, and maintenance of fees associated with lease and loan contracts. It operates in both EBS 12.1.1 and 12.2.2 and resides in the APPS schema with a status of VALID. The package encapsulates the business logic that determines how fees are assessed, amortized, disbursed, waived, and accrued as late charges across the lifecycle of a financial instrument. Because fee handling is intertwined with disbursement, funding, approval, and billing activities, LNS_FEE_ENGINE serves as a shared service layer invoked by multiple public APIs and concurrent programs rather than being driven by a single user interface.

Key Procedures and Functions

The package exposes nineteen documented procedures and functions, classified under the API type "OTHER." Their purposes are as follows:

  • PROCESSDISBURSEMENTFEES — applies fee logic at the point of loan or lease disbursement.
  • REPROCESSFEES — re-runs fee calculations, typically after a correction or a change to fee setup.
  • GETFEESTRUCTURES / GETDISBURSEMENTFEESTRUCTURES — retrieve the applicable fee structures used as the basis for computation.
  • CALCULATEFEE / CALCULATEFEES — perform single-fee and multi-fee computation respectively.
  • WRITEFEESCHEDULE / UPDATEFEESCHEDULE / GETFEESCHEDULE — create, modify, and retrieve fee schedules that govern timing and amounts.
  • GETFEEDETAILS — returns detailed fee information for a given context.
  • PROCESSFEES / PROCESSLATEFEES — drive standard fee processing and the assessment of late fees.
  • UPDATEFEE / WAIVEFEE — modify an existing fee record or apply a waiver.
  • GETFEESTOTAL — aggregates fee amounts.
  • LOAN_LATE_FEES_CONCUR — the concurrent-program entry point for late-fee batch processing.
  • GETSUBMITFORAPPRFEESCHEDULE — returns fee schedule data submitted for approval.
  • SET_DISB_FEES_INSTALL — establishes disbursement-related fee installments.

Tables Accessed

LNS_FEE_ENGINE reads and writes the following tables via APPS synonyms: LNS_FEES and LNS_FEES_ALL (the primary fee transaction store), LNS_FEE_ASSIGNMENTS (linking fees to contracts), LNS_FEE_SCHEDULES and LNS_FEE_SCHEDULE_S (schedule definitions and their translation records), LNS_LOAN_HEADERS and LNS_LOAN_HEADERS_ALL (contract context), LNS_DISB_HEADERS and LNS_DISB_LINES (disbursement linkage), and the amortization tables LNS_AMORTIZATION_SCHEDS and LNS_AMORTIZATION_LINES, reflecting the deferred-fee amortization process. FND_CURRENCIES supplies currency precision and rounding, DUAL supports scalar evaluation, and PLITBLM is the standard PL/SQL index-by table type used internally for bulk collections.

Usage Notes

The package is not typically called directly by end users. It is invoked by seven dependent packages, including LNS_FEE_ASSIGNMENT_PUB, LNS_APPROVAL_ACTION_PUB, LNS_BILLING_BATCH_PUB, LNS_CUSTOM_PUB, LNS_FUNDING_PUB, and LNS_FINANCIALS, and it references itself recursively through LNS_FEE_ENGINE_W and its own definition. Batch late-fee assessment is exposed through the LOAN_LATE_FEES_CONCUR concurrent program entry point. Customizations should call the public wrapper procedures rather than the internal calculation primitives where possible, and any extension of fee logic must preserve the package's contract with these dependent APIs across both 12.1.1 and 12.2.2 environments.