Search Results arp_acct_main




Overview
Explore in AI Chat

Overview

ARP_ADJUSTMENTS_MAIN is an internal PL/SQL package in the Oracle E-Business Suite Receivables (AR) module, owned by the APPS schema and classified as an "OTHER" API rather than a formally published public interface. Its business purpose is to process and account for manual adjustments applied to receivables transactions and payment schedules — for example, write-offs, credit adjustments, and other receivable-level corrections that change the amount due on a transaction.

The package is tightly coupled with ARP_ACCT_MAIN, the central accounting engine in Receivables that creates distribution records. The ETRM dependency metadata confirms a bidirectional reference: ARP_ADJUSTMENTS_MAIN references ARP_ACCT_MAIN, and ARP_ADJUSTMENTS_MAIN is itself referenced by ARP_ACCT_MAIN. This mutual relationship indicates that adjustment processing both drives accounting entries and is invoked by the accounting engine when adjustments must be reflected in the distribution set. The package is also documented as being referenced by one other package and as referencing the SYS.STANDARD package.

Key Procedures and Functions

The 12.2.2 metadata documents two procedures/functions within the package:

  • EXECUTE — The main entry point for processing an adjustment. It orchestrates the validation of the adjustment, applies the change against the payment schedule, and drives the accounting impact through the ARP_ACCT_MAIN accounting engine. It is the routine most likely invoked when an adjustment must be persisted and accounted.
  • DELETE_ACCT — Handles the removal or reversal of accounting distributions associated with an adjustment. It is used when an adjustment is deleted or unaccounted, ensuring that the corresponding AR_DISTRIBUTIONS records and related accounting residue are cleaned up consistently.

No parameter lists are documented in the metadata, and none should be assumed; the procedures are typically called from within the Receivables adjustment processing and accounting flows rather than directly by end users.

Tables Accessed

The package reads and writes a broad set of Receivables base tables via APPS synonyms, consistent with its adjustment and accounting role:

Usage Notes

ARP_ADJUSTMENTS_MAIN is not a supported public API. It is invoked internally by standard Receivables functionality — adjustment entry and approval flows, the AutoAdjustment and adjustment accounting processes, and the post-adjustment accounting engine (ARP_ACCT_MAIN). In EBS 12.1.1 and 12.2.2 the underlying logic is materially the same, though 12.2 introduces the Online Patching (ADOP) editioning model, so the package body exists in multiple editions.

Because it is classified as OTHER and forms part of Oracle's internal adjustment-to-accounting chain, custom code should not call EXECUTE or DELETE_ACCT directly; the supported path is through the Receivables forms, concurrent programs, or the documented adjustment APIs. Its principal reference is ARP_ACCT_MAIN, which shares the accounting distribution logic, and it is listed as a dependency for one further package in the APPS schema.