Search Results psp_summary_lines




Overview
Explore in AI Chat

Overview

The PSP_SUMMARY_LINES table is a core data repository within the Oracle E-Business Suite Labor Distribution module (PSP). It serves as the central table for storing aggregated and summarized labor cost distribution data. Its primary role is to act as a consolidation point, holding the calculated results of labor distribution runs before they are transferred to the General Ledger (GL) or interfaced with Oracle Projects. The table is fundamental to the payroll costing process, enabling the review, adjustment, and final posting of summarized labor expenses against specific projects, tasks, and accounts.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships, which dictate the critical data elements it contains. The primary identifier is the SUMMARY_LINE_ID. Each record is fundamentally linked to a specific payroll distribution run via the PAYROLL_CONTROL_ID, which references PSP_PAYROLL_CONTROLS. The core accounting and project dimensions are stored through foreign keys: the PROJECT_ID (PA_PROJECTS_ALL), TASK_ID (PA_TASKS), and EXPENDITURE_TYPE (PA_EXPENDITURE_TYPES). The financial dimension is captured by the GL_CODE_COMBINATION_ID, linking to the accounting flexfield. Organizational context is provided by EXPENDITURE_ORGANIZATION_ID (HR_ALL_ORGANIZATION_UNITS), and the accounting period is defined by TIME_PERIOD_ID (PER_TIME_PERIODS). The table also stores the monetary amounts (e.g., quantity, raw cost, burdened cost) that are summarized for these specific dimension combinations.

Common Use Cases and Queries

A primary use case is auditing and reconciling labor distribution before journal import to GL. Analysts query this table to verify total costs by project, organization, or account for a given payroll period. Another critical scenario involves investigating adjustments, where summary lines are traced to their underlying detailed distribution or adjustment records. Common SQL patterns include joining to descriptive tables from Projects and General Ledger to produce readable reports.

  • Summarizing costs by project for a payroll run: SELECT sl.project_id, p.segment1 project_number, SUM(sl.raw_cost) FROM psp_summary_lines sl, pa_projects_all p WHERE sl.payroll_control_id = :p_payroll_id AND sl.project_id = p.project_id GROUP BY sl.project_id, p.segment1;
  • Listing summary lines ready for GL transfer: SELECT * FROM psp_summary_lines WHERE payroll_control_id = :p_payroll_id AND set_of_books_id = :p_sob_id;
  • Tracing from a summary line to its detailed distributions: SELECT * FROM psp_distribution_lines WHERE summary_line_id = :p_summary_line_id;

Related Objects

PSP_SUMMARY_LINES has extensive relationships, acting as a parent table for detailed transactional data and a child table for master and control data. The documented foreign key relationships are as follows:

These relationships illustrate the table's pivotal position: it receives control parameters from parent tables and feeds summarized results into various line-level tables for processing and historical tracking.