Results for “arp_balance_check”

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

Overview

ARP_BALANCE_CHECK is an Oracle Receivables (AR) diagnostic and validation package that verifies the accounting integrity of receivables transactions before they are posted to the General Ledger. Its central purpose is to confirm that the sum of debits equals the sum of credits across the distribution lines of customer transactions, receipts, adjustments, and applications. When an imbalance is detected, the package raises an error onto the message stack so that the offending entity can be corrected rather than posted.

In Oracle EBS 12.1.1 and 12.2.2 the package executes under the APPS schema and is classified as an OTHER API, meaning it is invoked internally by application logic rather than being a formally published open interface. Two profile options govern runtime behavior: AFLOG_ENABLED controls debug tracing, and AR_ENABLE_JOURNAL_BAL_CHECK (captured in the package-level variable PG_BAL_CHECK_ENABLED, defaulting to 'Y') enables or disables the journal balance check. The header indicates the package has been under sustained maintenance, with the latest revision dated 2012/10/31.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions within the package body:

• CHECK_TRANSACTION_BALANCE — Totals debits and credits for a customer transaction and confirms they balance, raising a message on the stack when they do not.
• CHECK_RECP_BALANCE — Validates that a single cash receipt and its distributions are in balance.
• CHECK_RECP_BALANCE_BULK — Performs the same receipt balance validation for multiple receipts in a single invocation, improving performance over row-by-row checking.
• CHECK_ADJ_BALANCE — Verifies that an adjustment and its related accounting distributions balance.
• CHECK_APPLN_BALANCE — Checks that a receivable application between a transaction and a receipt is in balance.
• CHECK_PS_DATE — Validates payment schedule dates for consistency with accounting rules.
• FIX_PS_DATE — Corrects invalid payment schedule dates identified by CHECK_PS_DATE.
• CHECK_PRECISION — Examines monetary amounts for rounding or precision discrepancies that could cause imbalance between entered and accounted values.
• CHECK_LL_TRANSACTION_BALANCE — Performs transaction balance validation for Lease Line (LL) related transactions, gated by PG_LL_BAL_CHECK_ENABLED.

CHECK_TRANSACTION_BALANCE illustrates the internal logic: it aggregates RA_CUST_TRX_LINE_GL_DIST amounts, inverting account_class 'REC' rows with a -1 multiplier so receivables lines are treated as credits, and groups by GL date. It only considers rows where account_set_flag = 'N' and posting_control_id = -3, and it excludes transactions having lines whose autorule_complete_flag is not 'Y'.

Tables Accessed

The package reads and, through its FIX procedures, may write several Receivables tables, all referenced through APPS synonyms:

• RA_CUST_TRX_LINE_GL_DIST — the primary distribution table whose summed amounts drive transaction balance checks.
• RA_CUSTOMER_TRX_LINES and RA_CUSTOMER_TRX — source transaction header and line data.
• AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, and AR_DISTRIBUTIONS — receipt and distribution detail used by receipt balance checks.
• AR_MISC_CASH_DISTRIBUTIONS — miscellaneous receipt accounting entries.
• AR_RECEIVABLE_APPLICATIONS — application records between transactions and receipts.
• AR_ADJUSTMENTS, AR_PAYMENT_SCHEDULES — adjustment and schedule detail, supporting CHECK_ADJ_BALANCE and the payment schedule date procedures.
• AR_SYSTEM_PARAMETERS, RA_BATCH_SOURCES — configuration and control context.

Usage Notes

ARP_BALANCE_CHECK is not intended for direct end-user invocation. It is called from Receivables forms and concurrent programs at critical moments—most notably during transaction and receipt posting—where a balance failure must halt processing and surface a message. Because the package is referenced by eleven other packages, its procedures are frequently reused by internal AR APIs, including AutoInvoice-related and AutoLockbox-related processing, to pre-validate data.

Customizations that call this package should treat it as an internal API: parameter lists are subject to change, and behavior depends on profile option settings such as AR_ENABLE_JOURNAL_BAL_CHECK. Raising these profile options off disables the check entirely, which is occasionally done during data repair or migration, but re-enabling them is strongly advised before regular posting resumes so that out-of-balance journals are caught before reaching the General Ledger.