Search Results create_statement_line




Overview
Explore in AI Chat

Overview

APPS.CE_AUTO_BANK_CLEAR1 is a PL/SQL package in the Oracle E-Business Suite Cash Management (CE) module. It implements the core procedural logic behind automatic bank statement reconciliation, the process by which Oracle Payables payments, Oracle Receivables receipts, and miscellaneous treasury transactions are matched against imported bank statement lines and then cleared. In the context of a search for ce_auto_bank_match, this package is directly relevant: it depends on APPS.CE_AUTO_BANK_MATCH, which supplies the matching engine that determines candidate system transactions for statement lines. CE_AUTO_BANK_CLEAR1 consumes those candidates and drives them through reconciliation and clearing, updating statement lines, creating statement reconciliations, and adjusting transaction statuses. The package is classified as OTHER in ETRM and is held by the APPS schema with a VALID status. It is referenced by the CE_AUTO_BANK_CLEAR and CE_AUTO_BANK_MATCH packages, and it references CE_AUTO_BANK_MATCH in return, forming a tightly coupled reconciliation component set in releases 12.1.1 and 12.2.2.

Key Procedures and Functions

ETRM documents fifteen procedures and functions within the package. Their names indicate the following purposes, without implying parameter signatures.

  • SPEC_REVISION / BODY_REVISION — Return the package specification and body revision identifiers, used for version checking and support diagnostics.
  • VALIDATE_EFFECTIVE_DATE — Validates the effective date supplied for a reconciliation action against Cash Management date rules.
  • CHECK_MATCHING_STATUS — Inspects whether a statement line or transaction is in a state that permits automatic clearing.
  • UPDATE_LINE_UNRECONCILED — Reverts a statement line to an unreconciled state, supporting manual unmatch or reversal.
  • CREATE_STATEMENT_LINE — Creates a statement line record where a reconciliation action requires a new line, including for miscellaneous receipts.
  • INSERT_RECONCILIATION — Inserts the reconciliation row linking a statement line to a system transaction.
  • RECONCILE_RBATCH, RECONCILE_PBATCH, RECONCILE_PAY_EFT — Reconcile receivable batches, payable batches, and EFT payments respectively against statement lines.
  • MISC_RECEIPT — Handles miscellaneous receipt reconciliation, including bank charges and interest.
  • RECONCILE_STMT, RECONCILE_TRX — Perform statement-level and transaction-level reconciliation processing.
  • UNCLEAR_PROCESS — Reverses clearing for transactions previously reconciled, restoring their prior status.
  • POPULATE_AVAIL_TRX — Populates the available transactions temporary table used as the candidate pool for matching.

Tables Accessed

The package reads and writes statement data through CE_STATEMENT_HEADERS, CE_STATEMENT_LINES, CE_STATEMENT_LINES_S, and CE_STATEMENT_RECONCILS_ALL, which hold imported bank statement content and the reconciliation links. CE_AVAILABLE_TRANSACTIONS_TMP is populated by POPULATE_AVAIL_TRX to stage matchable transactions. Payment and receipt sources are read from AP_CHECKS_ALL, IBY_PAYMENTS_ALL, AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPT_HISTORY_ALL, AR_PAYMENT_SCHEDULES_ALL, AR_RECEIPT_METHODS, AR_RECEIPT_METHOD_ACCOUNTS, and RA_CUST_TRX_TYPES. DBMS_SQL supports dynamic statement construction, and DUAL is used for scalar evaluation.

Usage Notes

CE_AUTO_BANK_CLEAR1 is not intended for direct invocation by end users. It is called by the Automatic Bank Statement Reconciliation concurrent programs and by the Cash Management reconciliation forms, with CE_AUTO_BANK_CLEAR and CE_AUTO_BANK_MATCH as the principal callers. Custom code should invoke the supported concurrent process or the CE_AUTO_BANK_MATCH entry points rather than this internal package, because procedure signatures and error handling are not guaranteed across patches. Sites extending reconciliation logic should call the package only after validating matching status through the supported APIs.