Search Results reverse_offcycle_bill

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:

• BILL_LOANS — the master batch routine that drives billing for a set of loans or leases.
• PREBILL_SINGLE_LOAN — pre-processes a single loan prior to billing.
• CREATE_SINGLE_OFFCYCLE_BILL and CREATE_OFFCYCLE_BILLS — create off-cycle (non-scheduled) billing transactions.
• REVERSE_OFFCYCLE_BILL — reverses a previously generated off-cycle bill.
• ADJUST_ORIGINAL_RECEIVABLE, CREATE_AR_ADJ, and LNS_ADJUST_RECEIV_CONCUR — create and manage adjustments against original receivables in Oracle Receivables.
• REVERSE_LAST_AMORTIZATION and CREDIT_AMORTIZATION_PARTIAL — support amortization reversal and partial credit processing.
• LNS_RVRS_PMT_CONCUR — supports concurrent reversal of payments.
• PROCESS_PAID_LOANS — identifies and processes fully paid loans.
• GET_NEXT_INSTAL_TO_BILL, BILL_AND_PAY_NEXT_INSTAL, PAY_INSTALLMENTS, and CAN_BILL_NEXT_INSTAL — manage installment-level billing and payment sequencing.
• CALC_PAST_DUE_LOANS_NEXT_DD — recalculates past-due status at the next due date.
• GENERATE_BILLING_STATEMENT_XML — produces the customer billing statement in XML format.
• GET_FORGIVENESS_AMOUNT — calculates forgiveness amounts applied to billed balances.
• LNS_BILLING_CONCUR — the concurrent-program entry point for the billing process.

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.