Search Results pa_comp_rule_ot_defaults_all




Overview
Explore in AI Chat

Overview

The PA_COMP_RULE_OT_DEFAULTS_ALL table is a core repository within the Oracle E-Business Suite Projects module (PA). It is a multi-organization table that stores the default project and task assignments designated for overtime hours processed under a specific Labor Costing Rule. This table plays a critical role in the automated costing and accounting of overtime labor. When a compensation rule is applied to overtime transactions, the system references this table to determine the appropriate project and task to which the overtime costs should be charged, ensuring accurate project accounting and financial reporting without requiring manual entry for each transaction.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships, which dictate the essential data it holds. The primary key is a composite of COMPENSATION_RULE_SET and ORG_ID, enforcing uniqueness for a rule within an operating unit. The critical foreign key columns define the relationships that give the table its purpose. The COMPENSATION_RULE_SET column links to a specific compensation rule set defined in PA_COMPENSATION_RULE_SETS. The PROJECT_ID and TASK_ID columns store the identifiers for the default project (from PA_PROJECTS_ALL) and task (from PA_TASKS) to be used for overtime costing. The ORG_ID column provides multi-org support, segregating data by operating unit.

Common Use Cases and Queries

The primary use case is the automated back-end assignment of project and task details during the costing of overtime payroll transactions. Administrators configure these defaults via the Oracle Projects compensation rule setup. Common queries involve auditing and reporting on these configurations. A typical SQL pattern retrieves the rule and its associated default charge account details:

  • SELECT crs.rule_set_name, proj.segment1 project_number, task.task_number, dflt.org_id FROM pa_comp_rule_ot_defaults_all dflt, pa_compensation_rule_sets crs, pa_projects_all proj, pa_tasks task WHERE dflt.compensation_rule_set = crs.compensation_rule_set AND dflt.project_id = proj.project_id AND dflt.task_id = task.task_id AND dflt.org_id = proj.org_id ORDER BY crs.rule_set_name;

This data is also vital for troubleshooting when overtime costs are posted to an unexpected project or task, allowing support personnel to verify the configured defaults.

Related Objects

This table maintains integral relationships with several key Projects module tables, as documented by its foreign keys:

  • PA_COMPENSATION_RULE_SETS: Linked via the COMPENSATION_RULE_SET column. This is the parent table defining the rule set for which the overtime defaults are specified. The relationship is listed twice in the metadata, likely indicating a composite or multi-column key dependency.
  • PA_PROJECTS_ALL: Linked via the PROJECT_ID column. This provides the valid project to which overtime costs will default.
  • PA_TASKS: Linked via the TASK_ID column. This provides the specific task identifier under the default project for the overtime charge.

These relationships ensure data integrity, guaranteeing that the default project and task references are valid and that the overtime rule set exists before defaults can be assigned to it.

  • Table: PA_COMP_RULE_OT_DEFAULTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_COMP_RULE_OT_DEFAULTS_ALL,  object_name:PA_COMP_RULE_OT_DEFAULTS_ALL,  status:VALID,  product: PA - Projects ,  description: This table stores the overtime default project and task details for a Labor costing rule. ,  implementation_dba_data: PA.PA_COMP_RULE_OT_DEFAULTS_ALL , 

  • Table: PA_COMP_RULE_OT_DEFAULTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_COMP_RULE_OT_DEFAULTS_ALL,  object_name:PA_COMP_RULE_OT_DEFAULTS_ALL,  status:VALID,  product: PA - Projects ,  description: This table stores the overtime default project and task details for a Labor costing rule. ,  implementation_dba_data: PA.PA_COMP_RULE_OT_DEFAULTS_ALL , 

  • Table: PA_COMPENSATION_RULE_SETS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_COMPENSATION_RULE_SETS,  object_name:PA_COMPENSATION_RULE_SETS,  status:VALID,  product: PA - Projects ,  description: Implementation-defined classifications of employee compensation (also referred to as pay types) ,  implementation_dba_data: PA.PA_COMPENSATION_RULE_SETS , 

  • Table: PA_COMPENSATION_RULE_SETS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_COMPENSATION_RULE_SETS,  object_name:PA_COMPENSATION_RULE_SETS,  status:VALID,  product: PA - Projects ,  description: Implementation-defined classifications of employee compensation (also referred to as pay types) ,  implementation_dba_data: PA.PA_COMPENSATION_RULE_SETS , 

  • Table: PA_TASKS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASKS,  object_name:PA_TASKS,  status:VALID,  product: PA - Projects ,  description: User-defined subdivisions of project work ,  implementation_dba_data: PA.PA_TASKS , 

  • Table: PA_TASKS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_TASKS,  object_name:PA_TASKS,  status:VALID,  product: PA - Projects ,  description: User-defined subdivisions of project work ,  implementation_dba_data: PA.PA_TASKS , 

  • Table: PA_PROJECTS_ALL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL , 

  • Table: PA_PROJECTS_ALL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECTS_ALL,  object_name:PA_PROJECTS_ALL,  status:VALID,  product: PA - Projects ,  description: PA_PROJECTS_ALL stores the highest units of work defined in Oracle Projects. ,  implementation_dba_data: PA.PA_PROJECTS_ALL ,