Search Results ar_automatic_clearing_parallel




Overview
Explore in AI Chat

Overview

ARP_AUTOMATIC_CLEARING_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It encapsulates the business logic that drives Oracle Receivables Automatic Clearing, the process by which open and on-account cash receipts, credit memos, and other eligible transactions are matched and cleared automatically without manual intervention by the collections or cash applications staff. Automatic Clearing reduces the manual effort associated with reconciling receipts against open debit items and accelerates the period-close cycle by systematically applying the clearing rules defined in Receivables system options.

The package is classified in the ETRM repository as an "OTHER" API, indicating that it is a supporting internal package rather than a formally certified public API. Its documented status is VALID, confirming that the compiled specification and body exist in the APPS schema and expose callable units. The package body and specification are both documented in the ETRM metadata, along with their SQL statement dependencies.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents three procedures or functions within this package:

  • AR_AUTOMATIC_CLEARING — The core entry point that performs automatic clearing for the Receivables application. It applies the clearing rules configured in AR_SYSTEM_PARAMETERS against eligible receipts, credit memos, and open debit items, and writes the resulting clearing relationships to the interim and history tables.
  • AR_AUTOMATIC_CLEARING_PARALLEL — A parallel-enabled variant of the main clearing routine. It exists to distribute automatic clearing work across multiple concurrent workers, improving throughput on high-volume receipt populations.
  • AR_AUTO_CLEARING_IN_PARALLEL — The orchestration routine invoked to launch and manage the parallel clearing run, coordinating the worker processes spawned by AR_AUTOMATIC_CLEARING_PARALLEL.

No formal parameter signatures are published in the ETRM dependency document; the procedure names and their roles are the authoritative facts available.

Tables Accessed

The package interacts with the following tables, accessed through APPS synonyms:

  • AR_AUTOCLEAR_INTERIM — Staging table that holds candidate receipt and transaction matches generated during an automatic clearing run before they are committed.
  • AR_CASH_RECEIPTS — The receipt header table, read to identify and evaluate open and on-account cash receipts eligible for clearing.
  • AR_CASH_RECEIPT_HISTORY — The receipt activity history table, used to record the clearing and application events performed by the process.
  • AR_SYSTEM_PARAMETERS — Stores the Receivables system options, including the automatic clearing rules and defaults that govern matching logic.
  • CE_BANK_ACCOUNTS — Provides bank account information associated with the receipts being cleared.
  • DBMS_SQL and PLITBLM — Oracle-supplied utility packages used for dynamic SQL and PL/SQL table (associative array) manipulation within the package internals.

The package additionally references SYS.STANDARD, and is referenced by AR_ARZACS_XMLP_PKG, the packaged logic underlying an Automatic Clearing XML Publisher report.

Usage Notes

Automatic Clearing is normally executed from the Oracle Receivables concurrent program "Automatic Clearing," which submits the clearing run with user-specified parameters such as clearing rule, date range, and receipt batch. ARP_AUTOMATIC_CLEARING_PKG supplies the runtime engine behind that submission. Because the package is flagged as an OTHER API, Oracle does not publish a supported public signature; custom code should not call these procedures directly, and instead should invoke the standard concurrent program or use a supported Receivables API. The presence of the parallel procedures reflects Oracle's design for scalability, allowing large clearing volumes to be split across concurrent managers. When troubleshooting, DBAs and developers typically review AR_AUTOCLEAR_INTERIM for unprocessed candidates and AR_CASH_RECEIPT_HISTORY for audit records of what was cleared, alongside the concurrent request log for the Automatic Clearing program.