Search Results allocate_tax

Overview

ARP_ALLOCATION_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Receivables. Its documented purpose is to support the allocation of tax amounts and accounting charge combinations across Receivables transactions, adjustments, and receipt-related distributions. The package operates at the intersection of Receivables subledger data (transactions, distribution lines, receivable applications, and adjustments) and the General Ledger chart of accounts, drawing on AR_VAT_TAX and GL_SETS_OF_BOOKS to resolve tax and ledger context. Classification as an "OTHER" API rather than a public open interface indicates it is primarily an internal engine: it is invoked by other Receivables and Bills Receivable packages rather than being exposed directly to customers. Its presence in the ETRM dependency map confirms that it is a valid, active component in both 12.1.1 and 12.2.2, with the same APPS owner and the same set of dependencies. In business terms, the package underpins correct tax distribution and account assignment when Receivables generates accounting for transactions, adjustments, and receipts, ensuring that allocated amounts reconcile with source transaction lines and distributions.

Key Procedures and Functions

ETRM documents five procedures or functions within the package. Parameter lists are not exposed in the metadata and are therefore not reproduced here.

• ALLOCATE_TAX — The principal routine, responsible for allocating tax amounts against the relevant transaction, adjustment, or distribution records.
• RETAIN_NEG_IND — Handles negative amount indicators, preserving or propagating the sign convention used when allocating amounts so that credit and debit treatment remains consistent.
• GET_TAX_COUNT — A retrieval routine that returns a count of tax records or tax distributions relevant to the current allocation context, typically used to drive branching logic.
• SET_ADJ_CCID — Assigns the accounting charge combination identifier (CCID) associated with adjustments processed during allocation.
• SUBSTITUTE_CCID — Substitutes or derives a charge combination identifier, used when a distribution must be redirected to an alternative account.

Tables Accessed

The package reads and writes against a focused set of Receivables and General Ledger objects, accessed through APPS synonyms.

• AR_ADJUSTMENTS — Adjustment records whose tax and accounting allocations are being processed.
• AR_DISTRIBUTIONS, AR_DISTRIBUTIONS_S, AR_DISTRIBUTION_SPLIT_S — Distribution and split-distribution tables that hold the accounting lines produced or amended by allocation.
• AR_RECEIVABLE_APPLICATIONS — Receipt-to-transaction applications that determine how cash allocations interact with tax allocations.
• AR_SYSTEM_PARAMETERS, AR_SYSTEM_PARAMETERS_ALL — Receivables system options, supplying ledger and accounting configuration context.
• AR_VAT_TAX — Tax code and rate definitions used in tax allocation.
• RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, RA_CUST_TRX_LINE_GL_DIST — Transaction headers, lines, and their GL distributions, which form the source data for allocation.
• GL_SETS_OF_BOOKS — Ledger definition, supplying functional currency and accounting context.
• Temporary/global tables AR_AE_ALLOC_REC_GT, AR_BASE_DIST_AMTS_GT, AR_LINE_APP_DETAIL_GT — Working storage used during allocation processing.

Usage Notes

ARP_ALLOCATION_PKG is an internal utility and is not documented as a public API. It is referenced by six other APPS packages: ARP_ADJUSTMENTS_MAIN, ARP_BILLS_RECEIVABLE_MAIN, ARP_BR_ALLOC_WRAPPER_PKG, ARP_RECEIPTS_MAIN, ARP_RECONCILE, and itself (recursive internal calls). Consequently, it is invoked indirectly whenever Receivables processes adjustments, bills receivable allocations, receipts, or reconciliation that require tax and account allocation. It is also dependent on ARP_ACCT_MAIN for accounting generation. Custom code should not call this package directly; instead, use supported Receivables APIs or standard concurrent programs, and treat the package as subject to change between patch levels.