Search Results pay_accrual_plans

Overview

The PAY_ACCRUAL_PLANS table is a core data object within the Oracle E-Business Suite Payroll module (PAY). It serves as the master definition table for Paid Time Off (PTO) accrual plans. An accrual plan defines the rules and policies by which employees earn time off, such as vacation or sick leave, based on factors like length of service, employment terms, or hours worked. This table is foundational to the accrual functionality in both Oracle EBS 12.1.1 and 12.2.2, storing the high-level plan parameters that are then referenced by detailed calculation rules, bands, and employee assignments to govern the automated accrual of leave liabilities.

Key Information Stored

The table's primary key is ACCRUAL_PLAN_ID, which uniquely identifies each plan. Key descriptive and configuration columns include the PLAN_NAME and DESCRIPTION. Critical foreign key relationships are established via BUSINESS_GROUP_ID, which links the plan to a specific HR organization unit, enforcing data security. Other significant columns define the plan's operational characteristics, such as its start and end dates (EFFECTIVE_START_DATE, EFFECTIVE_END_DATE), the accrual category (e.g., vacation, sick), the method of accrual (e.g., flat amount, formula-based), and the payroll frequency for accrual calculations. The table also holds flags controlling plan behavior, like whether unused balances are carried over or paid out.

Common Use Cases and Queries

This table is central to reporting, auditing, and data integration tasks. Common scenarios include generating a list of all active accrual plans within a business group for audit purposes, or identifying plans linked to a specific payroll. A typical query would join PAY_ACCRUAL_PLANS to HR_ALL_ORGANIZATION_UNITS to report plans by business group. For technical support, queries often trace plan definitions to detailed calculation rules or employee balances. Sample SQL to retrieve active plans is:

• SELECT plan_name, description, business_group_id
• FROM pay_accrual_plans
• WHERE SYSDATE BETWEEN effective_start_date AND NVL(effective_end_date, SYSDATE)
• AND business_group_id = :p_bg_id;

Data from this table is also essential for custom reports analyzing accrued liability trends or validating plan setup during implementations.

Related Objects

PAY_ACCRUAL_PLANS has defined relationships with several key payroll objects, as indicated by the foreign keys. PAY_ACCRUAL_BANDS stores tiered accrual rates (e.g., different rates per years of service) that are linked to a parent plan via ACCRUAL_PLAN_ID. PAY_NET_CALCULATION_RULES holds the specific formulas or rules for calculating the net accrual amount per period. The table is referenced by PAY_ACCRUAL_PLAN_ENTRIES, which assigns employees to plans, and PAY_RUN_RESULTS and PAY_ACCRUAL_BALANCES, which store the calculated outcomes. For programmatic access and data integrity, key APIs such as PAY_ACCRUAL_PLAN_API are used to create and maintain plan definitions instead of direct DML operations.