Search Results get_manual_clearing

Overview

APPS.CE_AUTO_BANK_CLEAR is a PL/SQL package in the Oracle Cash Management module of Oracle E-Business Suite, present and valid in both 12.1.1 and 12.2.2. Its principal business function is to automate the reconciliation and clearing of bank statement lines against Oracle subledger and Oracle Payables transactions. Rather than requiring a treasury user to manually match and clear every statement line, the package applies matching and clearing logic on behalf of the Automatic Bank Reconciliation process, sets and unsets manual clearing flags, manages clearing and reversal amounts, and drives the reversal of previously cleared transactions. In that sense it acts as the engine behind automatic bank statement reconciliation, bridging imported bank statement lines stored in Cash Management with cash receipts and payment details sourced from Receivables and Payables.

Key Procedures and Functions

The package exposes 21 documented procedures and functions. The reconciliation drivers include RECONCILE_PROCESS, RECONCILE_STMT, RECONCILE_TRX, RECONCILE_PBATCH and RECONCILE_RBATCH, which orchestrate the matching of statement headers and lines to transactions, batches and receipt batches. The clearing logic is handled by SET_MANUAL_CLEARING, UNSET_MANUAL_CLEARING, GET_MANUAL_CLEARING, CALCULATE_CLEARING_AMOUNTS and UPDATE_LINE_STATUS, which record and derive clearing flags, amounts and line statuses. Reversal handling is provided by SET_REVERSE_MODE, UNSET_REVERSE_MODE, GET_REVERSE_MODE, UNCLEAR_PROCESS, DM_REVERSALS and REVERSALS, allowing the clear/unclear state and reversal mode of transactions to be toggled and reversed. Supporting utility members include TRX_REMAIN for computing remaining transaction amounts, RECONCILE_PAY_EFT for payment and electronic funds transfer reconciliation, and SPEC_REVISION and BODY_REVISION, the standard package revision stamps used to identify the installed version of the specification and body.

Tables Accessed

The package reads and writes the core Cash Management reconciliation tables. CE_STATEMENT_LINES (and its synonym-backed companion CE_STATEMENT_LINES_S) and CE_STATEMENT_HEADERS supply the imported bank statement data against which matching occurs. CE_STATEMENT_RECONCILS_ALL stores the resulting reconciliation and clearing records. On the cash side, AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPT_HISTORY_ALL and AR_PAYMENT_SCHEDULES provide receipt, payment schedule and receipt history detail used to match and clear receipts and payments. DBMS_SQL is referenced for dynamic SQL execution. Standard and SYS dependencies are also recorded, reflecting normal PL/SQL runtime usage.

Usage Notes

CE_AUTO_BANK_CLEAR is typically invoked indirectly rather than called directly by end users. It is executed through the Automatic Bank Reconciliation concurrent program and related Cash Management reconciliation processes, which supply the statement and transaction context. Reference to the package from a large family of reconciliation views — including CE_200_RECONCILED_V, CE_200_TRANSACTIONS_V, CE_222_REVERSAL_V, CE_222_TRANSACTIONS_V, CE_222_TXN_FOR_BATCH_V, CE_AVAILABLE_TRANSACTIONS_V, CE_RECONCILED_TRANSACTIONS_V and CE_REVERSAL_TRANSACTIONS_V — indicates that these views depend on its logic. It is further referenced by 11 other packages, notably CE_AUTO_BANK_CLEAR1, CE_AUTO_BANK_MATCH and CE_AUTO_BANK_UNREC, confirming it as a central, reusable component within the Cash Management reconciliation stack. Customizations and extensions should call it through its documented entry points rather than modifying the package body, and the dependency chain should be reviewed before any upgrade between 12.1.1 and 12.2.2.