Search Results cn_pay_groups_pk

Overview

The CN_PAY_GROUPS_ALL table is a core data object within the Oracle E-Business Suite (EBS) Incentive Compensation (CN) module, specifically in versions 12.1.1 and 12.2.2. It serves as the master repository for defining pay groups. A pay group is a configuration entity that associates a set of pay periods within a defined pay calendar. Its primary role is to establish the payment frequency for salespersons, thereby acting as a fundamental building block for the compensation calculation and payment processing cycle. The table's "ALL" suffix indicates it is a multi-organization enabled table, capable of storing data partitioned by operating unit, which is essential for deployments with multiple legal entities or business units.

Key Information Stored

While the provided metadata does not list specific columns, the primary key and foreign key relationships define its critical structure. The central column is PAY_GROUP_ID, a unique system-generated identifier for each pay group record. Based on its functional description, the table logically stores attributes that define the pay group, such as its name, description, and a link to its associated pay calendar. It also stores the set of pay periods that constitute the group, which determines the payment schedule. The table includes standard Oracle EBS columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and ORG_ID to support audit trails and multi-org architecture.

Common Use Cases and Queries

This table is central to configuring and querying payment schedules. Administrators use it to define how often different sales teams or individuals are paid (e.g., monthly, bi-weekly). A common reporting use case is to list all active pay groups within an operating unit. A typical query would join with related setup tables to provide a comprehensive view. For troubleshooting payment runs, one might query which pay groups are assigned to specific salespersons or compensation plans.

• Basic listing of pay groups: SELECT PAY_GROUP_ID, NAME FROM CN_PAY_GROUPS_ALL WHERE ORG_ID = :org_id ORDER BY NAME;
• Identifying pay groups used in an active pay run: SELECT DISTINCT pg.NAME FROM CN_PAY_GROUPS_ALL pg, CN_PAYRUNS_ALL pr WHERE pg.PAY_GROUP_ID = pr.PAY_GROUP_ID AND pr.STATUS_CODE = 'PENDING';

Related Objects

The CN_PAY_GROUPS_ALL table is a parent entity in key relationships within the Incentive Compensation schema, as documented by its foreign keys.

• CN_PAYRUNS_ALL: This table stores individual payment run instances. It references CN_PAY_GROUPS_ALL via the column CN_PAYRUNS_ALL.PAY_GROUP_ID, linking each payment execution to its governing pay group and schedule.
• CN_SRP_PAY_GROUPS_ALL: This table manages the assignment of pay groups to salespersons (SRP stands for Sales Resource Person). It references CN_PAY_GROUPS_ALL via CN_SRP_PAY_GROUPS_ALL.PAY_GROUP_ID, defining which payment frequency applies to each compensable individual.

The primary key constraint CN_PAY_GROUPS_PK on PAY_GROUP_ID enforces data integrity for these relationships.