Search Results ce_statement_reconcils_all




Overview
Explore in AI Chat

Overview

The CE_STATEMENT_RECONCILS_ALL table is a core transactional table within Oracle E-Business Suite Cash Management (CE) module. It serves as the definitive repository for recording and tracking the reconciliation of bank statement lines to internal accounting transactions. Its primary role is to maintain the detailed audit trail of the reconciliation process, linking imported bank statement lines from the CE_STATEMENT_LINES_ALL table to their corresponding accounting entries, typically represented by General Ledger (GL) journal entries. This linkage is fundamental to the bank reconciliation functionality, enabling the matching of cleared items and ensuring the company's internal cash records align with the external bank's official statement.

Key Information Stored

The table's structure is designed to capture the precise relationship between a bank statement line and one or more internal transactions. Its composite primary key underscores the nature of this relationship. Key columns include STATEMENT_LINE_ID, which references the specific line from the bank statement being reconciled. The REFERENCE_TYPE and REFERENCE_ID columns together identify the internal transaction object, such as a payment, receipt, or journal entry, to which the statement line is matched. The JE_HEADER_ID is a critical foreign key that links to the GL_JE_HEADERS table, storing the General Ledger journal created as a result of the reconciliation, which posts the accounting impact. The CURRENT_RECORD_FLAG is essential for maintaining data integrity, indicating which record is the active, current reconciliation for a given statement line, particularly in scenarios where a reconciliation may be reversed and recreated.

Common Use Cases and Queries

This table is central to reconciliation reporting and troubleshooting. A common use case is generating a detailed reconciliation report for a specific bank account and statement. Analysts and accountants query this table to verify what internal transactions cleared a particular bank statement. Sample SQL patterns often join to CE_STATEMENT_LINES_ALL for statement details and to GL_JE_HEADERS for journal information. For instance, a query to find all reconciliations for a statement would filter on STATEMENT_LINE_ID from the target statement and CURRENT_RECORD_FLAG = 'Y'. Another critical use case is identifying unreconciled items by performing an anti-join between CE_STATEMENT_LINES_ALL and CE_STATEMENT_RECONCILS_ALL where no current reconciliation record exists. This table is also heavily queried during period-end close processes to confirm the completeness of bank reconciliations.

Related Objects

  • CE_STATEMENT_LINES_ALL: The primary parent table. The foreign key CE_STATEMENT_RECONCILS_ALL.STATEMENT_LINE_ID references CE_STATEMENT_LINES_ALL.STATEMENT_LINE_ID. This relationship ties the reconciliation detail back to the original imported bank transaction.
  • GL_JE_HEADERS: A key related table. The foreign key CE_STATEMENT_RECONCILS_ALL.JE_HEADER_ID references GL_JE_HEADERS.JE_HEADER_ID. This links the reconciliation to the accounting journal entry it generated in the General Ledger.
  • CE_STATEMENT_RECONCILS (APIs): Public APIs, such as CE_STATEMENT_RECONCILS_PKG, typically exist to create, update, or reverse reconciliation records programmatically, ensuring business logic and data integrity are maintained.
  • Reconciliation Reports & Open Interfaces: Standard Cash Management reports (e.g., Bank Statement Detail Report) and the bank statement reconciliation open interface (CE_STMT_RECONCILIATIONS_INT) rely on or populate this table.