Search Results ce_reconciliation_errors




Overview
Explore in AI Chat

Overview

The CE_RECONCILIATION_ERRORS table is a core data object within the Oracle E-Business Suite Cash Management (CE) module, specifically in versions 12.1.1 and 12.2.2. It serves as the central repository for recording validation and reconciliation errors encountered during the processing of bank statement lines. Its primary role is to capture and persist error details when the system attempts to reconcile imported bank statement lines (from CE_STATEMENT_LINES) with transactions from other EBS subledgers, such as Payables or Receivables. This table is critical for troubleshooting reconciliation failures, providing a clear audit trail of issues that prevent automatic matching, and enabling users to review and correct problematic transactions before completing the reconciliation process.

Key Information Stored

The table stores metadata and descriptive text for each reconciliation error. While the full column list is not provided in the excerpt, the documented foreign keys indicate the presence of several critical fields. The STATEMENT_LINE_ID column is a foreign key to CE_STATEMENT_LINES, linking each error directly to the specific bank statement line that caused the failure. The APPLICATION_SHORT_NAME column is a foreign key to FND_APPLICATION, identifying the source EBS application (e.g., 'AP', 'AR', 'CE') of the transaction that failed to reconcile. Other typical columns in this table would include an ERROR_TYPE to categorize the nature of the error (e.g., 'VALIDATION', 'MATCHING'), a detailed ERROR_MESSAGE or DESCRIPTION field containing the system-generated error text, and creation date/user columns for auditing purposes.

Common Use Cases and Queries

The primary use case is diagnosing and resolving reconciliation holds. After running the AutoReconciliation program, users and administrators query this table to identify statement lines that were not reconciled. A standard diagnostic query joins to CE_STATEMENT_LINES and the relevant transaction tables to get a complete view of the problem.

  • Identifying All Errors for a Statement: SELECT cre.* FROM ce_reconciliation_errors cre, ce_statement_lines csl WHERE cre.statement_line_id = csl.statement_line_id AND csl.statement_header_id = :p_statement_header_id;
  • Reviewing Errors by Application: SELECT application_short_name, COUNT(*) FROM ce_reconciliation_errors GROUP BY application_short_name;
  • Data Cleanup: After errors are corrected via the Cash Management interface or source subledgers, records may be purged from this table for a given statement line once a successful reconciliation is completed.

Related Objects

The CE_RECONCILIATION_ERRORS table has defined foreign key relationships with two key tables, as documented in the provided metadata.

  • CE_STATEMENT_LINES: This is the most critical relationship. The STATEMENT_LINE_ID column in CE_RECONCILIATION_ERRORS references the STATEMENT_LINE_ID in CE_STATEMENT_LINES. This links every error to the exact bank transaction it pertains to.
  • FND_APPLICATION: The APPLICATION_SHORT_NAME column in CE_RECONCILIATION_ERRORS references the APPLICATION_SHORT_NAME in FND_APPLICATION. This ties the error to the specific EBS product module (like AP, AR, GL) where the matching transaction originated or was expected to be found.

While not listed in the provided keys, this table is intrinsically related to the reconciliation engine within the CE module and is often accessed via standard Cash Management forms and reports designed for error resolution.