Search Results pay_personal_payment_methods_f




Overview
Explore in AI Chat

Overview

The PAY_PERSONAL_PAYMENT_METHODS_F table is a core data object within the Oracle E-Business Suite Payroll module (PAY). It serves as the primary repository for storing an employee's chosen method of payment, such as direct deposit or check. As a date-tracked table (indicated by the '_F' suffix and the presence of EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns), it maintains a full history of changes to an employee's payment method over time. This temporal tracking is essential for accurate payroll processing and auditing, ensuring that the correct payment method is applied for any given payroll run date. The table is owned by the HR schema and is integral to the payroll calculation and payment distribution processes in both releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to link an employee, a payment method, and associated details within a specific business group context. Its primary key is a composite of PERSONAL_PAYMENT_METHOD_ID and EFFECTIVE_START_DATE. Critical columns include:

  • PERSONAL_PAYMENT_METHOD_ID: The unique identifier for a payment method record.
  • EFFECTIVE_START_DATE / EFFECTIVE_END_DATE: Define the period during which the payment method record is active.
  • BUSINESS_GROUP_ID: Links to HR_ALL_ORGANIZATION_UNITS, scoping the record to a specific business group for security and data partitioning.
  • EXTERNAL_ACCOUNT_ID: A foreign key to PAY_EXTERNAL_ACCOUNTS, which holds the detailed bank account information for direct deposit methods.
  • ASSIGNMENT_ID: Associates the payment method with a specific work assignment of the employee (from PER_ALL_ASSIGNMENTS_F).
  • ORG_PAYMENT_METHOD_ID: References the organization-level payment method definition (e.g., "US Direct Deposit") from PAY_ORG_PAYMENT_METHODS_F.
  • PRIORITY: Indicates the order of use for multiple payment methods (e.g., splitting net pay across accounts).
  • AMOUNT / PERCENTAGE: Specifies the fixed amount or percentage of net pay to be allocated to this payment method.

Common Use Cases and Queries

This table is central to payroll operations and reporting. A primary use case is verifying an employee's active payment method for a payroll date, which is critical for payment processing. For example, to retrieve the active direct deposit details for a specific assignment, a query would join to PAY_EXTERNAL_ACCOUNTS and filter by effective dates. Reporting use cases include auditing payment method changes over time, listing all employees using a specific bank, or validating payment method coverage before a payroll run. Support teams often query this table to troubleshoot payment issues by checking the effective dates, priority, and amount/percentage splits configured for an employee.

Sample SQL to find active payment methods for an assignment:

SELECT ppmf.* FROM pay_personal_payment_methods_f ppmf WHERE ppmf.assignment_id = :p_assignment_id AND SYSDATE BETWEEN ppmf.effective_start_date AND ppmf.effective_end_date ORDER BY ppmf.priority;

Related Objects

PAY_PERSONAL_PAYMENT_METHODS_F has key relationships with other EBS payroll objects. As per the provided metadata, it holds foreign keys to:

  • HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID, for business group context.
  • PAY_EXTERNAL_ACCOUNTS via EXTERNAL_ACCOUNT_ID, for bank account details.

Additionally, it is closely related to:

  • PER_ALL_ASSIGNMENTS_F: The source of ASSIGNMENT_ID, linking the payment method to an employee's job.
  • PAY_ORG_PAYMENT_METHODS_F: The source of ORG_PAYMENT_METHOD_ID, defining the valid payment types for an organization.
  • PAY_PRE_PAYMENTS: May reference this table during the payroll run to determine payment distribution.
  • Key APIs: Processes like payroll calculations and payment instructions will read from this table, and maintenance is typically performed via dedicated Oracle Payroll APIs rather than direct DML.