Search Results psp_template_organizations




Overview
Explore in AI Chat

Overview

The PSP_TEMPLATE_ORGANIZATIONS table is a core data object within the Oracle E-Business Suite Labor Distribution module (PSP). It functions as a junction table that defines the relationship between Effort Reporting Templates and the specific organizations to which they apply. Its primary role is to store the list of multiple expenditure organizations that are linked to a given template based on defined selection criteria. This linkage is essential for automating and controlling the distribution of labor costs and effort reporting across the enterprise, ensuring that the correct organizational hierarchy and costing rules are applied during payroll and project accounting processes.

Key Information Stored

The table's structure is relatively straightforward, centering on two key foreign key columns that establish its critical relationships. The TEMPLATE_ID column references a specific effort reporting template defined in the PSP_EFFORT_REPORT_TEMPLATES table. The EXPENDITURE_ORGANIZATION_ID column stores the identifier for an organization unit, as defined in the HR_ALL_ORGANIZATION_UNITS table, that is subject to the rules of the linked template. Together, these two columns form the table's primary key (PSP_TEMPLATE_ORGANIZATIONS_PK), enforcing uniqueness and ensuring that a specific organization is only listed once for a given template. This design allows a single template to be efficiently associated with a broad set of organizations.

Common Use Cases and Queries

The primary use case for this table is to support the setup and execution of labor distribution processes. Administrators use it to define the organizational scope of an effort reporting template. A common reporting need is to list all organizations assigned to a particular template for validation or audit purposes. A typical query would join to the related tables for descriptive information:

  • Identifying all organizations for a specific template: SELECT hou.name FROM psp_template_organizations pto, hr_all_organization_units hou WHERE pto.expenditure_organization_id = hou.organization_id AND pto.template_id = :template_id;
  • Finding which template governs a specific organization: SELECT pet.template_name FROM psp_template_organizations pto, psp_effort_report_templates pet WHERE pto.template_id = pet.template_id AND pto.expenditure_organization_id = :org_id;

These associations are critical during payroll runs, where the system uses the template linked via this table to determine the distribution rules for an employee's salary charges based on their assigned organization.

Related Objects

PSP_TEMPLATE_ORGANIZATIONS has direct dependencies on two primary EBS tables, as defined by its foreign key constraints. The TEMPLATE_ID column references the PSP_EFFORT_REPORT_TEMPLATES table, which stores the master definition of the effort reporting template, including its name, type, and effective dates. The EXPENDITURE_ORGANIZATION_ID column references the HR_ALL_ORGANIZATION_UNITS table, the central repository for all organizational structures within Oracle HRMS. This table is a child of PSP_EFFORT_REPORT_TEMPLATES; its data is meaningless without the parent template definition. It may also be referenced by various Labor Distribution reports and interfaces that process expenditure data based on template-organization assignments.