Results for “arp_adjustments_main”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ARP_ADJUSTMENTS_MAIN is a core PL/SQL package body in the Oracle Receivables (AR) module of Oracle E-Business Suite, owned by the APPS schema and marked VALID in both 12.1.1 and 12.2.2 environments. Its principal business function is to process receivable adjustments — the credits, write-offs, and debit memos that reduce or otherwise alter an existing customer balance. Adjustments must be reflected simultaneously across multiple accounting, tax, and revenue sub-ledgers, and this package coordinates that work by orchestrating lower-level APIs such as ARP_ACCT_MAIN, ARP_DET_DIST_PKG, ARP_ADJUSTMENTS_MAIN's own internal routines, ARP_STANDARD, and the accounting hook ARP_ACCT_HOOK. It also integrates with eTax (ARP_ETAX_UTIL, ZX_API_PUB, ZX_SCO_RATES) and legal-entity logic (ARP_LEGAL_ENTITY_UTIL), and it invokes ARP_RECONCILE and ARP_ALLOCATION_PKG / ARP_BR_ALLOC_WRAPPER_PKG for reconciliation and revenue allocation. Because the ETRM metadata classifies this package as API classification OTHER, it is treated as an internal implementation package rather than a formally published public API.

Key Procedures and Functions

ETRM documents two program units in this package body:

  • EXECUTE — The primary driver routine that performs the actual adjustment posting. It receives the adjustment context (adjustment record, customer transaction, transaction line, and related identifiers) and coordinates validation, tax determination, distribution generation, and accounting entry creation. It is the entry point called by other Receivables processes when an adjustment must be applied.
  • DELETE_ACCT — Removes or reverses the accounting entries associated with an adjustment. This supports adjustment deletion, reversal, or rebooking scenarios, ensuring that general ledger distributions and receivable application records remain consistent when an adjustment is undone.

No parameter lists are documented in the ETRM extract; the signatures should be treated as internal and subject to change between patch levels.

Tables Accessed

The package operates across the full adjustment data model:

Usage Notes

The package is invoked indirectly by Receivables forms (notably the Adjustments window), by concurrent programs that process adjustments in batch, and by custom code that calls ARP_ADJUSTMENTS_MAIN from within the APPS schema. It is referenced by one other package and is not referenced by any database object, confirming its role as a downstream, internal component. Because it is not a published API and depends on many sibling packages and eTax/ZX components, direct calls from custom code should be avoided; integration should target the supported public AR APIs (AR_ADJUSTMENT_API and related) instead. The presence of AR_REC_TRX_LE_DETAILS in its dependency list means adjustment behavior can vary by legal entity, so testing must cover multi-org and multi-legal-entity setups.