Search Results reconcile_trx

Overview

CE_AUTO_BANK_CLEAR1 is a core Cash Management (CE) package in Oracle E-Business Suite that performs automatic bank statement reconciliation. Its primary business function is to match bank statement lines against open transactions such as receipts, payments, and miscellaneous transactions, and to create the resulting reconciliation and statement line records. The package enables organizations to automate the clearing of transactions against imported bank statement data, reducing manual reconciliation effort in the Cash Management module. It is documented with an API classification of OTHER and is owned by the APPS schema. The header comment indicates active maintenance across releases (script version 120.49.12020000.7, dated 2013/03/21), and the source references fixes such as bug 5637589 for manual remittance batch reconciliation and bug 4435028 for adding CE transactions to payment batches. The package is referenced by two other packages, confirming its role as a shared reconciliation utility. For users searching on "reconcile_trx", this procedure is the transaction-level reconciliation entry point within the package.

Key Procedures and Functions

The package exposes fifteen documented procedures and functions. Several are concerned with batch-level reconciliation: RECONCILE_RBATCH reconciles receipt batches, RECONCILE_PBATCH reconciles payment batches, and RECONCILE_PAY_EFT handles electronic funds transfer payment reconciliation. RECONCILE_TRX performs reconciliation at the individual transaction level, which is the object most commonly referenced by the "reconcile_trx" search term. RECONCILE_STMT reconciles statement-level data. Supporting these are INSERT_RECONCILIATION, which writes reconciliation records, and CREATE_STATEMENT_LINE, which generates statement line entries. UNCLEAR_PROCESS reverses or clears reconciliation activity, and UPDATE_LINE_UNRECONCILED marks a line as no longer reconciled. CHECK_MATCHING_STATUS evaluates whether a transaction matches and is therefore eligible for clearing. VALIDATE_EFFECTIVE_DATE checks date validity during processing. MISC_RECEIPT handles miscellaneous receipt transactions, while POPULATE_AVAIL_TRX loads the working table of available transactions for matching. SPEC_REVISION and BODY_REVISION are standard EBS revision-tracking functions that record the specification and body version identifiers.

Tables Accessed

The package reads and writes against AR and CE base tables through APPS synonyms. Receipt data is sourced from AR_CASH_RECEIPTS_ALL and AR_CASH_RECEIPT_HISTORY_ALL, with payment schedules from AR_PAYMENT_SCHEDULES_ALL and transaction types from RA_CUST_TRX_TYPES. Receipt methods and their accounting are read from AR_RECEIPT_METHODS and AR_RECEIPT_METHOD_ACCOUNTS. Payment-side data is drawn from AP_CHECKS_ALL and IBY_PAYMENTS_ALL. Statement and reconciliation output is written to CE_STATEMENT_HEADERS, CE_STATEMENT_LINES, CE_STATEMENT_LINES_S, and CE_STATEMENT_RECONCILS_ALL. The working table CE_AVAILABLE_TRANSACTIONS_TMP is central to the cursor logic, holding the candidate transactions selected for a given batch. DBMS_SQL supports dynamic operations, and DUAL is used for single-row evaluations.

Usage Notes

CE_AUTO_BANK_CLEAR1 is typically invoked from the Cash Management automatic reconciliation concurrent programs and related reconciliation flows rather than being called interactively by end users. The package cursors select from CE_AVAILABLE_TRANSACTIONS_TMP filtered by batch_id, application_id 222, and a reconciled_status_flag of 'N', excluding REVERSED transactions. Because the package is referenced by two other packages, custom extensions and integrations sometimes call its reconciliation procedures directly, but this should be done cautiously. Implementers extending automatic bank clearing should preserve the effective-date validation and matching-status checks performed internally. Test any direct invocation against the AR and CE table relationships documented above, particularly the receipt history and statement reconciliation tables, to avoid orphaned reconciliation records.