Search Results psp_adjustment_lines_history




Overview
Explore in AI Chat

Overview

The PSP_ADJUSTMENT_LINES_HISTORY table is a core data repository within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). Its primary function is to serve as an audit and historical archive for payroll cost distribution lines that have been successfully adjusted and transferred to the General Ledger (GL). When labor costs are redistributed across different projects, tasks, or accounts via the Labor Distribution process, the original and adjusted distribution details are captured. This table stores the final, transferred state of these adjusted lines, providing a permanent record for compliance, reconciliation, and reporting purposes in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure captures the complete context of a labor cost adjustment. The primary key is ADJUSTMENT_LINE_ID, which uniquely identifies each historical record. Critical columns include PAYROLL_CONTROL_ID, linking to the specific payroll run; SUMMARY_LINE_ID and EFFORT_REPORT_ID, connecting to the source labor data; and ADJUSTMENT_BATCH_NAME, referencing the batch that processed the adjustment. It stores the financial dimensions of the adjustment, such as PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, and the final GL_CODE_COMBINATION_ID. The SET_OF_BOOKS_ID, BUSINESS_GROUP_ID, and TIME_PERIOD_ID provide essential organizational and accounting period context. Amount fields, though not explicitly listed in the provided metadata, are typically present in such history tables to record the adjusted labor distribution values.

Common Use Cases and Queries

This table is central to audit trails and troubleshooting in Labor Distribution. Common use cases include reconciling transferred payroll costs to the General Ledger, investigating the history of adjustments for a specific project or employee, and generating compliance reports. A typical query might join to related master tables to produce a readable adjustment history report.

  • Sample Query for Adjustment Audit:
    SELECT hist.ADJUSTMENT_BATCH_NAME, hist.TIME_PERIOD_ID, proj.SEGMENT1 PROJECT_NUMBER,
    tasks.TASK_NUMBER, hist.EXPENDITURE_TYPE, hist.GL_CODE_COMBINATION_ID
    FROM PSP.PSP_ADJUSTMENT_LINES_HISTORY hist,
    PA.PA_PROJECTS_ALL proj,
    PA.PA_TASKS tasks
    WHERE hist.PROJECT_ID = proj.PROJECT_ID
    AND hist.TASK_ID = tasks.TASK_ID
    AND hist.TIME_PERIOD_ID = 'JAN-2024';
  • Reconciliation: Comparing aggregate amounts in this history table to journal entries in GL_INTERFACE or GL_JE_BATCHES for a given payroll control.
  • Data Integrity: Using the foreign key relationships to validate that all historical records have valid references to existing projects, tasks, and code combinations.

Related Objects

The PSP_ADJUSTMENT_LINES_HISTORY table is intricately linked to numerous master and transactional tables across EBS, as evidenced by its foreign key constraints. Key relationships include: