Results for “arp_acct_main”

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

Overview

ARP_ACCT_MAIN is the central accounting engine package body within the Oracle Receivables (AR) module of Oracle E-Business Suite. Its principal responsibility is the creation and deletion of accounting entries for Receivables documents. The package acts as the orchestration layer that invokes the document-specific main packages to generate accounting for receipts, credit memos, and adjustments. In EBS 12.1.1 and 12.2.2, this package forms part of the bridge between the Receivables subledger transactions and the Subledger Accounting (XLA) architecture, ensuring that each qualifying document produces the appropriate distribution lines.

The header comments reveal that the package was last modified under version 120.19.12010000.2. Historically, it also served as the integration point for Multi-Reporting Currency (MRC) trigger replacement logic, and the source explicitly notes that, as of June 2002, no modification was consciously made to the arp_acct_hook for that MRC trigger replacement. This indicates a deliberate design decision retained across releases.

Key Procedures and Functions

The ETRM metadata documents eight procedures and functions in this package, the two most prominent being:

• CREATE_ACCT_ENTRY — Creates accounting entries for a document. It operates in either Document mode or Accounting Event mode, accepts a document record and an event record, and includes a client-server indicator used to signal that the call originates from C code, in which case exceptions are raised rather than returned. Additional parameters support LLCA (Low-Level Cost Adjustment) call origins and a GT identifier. Internally, it dispatches to the appropriate document main packages for receipts, credit memos, and adjustments. Supporting internal routines include Insert_Ae_Lines, Init_Curr_Details, and Dump_Dist_Amts.
• DELETE_ACCT_ENTRY — Removes previously generated accounting entries, providing the inverse operation required when a document is reversed, corrected, or otherwise invalidated.

The package is referenced by 35 other packages, confirming its role as a shared, foundational accounting utility rather than a document-specific routine.

Tables Accessed

The package reads and writes a broad set of Receivables and Subledger Accounting tables through APPS synonyms:

• AR_DISTRIBUTIONS — the primary repository of Receivables distribution lines written by accounting entry creation.
• AR_SYSTEM_PARAMETERS — supplies the accounting method used to initialize currency and accounting details.
• AR_CASH_RECEIPTS, AR_RECEIVABLE_APPLICATIONS, AR_ADJUSTMENTS, AR_RECEIVABLES_TRX — source documents for which accounting is generated.
• RA_CUSTOMER_TRX, RA_CUST_TRX_LINE_GL_DIST — transaction and transaction-line distribution data.
• AR_CASH_BASIS_DISTS_ALL — cash basis distribution records.
• FND_CURRENCIES, ZX_RATES_B — currency and tax rate reference data.
• XLA_TRANSACTION_ENTITIES — links Receivables documents to Subledger Accounting entities.
• RA_INTERFACE_LINES_GT, RA_INTERFACE_ERRORS — staging and error capture for interface processing.
• DUAL — used for singleton queries within PL/SQL logic.

Usage Notes

ARP_ACCT_MAIN is not typically invoked directly by end users. It is called by the Receivables accounting concurrent programs, by document main packages during transaction processing, and by custom extensions that need to generate or remove Receivables accounting entries programmatically. Because it is referenced by 35 other packages, changes to its interface carry significant regression risk. The client-server parameter allows callers from C-based code to receive raised exceptions instead of returned status values. Customizations should treat this package as an internal API and prefer the documented Subledger Accounting entry points where possible.