Search Results pay_consolidation_sets




Overview
Explore in AI Chat

Overview

The PAY_CONSOLIDATION_SETS table is a core data object within the Oracle E-Business Suite Payroll module (PAY). It serves as the master definition table for consolidation sets, which are logical groupings used to combine the results of multiple payroll runs for reporting, costing, and payment purposes. A consolidation set typically aggregates payroll results from different payrolls, legal entities, or business groups into a single, unified dataset, enabling streamlined third-party payments, bank transfers, and consolidated reporting. Its role is fundamental to the post-processing phase of payroll, acting as a control structure that links related payroll actions for consolidated output generation.

Key Information Stored

The table stores the defining attributes for each unique consolidation set. The primary column is CONSOLIDATION_SET_ID, which is the unique identifier and primary key. A critical foreign key is BUSINESS_GROUP_ID, which links the consolidation set to a specific business group (HR_ALL_ORGANIZATION_UNITS), enforcing data security at the Business Group level. While the provided ETRM excerpt does not list all columns, typical columns in this table would include the consolidation set NAME, relevant ENABLED or STATUS flags, and creation metadata (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY). The structure ensures each set is uniquely defined within its operational business group context.

Common Use Cases and Queries

The primary use case is identifying which payroll runs belong to a specific consolidation for auditing or troubleshooting. For instance, a common query retrieves all payroll actions consolidated within a named set:

  • SELECT pa.consolidation_set_id, pcs.name, pa.payroll_action_id, pa.action_type FROM pay_payroll_actions pa, pay_consolidation_sets pcs WHERE pa.consolidation_set_id = pcs.consolidation_set_id AND pcs.name = '&CONS_SET_NAME';

Another routine use is validating setup, such as listing all consolidation sets defined for a business group to ensure proper configuration for period-end processing. Reporting often joins this table to PAY_PAYROLL_ACTIONS and PAY_ALL_PAYROLLS_F to trace consolidated results back to their source payrolls and execution details.

Related Objects

As indicated by the foreign key relationships, PAY_CONSOLIDATION_SETS is centrally linked to several key payroll tables. The table PAY_ALL_PAYROLLS_F references it via CONSOLIDATION_SET_ID, defining which payroll is assigned to which consolidation set. More critically, the PAY_PAYROLL_ACTIONS table holds a foreign key to it, meaning each payroll run (action) that is part of a consolidated process is explicitly linked to a specific consolidation set. The table itself references HR_ALL_ORGANIZATION_UNITS via BUSINESS_GROUP_ID. These relationships underscore its role as a control table that orchestrates the consolidation of payroll results generated by multiple payroll actions across defined payrolls.