Search Results pay_eft

Overview

APPS.CE_801_EFT_TRANSACTIONS_V is a seeded Oracle E-Business Suite view that exposes electronic funds transfer (EFT) payment transactions for bank statement reconciliation in the Cash Management module. The numeric suffix "801" identifies the cashflow transaction source, and the view presents data in the canonical Cash Management transaction-interface column layout used by the CE_801_EFT_TRANSACTIONS_V family of reconciliation views. In Oracle EBS 12.1.1 and 12.2.2, the view serves as the bridge between Oracle Payroll payment processing and Cash Management statement reconciliation, allowing EFT disbursements generated through Oracle Payroll to be loaded into the reconciliation workbench and matched against bank statement lines. Because the view derives its data from payroll assignment actions and pre-payment records rather than from a single transactional table, it functions principally as a reporting and integration construct rather than an updateable entity.

Underlying Base Objects

The view is defined over a substantial set of documented synonyms, views, and packages:

• Payroll objects: PAY_ASSIGNMENT_ACTIONS, PAY_PAYROLL_ACTIONS, PAY_PRE_PAYMENTS, PAY_PAYMENT_TYPES, PAY_ORG_PAYMENT_METHODS_F, PAY_ACTION_INTERLOCKS, PAY_CE_RECONCILED_PAYMENTS, and the PAY_CE_RECONCILIATION_PKG package.
• Cash Management objects: CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_ALL, CE_BANK_BRANCHES_V, CE_LOOKUPS, CE_STATEMENT_RECONCILS_ALL, CE_SYSTEM_PARAMETERS, CE_SECURITY_PROFILES_GT, and FND_COMMON_LOOKUPS.
• General Ledger and security: GL_SETS_OF_BOOKS supplies the functional (SOB) currency, while FND_GLOBAL provides session context such as the operating unit and user.

The view joins payroll assignment actions to bank account and bank branch information and invokes PAY_CE_RECONCILIATION_PKG.payment_transaction_info to resolve transaction dates, concatenated identifiers, and transaction group values dynamically at query time.

Key Columns

• assignment_action_id — the payroll assignment action identifier that anchors each EFT transaction.
• bank_account_id / bank_account_num / bank_account_name — the disbursing bank account details sourced from CE_BANK_ACCOUNTS.
• bank_name / bank_branch_name — bank and branch descriptions from CE_BANK_BRANCHES_V.
• currency_code — derived via decode logic comparing the payment method currency to the ledger (SOB) currency and bank currency to classify the transaction as FUNCTIONAL, BANK, or FOREIGN.
• value / base_currency_value — the payment amount in the transaction currency and functional currency respectively.
• transaction_date — computed through PAY_CE_RECONCILIATION_PKG using the payroll effective date.
• concatenated_identifiers — a composite key produced by the reconciliation package.
• action_status — decoded so that status "E" resolves to the reconciliation status code from PAY_CE_RECONCILED_PAYMENTS, otherwise the raw action status is returned.
• trx_type ('PAY_EFT') and trx_source (801) — constants that tag each row as an EFT payment transaction for the 801 source.

Common Use Cases and Queries

The view is typically queried to enumerate unreconciled payroll EFT payments, to troubleshoot reconciliation failures, and to feed Cash Management statement matching. A representative query is:

• SELECT assignment_action_id, bank_account_num, currency_code, value, transaction_date, action_status FROM apps.ce_801_eft_transactions_v WHERE currency_code = 'FUNCTIONAL';
• Filtering by BANK_ACCT_USE_ID or asset_code_combination_id to reconcile against a specific bank account use.
• Joining to PAY_PAYROLL_ACTIONS to trace a transaction back to its payroll run for audit purposes.

Because payment_transaction_info is a PL/SQL function call per row, large-volume queries should be restricted by date or payroll action to preserve performance.