Search Results ari_service_charge_pkg




Overview
Explore in AI Chat

Overview

ARI_SERVICE_CHARGE_PKG is an Oracle Receivables (AR) package body owned by the APPS schema. Its business purpose is to compute, apply, and adjust service charges (late payment interest) on overdue customer invoices and debit memos. Service charges in Oracle EBS are calculated for past-due balances using the interest rate, grace period, and charge schedule defined in Receivables setup. This package encapsulates the PL/SQL logic that identifies delinquent transactions, evaluates them against the applicable rate basis (for example, interest rate, flat amount, or a tiered schedule), and creates the corresponding adjustment entries that increase the customer balance.

The user search term ar_irec_payment_list_gt corresponds to the global temporary table AR_IREC_PAYMENT_LIST_GT, which the package references. This table is populated with the payment and receipt list context used during iReceivables (Internet Receivables) service-charge processing, allowing the package to determine which delinquent items are subject to charge assessment within the online self-service flow.

Key Procedures and Functions

The documented public interface consists of three procedures:

  • COMPUTE_SERVICE_CHARGE — The core calculation routine. It evaluates the overdue balance and the applicable service-charge parameters to derive the charge amount for a given customer or transaction set. No parameter list is documented.
  • APPLY_CHARGE — Persists the computed service charge by creating the appropriate adjustment against the invoice or balance-forward debit item, and records the accounting impact through the Receivables adjustment infrastructure. No parameter list is documented.
  • ADJUST_INVOICE — Handles the adjustment side of the process, updating the transaction so that the assessed service charge is reflected in the customer's open balance. No parameter list is documented.

The three procedures operate as a pipeline: compute, apply, and adjust. Together they implement the end-to-end service-charge assessment used by Receivables delinquency and late-payment processing.

Tables Accessed

The documented table references, resolved through APPS synonyms, are:

  • AR_ADJUSTMENTS — The base adjustment table where service-charge adjustments are stored. The package inserts or reads adjustment records here to reflect charges against invoices.
  • AR_IREC_PAYMENT_LIST_GT — A global temporary table holding the payment and receipt list generated during the iReceivables payment flow. The package consults this list to determine the delinquency context before computing and applying service charges.
  • PLITBLM — The standard Oracle PL/SQL-supplied table of line/byte information, used internally by DBMS_OUTPUT and other built-in routines for message formatting and output operations.

Additional dependencies include AR_UTILITIES, ARP_STANDARD, AR_ADJUST_PUB, AR_LOOKUPS, FND_API, FND_MESSAGE, FND_MSG_PUB, and FND_PROFILE, indicating use of the standard Receivables and Application Object Library error-handling, messaging, and profile-option frameworks.

Usage Notes

ARI_SERVICE_CHARGE_PKG is typically invoked from Receivables service-charge concurrent programs and from the iReceivables self-service application when a customer views or pays delinquent items online. Because it uses FND_API and FND_MSG_PUB, callers should expect standard EBS API conventions: initialization of the message stack before invocation, checking FND_API.G_RET_STS_SUCCESS on completion, and retrieval of messages when errors are returned. Custom code extending service-charge behavior should call the documented procedures rather than manipulate AR_ADJUSTMENTS directly, so that adjustments are created consistently with the Receivables adjustment API layer. The package is not referenced by any other database object, meaning it is a top-level entry point rather than a utility invoked internally by other packages.