Search Results psp_distribution_lines




Overview
Explore in AI Chat

Overview

The PSP_DISTRIBUTION_LINES table is a core data repository within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). Its primary role is to serve as a staging area for payroll cost distribution data before final posting to the General Ledger (GL) or Grants Accounting systems. It stores detailed subline-level distribution records generated from both Oracle Payroll and non-Oracle payroll sources. This table is critical for the labor distribution process, holding transactional data that represents the allocation of payroll expenses across various funding sources, projects, tasks, and accounts based on predefined effort schedules or direct distributions. The data remains in this table until the transfer process successfully moves it to the final accounting destinations.

Key Information Stored

The table's primary key is DISTRIBUTION_LINE_ID, which uniquely identifies each distribution record. Key columns and their purposes include PAYROLL_SUB_LINE_ID, which links to the source payroll transaction in PSP_PAYROLL_SUB_LINES. The EFFORT_REPORT_ID and SCHEDULE_LINE_ID columns connect the distribution to its originating effort certification report and the specific schedule line that dictated the distribution percentages. For summary distributions, the SUMMARY_LINE_ID provides the link. Critical accounting identifiers are also stored, such as SET_OF_BOOKS_ID (linking to GL_SETS_OF_BOOKS), ELEMENT_ACCOUNT_ID (linking to PSP_ELEMENT_TYPE_ACCOUNTS for the earning element's natural account), and BUSINESS_GROUP_ID (linking to HR_ALL_ORGANIZATION_UNITS). The table also holds the distributed amounts, dates, project/task/expenditure type/organization identifiers (Award_ID, etc.), and a VERSION_NUM for tracking changes.

Common Use Cases and Queries

A primary use case is auditing and reconciling payroll costs before they are transferred to the General Ledger. Analysts run queries to verify that distributed totals match source payroll amounts and that all required accounting flexfields are populated. Another common scenario is troubleshooting transfer errors, where distributions remain in this table due to invalid account combinations or closed accounting periods. Sample queries often join to related effort reporting and payroll tables.

Example Query: Find distributions for a specific effort report:
SELECT d.distribution_line_id, d.amount, d.project_id, d.task_id, psl.payroll_name
FROM psp_distribution_lines d,
psp_payroll_sub_lines psl
WHERE d.effort_report_id = :report_id
AND d.payroll_sub_line_id = psl.payroll_sub_line_id
ORDER BY d.distribution_line_id;

Reporting use cases include generating detailed labor distribution journals and analyzing payroll costs by project or organization prior to GL posting.

Related Objects

PSP_DISTRIBUTION_LINES has integral relationships with numerous other EBS objects, primarily through foreign key constraints as documented in the ETRM:

  • PSP_PAYROLL_SUB_LINES: Joined via PAYROLL_SUB_LINE_ID. This is the source payroll transaction.
  • PSP_EFFORT_REPORTS: Joined via EFFORT_REPORT_ID and VERSION_NUM. Links to the certified effort report.
  • PSP_SCHEDULE_LINES: Joined via SCHEDULE_LINE_ID. References the schedule line that determined the distribution percentages.
  • PSP_SUMMARY_LINES: Joined via SUMMARY_LINE_ID. For distributions from summary schedules.
  • GL_SETS_OF_BOOKS: Joined via SET_OF_BOOKS_ID. Identifies the ledger for accounting.
  • PSP_ELEMENT_TYPE_ACCOUNTS: Joined via ELEMENT_ACCOUNT_ID. Provides the default natural account for the earning element.
  • PSP_DEFAULT_LABOR_SCHEDULES: Joined via ORG_SCHEDULE_ID. Links to the organization-level default schedule.
  • HR_ALL_ORGANIZATION_UNITS: Joined via BUSINESS_GROUP_ID. Identifies the HR business group.