Search Results pay_org_payment_methods_f




Overview
Explore in AI Chat

Overview

The PAY_ORG_PAYMENT_METHODS_F table is a core data structure within the Oracle E-Business Suite Payroll module (PAY). It functions as the master repository defining the valid payment methods available for use within a specific Business Group. A payment method, in this context, refers to the mechanism by which an employee receives compensation, such as direct deposit, check, or cash. This table establishes the authorized list of these methods for a given organization and links them to the underlying financial and balance definitions required for payroll processing. Its role is foundational, as it governs the payment options that can be assigned to individual employee assignments, thereby directly influencing payroll execution and reporting.

Key Information Stored

The table is date-effective, utilizing EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns to manage historical changes over time. Its primary key is a combination of ORG_PAYMENT_METHOD_ID and EFFECTIVE_START_DATE. The most critical columns define the method's context and configuration. The BUSINESS_GROUP_ID foreign key anchors the method to a specific organizational unit. The PAYMENT_TYPE_ID links to the PAY_PAYMENT_TYPES table to define the method's category (e.g., Check, Direct Deposit). For electronic payments, the EXTERNAL_ACCOUNT_ID may link to the PAY_EXTERNAL_ACCOUNTS table to specify a default bank account. A significant column is DEFINED_BALANCE_ID, which creates a mandatory link to the PAY_DEFINED_BALANCES table. This link is crucial for payroll accounting, as it identifies the specific balance that tracks the payment amounts distributed via this method, ensuring accurate gross-to-net calculations and liability postings.

Common Use Cases and Queries

This table is central to payroll setup and inquiry. A common operational use case is generating a list of all active payment methods for a business group to validate assignment setups. For reporting, it is frequently joined to employee assignment data to analyze payment method distribution. Technical support often queries this table to diagnose payment calculation or balance issues by tracing the defined balance linkage. A typical query pattern retrieves active methods for a business group:

  • SELECT org_payment_method_id, payment_type_id, defined_balance_id
  • FROM pay_org_payment_methods_f
  • WHERE business_group_id = &bg_id
  • AND SYSDATE BETWEEN effective_start_date AND effective_end_date;

Another critical query joins to PAY_DEFINED_BALANCES and related balance dimensions to understand the full accounting impact of a payment method.

Related Objects

As indicated by its foreign keys, PAY_ORG_PAYMENT_METHODS_F has strong dependencies on several key payroll tables. HR_ALL_ORGANIZATION_UNITS provides the Business Group context. PAY_PAYMENT_TYPES supplies the method type classification. PAY_EXTERNAL_ACCOUNTS holds details for electronic fund transfer. The most significant relationship is with PAY_DEFINED_BALANCES, which is essential for financial tracking. This table is a parent to assignment-level payment method details, which are typically stored in tables such as PAY_PERSONAL_PAYMENT_METHODS_F. It is also referenced by payroll calculation engines and APIs that validate and process payments, making it a vital component in the payroll data model.