Search Results ce_801_transactions_v




Overview
Explore in AI Chat

Overview

CE_801_TRANSACTIONS_V is a Cash Management (CE) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to expose "Available Payroll payments for reconciliation" — that is, payroll payment transactions originating in Oracle Payroll that are candidates for matching against bank statement lines within the Cash Management reconciliation workflow. The "801" prefix corresponds to the Cash Management transaction source identifier for payroll payments, analogous to source type codes used by the AutoReconciliation and manual reconciliation engines.

The view is not a standalone reporting object but a source feed consumed by the Cash Management transaction-matching infrastructure. It projects payroll payment details — bank account, payment method, currency, amount, and status — into the flat, wide column layout expected by the CE reconciliation programs. This layout mirrors the structure of CE_TRANSACTIONS_V, providing a heterogeneous row set that combines the payroll payment with its owning bank account and legal-entity context.

Underlying Base Objects

The view joins a substantial set of base objects across the CE, PAY, and FND schemas. Documented dependencies include:

Joins are driven by lookups on TRX_TYPE = 'PAYMENT', by matching the set of books to the system parameter, and by tying the bank account owner to the legal entity.

Key Columns

The SELECT list exposes a fixed-position column set. Notable columns include:

Common Use Cases and Queries

Typical uses include validating which payroll payments are available for reconciliation, reconciling differences between Payroll and Cash Management, and troubleshooting AutoReconciliation failures. A representative query is:

  • SELECT serial_number, bank_account_num, currency_code, action_status, effective_date FROM ce_801_transactions_v WHERE bank_account_id = :p_account_id;
  • SELECT * FROM ce_801_transactions_v WHERE serial_number = :p_serial;

Because the view depends on CE_SECURITY_PROFILES_GT and FND_GLOBAL, results are filtered by the responsible organization and session context; queries executed outside a valid Cash Management responsibility may return no rows. Always run it with the correct operating unit and ledger context set.