Search Results ce_arch_lines




Overview
Explore in AI Chat

Overview

The CE_ARCH_LINES table is a core data retention object within the Oracle E-Business Suite Cash Management (CE) module. It functions as the archival repository for detailed bank statement line items. When bank statements and their associated transactions are reconciled and subsequently purged from the active processing table (CE_STATEMENT_LINES), the records are moved to this archive table. This design ensures a complete, auditable history of all bank statement details while maintaining performance in the operational tables used for daily reconciliation tasks. Its role is critical for compliance, historical reporting, and audit trail requirements.

Key Information Stored

The table stores a comprehensive snapshot of each bank statement line item at the time of archival. While the specific column list is not fully detailed in the provided metadata, the primary and foreign key structure reveals its critical data points. Each record is uniquely identified by STATEMENT_LINE_ID (primary key). It maintains the relationship to its parent statement header via STATEMENT_HEADER_ID and preserves the original LINE_NUMBER for sequence. Foreign key relationships indicate it stores transaction codes (TRX_CODE_ID), currency details (CURRENCY_CODE), and exchange rate types (EXCHANGE_RATE_TYPE). In essence, it holds all transactional details—such as amount, value date, and description—that were present in the original CE_STATEMENT_LINES record.

Common Use Cases and Queries

The primary use case is historical inquiry and reporting on bank statement transactions beyond the active reconciliation window. Auditors and financial analysts query this table to trace transaction histories, investigate past reconciliations, or generate period-over-period cash flow analyses. A typical query would join to CE_ARCH_HEADERS_ALL to retrieve statement-level context (e.g., bank account, statement date).

  • Sample Query for Archived Lines:
    SELECT cal.line_number, cal.amount, cal.currency_code, cah.statement_number, cah.statement_date FROM ce_arch_lines cal, ce_arch_headers_all cah WHERE cal.statement_header_id = cah.statement_header_id AND cah.bank_account_id = :p_bank_acct_id ORDER BY cah.statement_date DESC;
  • Reconciliation Audit: Joining to CE_ARCH_RECONCILIATIONS_ALL allows users to review which archived lines were reconciled to specific GL or payment transactions.

Related Objects

CE_ARCH_LINES is centrally connected to several key Cash Management tables, as documented by its foreign key constraints.

  • CE_ARCH_HEADERS_ALL: The parent table. Joined via CE_ARCH_LINES.STATEMENT_HEADER_ID to obtain the archived statement header information.
  • CE_TRANSACTION_CODES: Joined via CE_ARCH_LINES.TRX_CODE_ID to get the meaning of the bank transaction code.
  • FND_CURRENCIES: Joined via CE_ARCH_LINES.CURRENCY_CODE for currency details.
  • GL_DAILY_CONVERSION_TYPES: Joined via CE_ARCH_LINES.EXCHANGE_RATE_TYPE for the exchange rate type used.
  • CE_ARCH_RECONCILIATIONS_ALL: A child table. CE_ARCH_RECONCILIATIONS_ALL.STATEMENT_LINE_ID references this table to store reconciliation results for each archived line.
  • CE_ARCH_RECON_ERRORS: Another child table. CE_ARCH_RECON_ERRORS.STATEMENT_LINE_ID references this table to log any reconciliation errors associated with the archived line.