Search Results ce_upg_pay_accts_tmp

Overview

The PAY_EXTERNAL_ACCOUNTS table is a core data object within the Oracle E-Business Suite Payroll module (PAY). It serves as the central repository for storing bank account details that enable the disbursement of payments. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is fundamental to the payment process, acting as the master source for bank account information used for payroll, supplier payments, and other financial disbursements. Its primary role is to link payment methods defined for employees or organizations to specific, validated bank accounts held within the system's financials structure.

Key Information Stored

While the provided metadata does not list specific columns, the table's primary key is documented as EXTERNAL_ACCOUNT_ID. This unique identifier is the critical column used throughout the payroll and payments ecosystem to reference a specific bank account record. Based on its description and relationships, the table typically stores details such as the bank account number, bank and branch identifiers, account type (e.g., checking, savings), currency, and the associated bank account record from the Accounts Payable (AP) module. The foreign key relationships indicate it stores information that aligns with bank accounts defined in AP_BANK_ACCOUNTS_ALL and AP_BANK_BRANCHES.

Common Use Cases and Queries

This table is central to payment setup and reporting. Common use cases include validating the bank accounts assigned to employees for direct deposit, troubleshooting payment failures by verifying account details, and generating reports on payment destinations. A typical query would join PAY_EXTERNAL_ACCOUNTS to payment method tables to list all active bank accounts for employees.

• Sample Query (Finding Accounts for a Person): SELECT pea.external_account_id, ppmf.personal_payment_method_id FROM pay_personal_payment_methods_f ppmf JOIN pay_external_accounts pea ON ppmf.external_account_id = pea.external_account_id WHERE ppmf.person_id = :person_id AND SYSDATE BETWEEN ppmf.effective_start_date AND ppmf.effective_end_date;
• Reporting Use Case: Auditing all payroll bank accounts linked to a specific bank branch by joining PAY_EXTERNAL_ACCOUNTS with AP_BANK_ACCOUNTS_ALL and AP_BANK_BRANCHES.

Related Objects

The PAY_EXTERNAL_ACCOUNTS table has documented foreign key relationships with several key objects, primarily in the Payroll (PAY) and Cash Management (CE) modules. These relationships define its integration points.

• AP_BANK_ACCOUNTS_ALL: Linked via AP_BANK_ACCOUNTS_ALL.PAYROLL_BANK_ACCOUNT_ID. This ties the payroll account to the underlying bank account in Financials.
• AP_BANK_BRANCHES: Linked via AP_BANK_BRANCHES.PAYROLL_BANK_ACCOUNT_ID.
• PAY_ORG_PAYMENT_METHODS_F: Linked via PAY_ORG_PAYMENT_METHODS_F.EXTERNAL_ACCOUNT_ID. Defines organization-level payment methods.
• PAY_PERSONAL_PAYMENT_METHODS_F: Linked via PAY_PERSONAL_PAYMENT_METHODS_F.EXTERNAL_ACCOUNT_ID. Defines individual employee payment methods.
• PAY_PSS_TRANSACTION_STEPS: Linked via EXTERNAL_ACCOUNT_ID and O_EXTERNAL_ACCOUNT_ID. Used in the Payment Settlement process.
• CE_UPG_PAY_ACCTS_TMP & CE_UPG_PURGE_PAY_ACCTS: Temporary and upgrade-related tables linked via EXTERNAL_ACCOUNT_ID.