Search Results reversed_receipt_flag




Overview
Explore in AI Chat

Overview

CE.CE_AVAILABLE_TRANSACTIONS_TMP is a global temporary table in the Cash Management (CE) module of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It serves as a transient working area used by Cash Management reconciliation and transaction-search functionality to materialize the set of bank transactions that are candidates for manual or automatic reconciliation, clearing, and review. Because it is defined as a Global Temporary Table with a SYS$SESSION duration, the data it holds is visible only to the session that inserted it and is automatically purged at session termination; concurrent users therefore maintain fully isolated result sets without contention.

From a heuristic Data Vault modeling perspective, this object behaves as a standalone staging or work table rather than a persistent hub, link, or satellite. Its lifetime is bound to a single reconciliation or query session, and its columns are denormalized descriptions (account names, customer names, vendor names, status displays) populated for presentation rather than for durable reference-integrity storage. It should be treated as a transient satellite-like staging surface, not as a system of record.

Key Information Stored

The table exposes 75 documented columns. The most functionally significant are:

Common Use Cases and Queries

The dominant use case is transaction search and reconciliation review within the Cash Management workbench. Analysts filter by RECONCILED_STATUS_FLAG to isolate unreconciled items:

SELECT trx_number, status_dsp, amount, amount_cleared, currency_code
FROM   ce.ce_available_transactions_tmp
WHERE  reconciled_status_flag = 'N'
AND    bank_account_id = :p_bank_account_id;

Reconciliation matching typically aggregates cleared amounts against transaction amounts to compute open balances, and joins to CE_BANK_ACCT_USE_ID for account-use context. Reporting extracts commonly group by bank account, currency, and status for aging summaries of outstanding reconcilable items, while session-scoped ETL pipelines may stage candidate transactions here before writing to persistent reconciliation tables.

Related Objects