Search Results ce_801_eft_transactions_v




Overview
Explore in AI Chat

Overview

CE_801_EFT_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. It exposes Electronic Funds Transfer (EFT) payment transactions originating from Oracle Payroll and Payables-style disbursements, presenting them in the column layout expected by the Cash Management bank statement reconciliation and automatic reconciliation interfaces. The numeric prefix "801" corresponds to the transaction source identifier used by the CE reconciliation engine to classify records as payroll-originated EFT payments. The view functions as a reporting and integration layer: instead of forcing external programs to join numerous PAY and CE tables directly, it returns a flattened, recon-ready result set whose columns align with the structure consumed by CE_801_EFT_RECONCILIATION or the standard bank statement line reconciliation process.

Underlying Base Objects

The view is defined over a substantial join tree. Documented base objects include PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PAY_PRE_PAYMENTS, PAY_ORG_PAYMENT_METHODS_F, PAY_PAYMENT_TYPES, PAY_ACTION_INTERLOCKS, and PAY_CE_RECONCILED_PAYMENTS. Bank and cash data are drawn from CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_ALL, CE_BANK_BRANCHES_V, CE_STATEMENT_RECONCILS_ALL, CE_SYSTEM_PARAMETERS, CE_SECURITY_PROFILES_GT, and CE_LOOKUPS. Supporting lookups and ledger context come from FND_COMMON_LOOKUPS, FND_GLOBAL, and GL_SETS_OF_BOOKS. The view also invokes the PAY_CE_RECONCILIATION_PKG package three times to derive transaction date, concatenated identifiers, and transaction group values dynamically at query time. Because several referenced objects are synonyms pointing to PAY or CE base tables, the view is dependent on the underlying Payroll and Cash Management data model rather than materialized copies.

Key Columns

The SELECT list returns a ROWID and a literal 'N', followed by bank account identifiers and names (BANK_ACCOUNT_ID, BANK_ACCOUNT_NAME, BANK_ACCOUNT_NUM) and bank/branch names from CE_BANK_BRANCHES_V. Payment context columns include ASSIGNMENT_ACTION_ID, a literal 'PAYMENT', the lookup meaning for the payment type, and SERIAL_NUMBER. Currency and amount handling is notable: the view returns POPM.CURRENCY_CODE and decodes PPP.VALUE against the ledger functional currency, the bank account currency, or BASE_CURRENCY_VALUE, producing a transaction amount reported in the appropriate currency. It also returns a currency-type indicator using DECODE to label the amount as FUNCTIONAL, BANK, or FOREIGN. Transaction dates and grouping are computed by PAY_CE_RECONCILIATION_PKG.PAYMENT_TRANSACTION_INFO calls, with parameters including EFFECTIVE_DATE, PAYROLL_ACTION_ID, PAYMENT_TYPE_ID, ORG_PAYMENT_METHOD_ID, PERSONAL_PAYMENT_METHOD_ID, ASSIGNMENT_ACTION_ID, and PRE_PAYMENT_ID. The constant 801 identifies the transaction source, and the final columns carry the functional currency, asset code combination, and a 'PAY_EFT' source label along with BASE_CURRENCY_VALUE.

Common Use Cases and Queries

The primary use case is bank statement reconciliation for payroll EFT payments—matching cleared bank lines against payroll disbursements. A second use case is reporting EFT payment registers by bank account, currency, and date range, and a third is feeding external treasury or reconciliation systems that expect the CE transaction source 801 layout.

A representative query lists EFT payments for a bank account over a date window:

  • SELECT bank_account_id, bank_account_num, serial_number, currency_code, transaction_amount, transaction_date FROM ce_801_eft_transactions_v WHERE bank_account_id = :p_bank_account_id AND transaction_date BETWEEN :p_from AND :p_to;
  • SELECT transaction_group, concatenated_identifiers, currency_code, transaction_amount FROM ce_801_eft_transactions_v WHERE transaction_source = 801 AND currency_code = 'USD';
  • SELECT bank_name, bank_branch_name, COUNT(*), SUM(transaction_amount) FROM ce_801_eft_transactions_v GROUP BY bank_name, bank_branch_name;

Because transaction date and identifier values are computed through PAY_CE_RECONCILIATION_PKG, large unrestricted queries can be expensive; filtering by bank account, currency, or date range is recommended. The view is read-only and should be treated as a reporting interface rather than a target for DML.