Search Results arp_br_alloc_wrapper_pkg




Overview
Explore in AI Chat

Overview

ARP_BR_ALLOC_WRAPPER_PKG is an Oracle Receivables (AR) PL/SQL package owned by the APPS schema. It functions as a wrapper and allocation utility supporting the Bills Receivable (BR) feature set in Oracle E-Business Suite, specifically in the areas of tax allocation and accounting distribution for BR-related transactions. The package is classified in the ETRM as an "OTHER" API type, indicating that it is an internal, non-public integration interface rather than a documented open API intended for customer extension.

Its role centers on coordinating allocation logic that spans tax calculations, receivable applications, and adjustment processing. Because Receivables transactions can carry nested line, tax, and freight components, and because Bills Receivable introduces remittance and maturity flows that must reconcile back to the original transaction, a dedicated wrapper is used to centralize this logic and shield callers from the underlying account and application mechanics. In both Oracle EBS 12.1.1 and 12.2.2, the object is documented as VALID, confirming that it is a supported, compiled component of the standard AR code line.

Key Procedures and Functions

The ETRM metadata documents exactly one program unit within this package:

  • ALLOCATE_TAX_BR_MAIN — The primary documented procedure. Its name indicates it performs the main allocation of tax amounts in a Bills Receivable context. It is the single entry point through which the package's wrapper logic is exposed to other AR modules. No parameter list is documented in the available metadata, so its exact signature cannot be stated here.

Although only one procedure is formally listed, the package body is referenced by several other AR packages, and the package itself is self-referencing within ETRM, which is typical of a wrapper that recurses or delegates to sibling internal routines. No additional public procedures or functions are documented.

Tables Accessed

The following tables are documented as accessed by the package, directly or via APPS synonyms:

  • AR_ADJUSTMENTS — Stores adjustments applied to receivables, such as write-offs, credit memos, and tax-only adjustments. Access is consistent with the allocation of tax corrections against a BR transaction.
  • AR_RECEIVABLE_APPLICATIONS — Records the application of receipts and credits to transactions. The wrapper references it to determine existing application relationships before distributing tax amounts.
  • RA_CUSTOMER_TRX — The header table for all AR transactions. It provides transaction-level context, currency, and status used to drive allocation.
  • RA_CUSTOMER_TRX_LINES — The transaction line table, containing the line-level detail to which tax must be allocated.
  • PLITBLM — The standard Oracle Applications PL/SQL indexed table (a PL/SQL table-of-rows type) used in-memory rather than as a database table; it appears here because the package manipulates collections during processing.

The package additionally calls ARP_ACCT_MAIN, which is the core accounting engine in Receivables, indicating that validated allocation results are ultimately passed to the subledger accounting routines.

Usage Notes

ARP_BR_ALLOC_WRAPPER_PKG is an internal component. According to the ETRM dependency data, it is referenced by three other packages:

These callers indicate that the wrapper is invoked during adjustment posting, Bills Receivable lifecycle processing, and receipt application — the three flows where transaction-level tax must be reallocated against a BR document. It is not exposed through a standard Receivables form or a standalone concurrent program; instead, it is reached indirectly when users perform actions such as applying a receipt, creating an adjustment, or processing a bills receivable remittance.

Because this is a non-public "OTHER" API, custom code should not call it directly. Any extension or diagnostic access should be treated as unsupported, and behavior may change between 12.1.1 and 12.2.2 as the surrounding AR modules evolve. Developers investigating allocation or tax discrepancies in BR transactions should trace upward through ARP_BILLS_RECEIVABLE_MAIN rather than invoking this wrapper in isolation.