Search Results psp_schedule_lines




Overview
Explore in AI Chat

Overview

The PSP_SCHEDULE_LINES table is a core data object within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It functions as the detailed transactional repository for individual distribution lines that constitute a labor schedule. A schedule, defined at a higher level, contains one or more schedule lines that specify precisely how an employee's salary or labor costs are to be allocated across various accounting dimensions, such as projects, tasks, and general ledger accounts. This table is critical for the accurate and auditable proration of labor expenses, enabling organizations to meet complex internal and external reporting requirements for project accounting, grants management, and financial compliance.

Key Information Stored

Each record in PSP_SCHEDULE_LINES represents a single allocation rule for a schedule. The primary identifier is the SCHEDULE_LINE_ID. The table's structure is defined by its extensive foreign key relationships, which map to the key accounting flexfields and master data within EBS. The most significant columns store references to the accounting segments and entities for distribution, including GL_CODE_COMBINATION_ID for the target general ledger account, PROJECT_ID and TASK_ID for project-related allocations, and EXPENDITURE_TYPE. It also holds organizational context via BUSINESS_GROUP_ID and EXPENDITURE_ORGANIZATION_ID, and the accounting context via SET_OF_BOOKS_ID. Additional columns typically store the allocation percentage or amount for the line, effective dates, and creation/modification metadata.

Common Use Cases and Queries

The primary use case is the creation, review, and audit of labor distribution schedules. Functional users manage these lines through the Labor Distribution forms, while technical consultants and report developers query this table to analyze distribution patterns, troubleshoot allocation issues, and build custom reports. A common reporting query involves joining PSP_SCHEDULE_LINES to related master tables to produce a human-readable schedule detail report.

Sample SQL Pattern:

  • SELECT sl.schedule_line_id,
  • p.segment1 project_number,
  • t.task_number,
  • sl.expenditure_type,
  • sl.percentage
  • FROM psp_schedule_lines sl,
  • pa_projects_all p,
  • pa_tasks t
  • WHERE sl.project_id = p.project_id
  • AND sl.task_id = t.task_id
  • AND sl.schedule_hierarchy_id = :p_schedule_id;

Related Objects

PSP_SCHEDULE_LINES sits at the center of a key data model. It is a child table of PSP_SCHEDULE_HIERARCHY, which defines the parent schedule header. Its distribution rules are executed to create actual accounting entries, which are stored in the child tables PSP_DISTRIBUTION_LINES (for current distributions) and PSP_DISTRIBUTION_LINES_HISTORY. As indicated by its foreign keys, it has direct dependencies on fundamental EBS tables including GL_CODE_COMBINATIONS, PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_TYPES, HR_ALL_ORGANIZATION_UNITS (twice, for different organization contexts), and GL_SETS_OF_BOOKS. Any customization or data fix involving labor distributions must carefully consider integrity with these related objects.