Search Results ce_header_interface_errors




Overview
Explore in AI Chat

Overview

CE_HEADER_INTERFACE_ERRORS is a Cash Management (CE) module table in the Oracle E-Business Suite 12.1.1 and 12.2.2 schemas. It functions as a diagnostic error repository for the bank statement header interface process, capturing validation failures encountered when records are staged for import into the Cash Management statement infrastructure. The table is populated by the Bank Statement Open Interface and XML/electronic statement loading programs when a statement header fails validation against the CE_STATEMENT_HEADERS_INT_ALL interface table.

Each row in CE_HEADER_INTERFACE_ERRORS represents a discrete validation error associated with a specific statement header. Rather than aborting the entire load, Cash Management records the offending statement identifier, the target bank account, and a message name describing the failure, allowing users to correct the source data and resubmit. The table therefore acts as an audit and troubleshooting aid, not as a transactional or accounting table. Because it stores error associations between two business entities — a statement header and a validation message — the heuristic Data Vault classification suggested by the ETRM metadata is a link, reflecting its role as a relationship-bearing structure rather than a standalone hub or satellite.

Key Information Stored

The documented schema comprises six columns. The most significant are:

  • STATEMENT_NUMBER — Identifies the bank statement header that failed validation. This is a foreign key to CE_STATEMENT_HEADERS_INT_ALL.STATEMENT_NUMBER and is the principal business-key candidate for correlating an error back to its source record.
  • BANK_ACCOUNT_NUM — The bank account number associated with the rejected statement header. Combined with STATEMENT_NUMBER, this forms the composite foreign key relationship to CE_STATEMENT_HEADERS_INT_ALL, ensuring the error is tied to the correct account context.
  • MESSAGE_NAME — The name of the validation error message describing why the header was rejected (for example, a missing or invalid account, currency, or date condition).
  • APPLICATION_SHORT_NAME — The short name of the Oracle application that raised the error; a foreign key to FND_APPLICATION.
  • CREATION_DATE — Timestamp of when the error row was created, useful for timing analysis and purge routines.
  • CREATED_BY — The user or concurrent program that generated the error record.

The metadata does not document a surrogate primary key or a unique index on this table, so STATEMENT_NUMBER, BANK_ACCOUNT_NUM, and APPLICATION_SHORT_NAME together serve as the practical business identifiers for locating an error.

Common Use Cases and Queries

The primary use case is diagnosing why a bank statement failed to import. A typical query joins the error table to the header interface table and to the message lookup:

  • Listing all errors for a bank account: SELECT statement_number, bank_account_num, message_name, creation_date FROM ce_header_interface_errors WHERE bank_account_num = :acct;
  • Correlating an error to its header row via the documented FK: SELECT h.*, e.message_name FROM ce_statement_headers_int_all h, ce_header_interface_errors e WHERE h.statement_number = e.statement_number AND h.bank_account_num = e.bank_account_num;
  • Grouping errors by message to spot systemic data problems prior to resubmission.
  • Age analysis and housekeeping, using CREATION_DATE to purge stale error rows.

Related Objects

  • CE_STATEMENT_HEADERS_INT_ALL — The statement header interface table; joined on STATEMENT_NUMBER and BANK_ACCOUNT_NUM. This is the parent of the error records.
  • FND_APPLICATION — Application registry, joined on APPLICATION_SHORT_NAME.
  • CE_STATEMENT_LINES_INT_ALL — Companion line-level interface table, relevant when header validation succeeds but line errors occur.
  • CE_BANK_ACCOUNTS and CE_BANK_ACCT_USES_ALL — Bank account definitions validating the account context.
  • FND_MESSAGE / FND_NEW_MESSAGES — Application message dictionary resolving MESSAGE_NAME to readable text.
  • Bank Statement Open Interface concurrent programs — The loaders that populate this error table.