Search Results ar_adjust_pub




Overview
Explore in AI Chat

Overview

AR_ADJUST_PUB is the public application programming interface (API) for creating, modifying, approving, and reversing adjustments against Oracle Receivables transactions. It belongs to the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2 and is classified as a public (PUB) API, meaning it is intended for external invocation by other application modules, concurrent programs, and custom extensions. The package exists to encapsulate the business rules and validation logic that Receivables applies whenever an adjustment affects a customer's open balance — whether that adjustment is a write-off, a bad-debt provision, a credit adjustment, a chargeback, or a line-level adjustment. By exposing these operations through a single, stable, server-side interface, AR_ADJUST_PUB allows other Oracle EBS products and customer-written code to post adjustments consistently without bypassing the validation and accounting logic embedded in Oracle Receivables. The package is validated and currently active in the ETRM registry, and it participates broadly in the Receivables ecosystem, being referenced by nine other packages spanning collections, chargebacks, leasing, and trade management functionality.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions in this package:

  • CREATE_ADJUSTMENT — Creates a new adjustment against a transaction, applying the standard validation rules for adjustment activity, reason codes, and accounting impact.
  • MODIFY_ADJUSTMENT — Modifies an existing adjustment record, subject to the same validations and to any restrictions on which fields may be changed after creation.
  • REVERSE_ADJUSTMENT — Reverses a previously created adjustment, restoring the customer's balance and generating the appropriate reversing accounting entries.
  • APPROVE_ADJUSTMENT — Approves an adjustment, a necessary step when an adjustment activity requires approval before it affects balances or accounting.
  • CREATE_LINELEVEL_ADJUSTMENT — Creates an adjustment at the transaction line level, supporting line-level credit adjustments (LLCA) rather than adjustments applied only to the transaction header.

These procedures follow the Oracle EBS API conventions: an API return status, a message code, and a message data output, with all business validation performed server-side. Parameter lists are not reproduced here because the documented metadata does not enumerate them.

Tables Accessed

The package reads and writes several Receivables base tables and supporting structures referenced through APPS synonyms:

  • AR_ADJUSTMENTS — the primary table holding adjustment records; created, modified, and reversed by the API.
  • AR_PAYMENT_SCHEDULES — stores the customer's payment schedule rows; adjustments update the amounts due and the associated adjustment counters.
  • AR_RECEIVABLE_APPLICATIONS — records the application of adjustments against receivable items.
  • AR_ACTIVITY_DETAILS — captures activity history for the transaction as a result of adjustment processing.
  • AR_LLCA_ADJ_TRX_ERRORS_GT and AR_LLCA_ADJ_TRX_LINES_GT — global temporary tables used during line-level credit adjustment processing to stage transaction lines and error information.
  • PLITBLM and V$TIMER — standard Oracle technical dependencies (PL/SQL table handling and timer utilities) rather than business tables.

The package also depends on the FND_API library for its message handling and return-status conventions, and on AR_ADJUSTMENTS as its anchor business entity.

Usage Notes

AR_ADJUST_PUB is intended for programmatic use rather than direct end-user invocation. In a standard Receivables implementation, adjustments are entered through the Receivables forms, and the form layer calls into this package (or a closely related private package) to persist and validate the transaction. Because it is a PUB API, it is also the supported entry point for external callers. Within Oracle EBS, the package is referenced by nine other packages, including ARI_SERVICE_CHARGE_PKG, ARP_BR_HOUSEKEEPER_PKG, ARP_PROCESS_CHARGEBACK, AR_BILLS_MAINTAIN_LIB_PVT, AR_LATE_CHARGE_PKG, JL_AR_RECEIVABLE_APPLICATIONS, LNS_BILLING_BATCH_PUB, OKL_CREATE_ADJST_PVT, and OZF_AR_PAYMENT_PVT — demonstrating its use across service charges, chargebacks, late charges, leasing, and trade management payment flows. Custom code should call this package instead of inserting directly into AR_ADJUSTMENTS, so that validation, approval routing, balance updates, and accounting entries remain consistent with Receivables business rules. As with all Oracle public APIs, callers should check the return status and message data and should not assume success without examining them.