Search Results pa_org_labor_sch_rule




Overview
Explore in AI Chat

Overview

The PA_ORG_LABOR_SCH_RULE table is a core configuration table within the Oracle E-Business Suite Projects (PA) module, specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for defining and storing the linkage between an organization and the specific labor costing and scheduling rules that govern its project-related activities. Its primary role is to establish the business rules for how labor costs are calculated and which rate schedules are applied for employees belonging to a given organization. This configuration is fundamental for accurate project costing, payroll integration, and financial reporting, ensuring labor transactions are processed consistently according to predefined organizational policies.

Key Information Stored

While the full column list is not detailed in the provided metadata, the foreign key relationships and table description clearly indicate the critical data elements stored. Each record uniquely associates an organization with its costing and scheduling parameters. The primary key is ORG_LABOR_SCH_RULE_ID. Essential foreign key columns include ORGANIZATION_ID, which links to HR_ALL_ORGANIZATION_UNITS to identify the specific organization. The LABOR_COSTING_RULE column references PA_COMPENSATION_RULE_SETS, defining the set of rules for calculating labor costs. For overtime processing, the OVERTIME_PROJECT_ID and OVERTIME_TASK_ID columns link to PA_PROJECTS_ALL and PA_TASKS, respectively, specifying the default project and task for booking overtime hours. The ORG_ID column links to PA_IMPLEMENTATIONS_ALL for multi-org support.

Common Use Cases and Queries

This table is primarily accessed during the setup and maintenance of project costing rules and during transaction processing. A common operational use case is validating the labor costing rule assigned to an employee's organization when a labor cost distribution line is created. For reporting and analysis, administrators often query this table to audit organizational costing setups. A typical SQL query would join this table to related setup tables to list all organizational assignments.

  • Sample Query for Organizational Rule Audit:
    SELECT hr.name organization_name,
    pcr.rule_set_name,
    polsr.organization_id,
    polsr.labor_costing_rule
    FROM pa_org_labor_sch_rule polsr,
    hr_all_organization_units hr,
    pa_compensation_rule_sets pcr
    WHERE polsr.organization_id = hr.organization_id
    AND polsr.labor_costing_rule = pcr.rule_set_id
    AND polsr.org_id = :p_org_id;

Related Objects

The PA_ORG_LABOR_SCH_RULE table maintains integral relationships with several key EBS tables, as documented by its foreign key constraints.

  • Referenced By This Table (Outgoing Foreign Keys):
    • HR_ALL_ORGANIZATION_UNITS via ORGANIZATION_ID: Identifies the organization unit.
    • PA_IMPLEMENTATIONS_ALL via ORG_ID: Provides multi-org context.
    • PA_COMPENSATION_RULE_SETS via LABOR_COSTING_RULE: Defines the labor costing rule set.
    • PA_PROJECTS_ALL via OVERTIME_PROJECT_ID: Specifies the default overtime project.
    • PA_TASKS via OVERTIME_TASK_ID: Specifies the default overtime task.
  • References This Table (Incoming Foreign Keys):