Search Results check_recp_balance

Overview

ARP_BALANCE_CHECK is a valid PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) product family and is classified under the ETRM API taxonomy as an "OTHER" object, meaning it is an internal utility package rather than a formally published public API. Its business purpose is to validate and, where necessary, correct the accounting balance of transactions, receipts, adjustments, and applications within the Receivables subledger.

The package acts as a consistency-checking layer that surrounds core Receivables processing. Whenever a transaction, receipt, or adjustment is created, applied, or posted, the balance of the associated payment schedule must agree with the underlying distribution and application records. ARP_BALANCE_CHECK provides the routines that perform these verifications and repair routines, helping to prevent or resolve data inconsistencies that would otherwise cause posting failures, out-of-balance conditions, or reconciliation discrepancies between Receivables and the General Ledger.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions within this package. No parameter signatures are published; the descriptions below reflect their documented names and functional intent.

• CHECK_TRANSACTION_BALANCE — Validates that a transaction's payment schedule balance agrees with its distributions and line amounts.
• CHECK_RECP_BALANCE — Checks the balance integrity of a single receipt, including unapplied, applied, and on-account amounts.
• CHECK_RECP_BALANCE_BULK — Performs the same receipt balance validation in bulk, processing multiple receipts in a single invocation for performance efficiency.
• CHECK_ADJ_BALANCE — Verifies the balance impact of adjustments recorded against transactions or payment schedules.
• CHECK_APPLN_BALANCE — Validates receivable application records to confirm that applied amounts reconcile with the related transaction and receipt balances.
• CHECK_PS_DATE — Examines payment schedule dates for validity, supporting GL date and due date consistency.
• FIX_PS_DATE — Corrects payment schedule dates identified as inconsistent by CHECK_PS_DATE.
• CHECK_PRECISION — Performs numeric precision validation to detect rounding or currency precision discrepancies in balance calculations.
• CHECK_LL_TRANSACTION_BALANCE — Validates transaction balances for low-level or line-level transaction structures.

Tables Accessed

The package accesses a broad set of Receivables base tables through APPS synonyms. AR_PAYMENT_SCHEDULES stores the transaction balance, due date, and amount-due records that are the primary subject of balance validation. AR_ADJUSTMENTS holds adjustment records checked by CHECK_ADJ_BALANCE. AR_CASH_RECEIPTS and AR_CASH_RECEIPT_HISTORY provide receipt header and status history data used in receipt balance checking. AR_RECEIVABLE_APPLICATIONS stores the application records validated by CHECK_APPLN_BALANCE. AR_DISTRIBUTIONS and AR_MISC_CASH_DISTRIBUTIONS supply the accounting distribution lines that must agree with schedule balances. AR_SYSTEM_PARAMETERS provides Receivables system options, including precision settings used by CHECK_PRECISION. RA_BATCH_SOURCES identifies the batch source attributes relevant to transactions. RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES, and RA_CUST_TRX_LINE_GL_DIST supply transaction header, line, and line-level GL distribution data used by the transaction and line-level balance checks.

Usage Notes

ARP_BALANCE_CHECK is not a standalone user-facing feature. It is invoked internally by higher-level Receivables processing packages. The ETRM dependency data confirms that it is referenced by eleven other packages, including ARP_MAINTAIN_PS and ARP_MAINTAIN_PS2 (payment schedule maintenance), ARP_PROCESS_APPLICATION (application processing), ARP_PROCESS_HEADER_POST_COMMIT, ARP_PROCESS_MISC_RECEIPTS, and ARP_PROC_RECEIPTS2 (receipt processing), AR_ADJUST_PUB (adjustments), AR_INVOICE_TABLE_HANDLER (invoice maintenance), and AR_RECEIPT_API_PUB (the published Receipt API). Consequently, the package executes implicitly during standard Receivables operations such as receipt entry and application, transaction entry, adjustment creation, and posting.

Because the package is not classified as a public API, custom code should not call its procedures directly. Developers diagnosing balance or out-of-balance issues in Receivables should treat ARP_BALANCE_CHECK as the internal validation engine behind those symptoms and should rely on supported APIs and concurrent programs rather than invoking these routines explicitly. It depends only on SYS.STANDARD, indicating a self-contained implementation with no reliance on other PL/SQL APIs.