Search Results psp_adjustment_lines




Overview
Explore in AI Chat

Overview

The PSP_ADJUSTMENT_LINES table is a core transactional data store within the Oracle E-Business Suite Labor Distribution module (PSP). It serves as the central repository for recording and managing adjustments to labor cost distributions. The table's primary role is to store both the original expenditure line data and the proposed new distribution lines that result from effort reporting, cost transfers, or manual adjustments. This enables the system to maintain a complete audit trail of changes before they are finalized and posted to the General Ledger and Projects modules, ensuring data integrity and compliance in financial reporting.

Key Information Stored

The table's structure is defined by its primary key, ADJUSTMENT_LINE_ID, and a comprehensive set of foreign keys that link it to major EBS entities. Key columns include EFFORT_REPORT_ID and VERSION_NUM, which tie the adjustment to a specific effort certification cycle. The SUMMARY_LINE_ID links back to the source summarized payroll data. Critical accounting and project-tracking attributes are stored, such as SET_OF_BOOKS_ID, GL_CODE_COMBINATION_ID, PROJECT_ID, and TASK_ID. The table also holds the PAYROLL_CONTROL_ID, SOURCE_TYPE, STATUS_CODE, and TIME_PERIOD_ID to manage the adjustment's payroll context and processing workflow. The BATCH_NAME column associates individual lines with a larger adjustment batch controlled via the PSP_ADJUSTMENT_CONTROL_TABLE.

Common Use Cases and Queries

The primary use case is generating reports and conducting analyses on pending or historical labor cost adjustments. Common queries involve joining to related master data tables to produce human-readable audit reports. For instance, to analyze all adjustment lines for a specific project, one might query PSP_ADJUSTMENT_LINES joined to PA_PROJECTS_ALL and PSP_EFFORT_REPORTS. Another frequent scenario is troubleshooting adjustments stuck in a particular status by filtering on the STATUS_CODE column. Support personnel often query this table to verify the accounting flexfield (GL_CODE_COMBINATION_ID) or project/task details before an adjustment batch is posted. Sample SQL often follows this pattern:

  • SELECT pal.adjustment_line_id, pal.project_id, ppa.segment1 project_number, pal.status_code FROM psp_adjustment_lines pal, pa_projects_all ppa WHERE pal.project_id = ppa.project_id AND pal.effort_report_id = :p_report_id;

Related Objects

PSP_ADJUSTMENT_LINES has extensive foreign key relationships, integrating it deeply with the EBS financial, projects, and human resources architecture. Key documented relationships include: