Search Results lns_billing_batch_pub




Overview
Explore in AI Chat

Overview

APPS.LNS_BILLING_BATCH_PUB is a public PL/SQL package in the Oracle E-Business Suite Lease and Loan Management (LNS) module. It serves as the central billing batch engine responsible for generating, adjusting, and reversing billing transactions against loan and lease contracts. The package encapsulates the bulk and single-record billing routines that drive receivable creation in Oracle Receivables, amortization processing, past-due recalculation, off-cycle billing, payoff handling, and customer billing statement generation. Because it is classified as a PUB (public) API package, it is intended to be invoked both by other LNS packages and by customer-specific extensions and concurrent programs.

The package is registered in the APPS schema with the status VALID on both Oracle EBS 12.1.1 and 12.2.2. It is heavily integrated into the LNS architectural stack: it is referenced by LNS_APPROVAL_ACTION_PUB, LNS_FEE_ENGINE, LNS_PAYOFF_PUB, and its own wrapper packages LNS_BILLING_BATCH_PUB_W, and it depends only on the SYS STANDARD package at the database level. This dependency footprint confirms that its external integration is achieved through APPS synonyms rather than direct schema-level dependencies.

Key Procedures and Functions

The package exposes approximately twenty-seven documented procedures and functions covering the full billing lifecycle. The principal routines include:

Tables Accessed

The package reads and writes through APPS synonyms to core Oracle Receivables, LNS, and reference tables. AR_PAYMENT_SCHEDULES and AR_PAYMENT_SCHEDULES_ALL store installment and receivable schedule data. AR_ADJUSTMENTS and AR_TRX_ERRORS_GT support receivable adjustments and error surfacing. LNS_AMORTIZATION_SCHEDS, LNS_AMORTIZATION_SCHEDS_S, and LNS_AMORTIZATION_LINES hold amortization schedule and line detail. LNS_DISTRIBUTIONS records accounting distributions. HZ_PARTIES, HZ_CUST_SITE_USES, and HR_ALL_ORGANIZATION_UNITS_TL provide customer, site, and organization context. GL_CODE_COMBINATIONS, FND_FLEX_VALUE_SETS, FND_SEGMENT_ATTRIBUTE_TYPES, and FND_SEGMENT_ATTRIBUTE_VALUES supply accounting flexfield and segment validation data.

Usage Notes

LNS_BILLING_BATCH_PUB is invoked primarily from the LNS billing concurrent programs (via LNS_BILLING_CONCUR and its wrapper package LNS_BILLING_BATCH_PUB_W), from the LNS approval workflow through LNS_APPROVAL_ACTION_PUB, from LNS_PAYOFF_PUB during payoff processing, and from LNS_FEE_ENGINE when fees must be billed. Custom extensions should call the PUB routines rather than the underlying tables to preserve supported upgrade paths across 12.1.1 and 12.2.2.