Search Results reconcile_rbatch

Overview

APPS.CE_AUTO_BANK_CLEAR is a core Cash Management (CE) package body responsible for automating the bank statement reconciliation cycle in Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary business function is to match bank statement lines against open transactions — receipts, payments, and other cash movements — and to clear or unclear those transactions automatically or under user-directed control. The package underpins the Automatic Reconciliation feature in Cash Management, enabling organizations to reconcile high volumes of statement lines without manual intervention.

The package maintains internal state flags such as yes_manual_clearing and yes_reverse_mode, which govern whether the reconciliation run operates in manual or reverse mode. These flags are manipulated through dedicated setter and getter routines, giving callers fine-grained control over processing behavior within a single session.

Key Procedures and Functions

• SPEC_REVISION / BODY_REVISION — Return the package specification and body revision strings, used for version tracking and diagnostics.
• SET_MANUAL_CLEARING / UNSET_MANUAL_CLEARING / GET_MANUAL_CLEARING — Toggle and retrieve the manual clearing flag, which determines whether clearing is performed automatically or requires manual confirmation.
• SET_REVERSE_MODE / UNSET_REVERSE_MODE / GET_REVERSE_MODE — Control and query reverse mode, used when existing reconciliations must be undone or reversed.
• RECONCILE_PROCESS — The main driver procedure orchestrating the reconciliation workflow across statement lines.
• UPDATE_LINE_STATUS — Updates a statement line's status, for example to 'RECONCILED', reflecting its current state in the reconciliation lifecycle.
• CALCULATE_CLEARING_AMOUNTS — Computes the amounts to be applied when clearing transactions, accounting for currency type (BANK versus transaction currency) and foreign exchange considerations.
• TRX_REMAIN — Determines the remaining unreconciled amount on a transaction.
• RECONCILE_STMT / RECONCILE_TRX — Reconcile at the statement and transaction level respectively.
• RECONCILE_PAY_EFT — Handles reconciliation of electronic funds transfer payments.
• UNCLEAR_PROCESS — Reverses previously cleared items, restoring them to an unreconciled state.
• DM_REVERSALS / REVERSALS — Manage debit memo and general reversal processing during reconciliation.
• RECONCILE_PBATCH / RECONCILE_RBATCH — Reconcile payment batches and receipt batches, supporting batch-level clearing.

Tables Accessed

• CE_STATEMENT_LINES / CE_STATEMENT_LINES_S — The statement lines being reconciled, and the sequence used to generate line identifiers.
• CE_STATEMENT_HEADERS — Header-level statement data providing context for line processing.
• CE_STATEMENT_RECONCILS_ALL — Stores the reconciliation matches between statement lines and transactions.
• AR_CASH_RECEIPTS_ALL / AR_CASH_RECEIPT_HISTORY_ALL — Receipt records and their history, updated as receipts are cleared.
• AR_PAYMENT_SCHEDULES — Payment schedule rows whose amounts and status are adjusted during clearing.
• DBMS_SQL — Oracle's dynamic SQL package, referenced for dynamic statement construction during reconciliation.

Usage Notes

CE_AUTO_BANK_CLEAR is typically invoked from the Cash Management Automatic Reconciliation concurrent program and from the Bank Statements reconciliation forms. The ETRM metadata records that it is referenced by eleven other packages, confirming its role as a shared service within the CE and AR reconciliation stack. Custom code should not call this package directly in production; instead, the supported public API surface for reconciliation is exposed through the standard Cash Management APIs. The setter routines (SET_MANUAL_CLEARING, SET_REVERSE_MODE) are intended for use within a controlled reconciliation run to alter processing behavior, and the getters allow downstream logic to branch on the current mode. Because the package writes to AR receipt and payment schedule tables, any direct invocation must respect the same transaction and validation rules enforced by the standard reconciliation flows.