Search Results ce_xla_ext_headers_v




Overview
Explore in AI Chat

Overview

CE_XLA_EXT_HEADERS_V is an APPS-owned database view in the Cash Management (CE) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It exposes cash flow transactions in the column layout required by the Subledger Accounting (XLA) engine, specifically as an "extension headers" source used during the creation of accounting events and journal entries for cash management activity. The view bridges operational cash management data — bank statement lines, payment transactions, and cash flows — to the XLA data model, presenting one row per accounting-relevant cash flow event.

The view is registered as an external source in the XLA configuration for the Cash Management application. Because it returns the accounting event identifier, event type, accounting date, status, and reversal attributes alongside the monetary and currency detail of each cash flow, it allows the accounting program to extract the transactions it must account for without directly querying the underlying CE tables. The user search term xle_firstparty_information_v is directly relevant: XLE_FIRSTPARTY_INFORMATION_V is one of the documented base objects of this view, supplying first-party (internal) party information used to populate the legal entity, ledger, and party context required for subledger accounting.

Underlying Base Objects

According to the documented metadata, the view references the following base objects:

The view is therefore a denormalized join across cash management transaction tables, with the first-party and party lookups supplying the entity context that XLA requires.

Key Columns

Common Use Cases and Queries

This view is chiefly consumed by XLA accounting event extraction and by reconciliation reports that need event-level detail.

  • Audit cash flow accounting events by ledger and date.
  • Diagnose missing or stuck subledger accounting entries for statements or payments.
  • Report validated receipts/payments with currency and exchange-rate information.

Sample query:

SELECT event_id, cashflow_id, event_type, accounting_date,
cashflow_direction, cashflow_currency_code, cashflow_amount, status_code
FROM apps.ce_xla_ext_headers_v
WHERE accounting_date BETWEEN :p_from AND :p_to
AND status_code = 'VALIDATED';

Because the view derives exchange rates at runtime and joins many tables, filtering on EVENT_ID, CASHFLOW_ID, or ACCOUNTING_DATE is recommended for acceptable performance.