Search Results psp_adjustment_lines_arch

Overview

The PSP_ADJUSTMENT_LINES_ARCH table is a core data repository within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It functions as a historical archive for adjustment lines, which are the individual debit and credit entries created when users modify posted labor cost distributions. This table is critical for maintaining a complete, auditable trail of all adjustments made to labor costs over time. Its role is to preserve the final state of an adjustment line after the associated adjustment batch is approved and posted, ensuring data integrity for compliance, reporting, and historical analysis without cluttering the primary transactional tables.

Key Information Stored

As per the provided ETRM metadata, the table's primary organizational key is the ADJUSTMENT_LINE_ID column, which uniquely identifies each archived adjustment line entry. While the full column list is not detailed in the excerpt, the structure typically mirrors its operational counterpart (PSP_ADJUSTMENT_LINES) and includes essential attributes such as the associated ADJUSTMENT_ID (linking to the parent batch), the original EFFORT_REPORT_ID and LINE_NUM being adjusted, accounting flexfields (CODE_COMBINATION_ID), adjusted amounts, and the period and date of the adjustment. The archival process captures the complete financial and descriptive context of the adjustment as it was finalized.

Common Use Cases and Queries

This table is primarily accessed for audit inquiries, historical reporting, and reconciliation. A common scenario involves tracing the complete history of adjustments applied to a specific labor distribution line or project task. Financial auditors may query this table to verify the sequence and authorization of cost transfers. Sample SQL patterns often join to related project and accounting tables to produce meaningful reports.

• Finding all archived adjustments for a specific project: SELECT * FROM PSP_ADJUSTMENT_LINES_ARCH arch, PSP_ADJUSTMENTS adj WHERE arch.ADJUSTMENT_ID = adj.ADJUSTMENT_ID AND adj.PROJECT_ID = :p_project_id;
• Audit trail for a specific original distribution line: SELECT * FROM PSP_ADJUSTMENT_LINES_ARCH WHERE EFFORT_REPORT_ID = :p_er_id AND ORIGINAL_LINE_NUM = :p_line_num ORDER BY CREATION_DATE;

Related Objects

The primary documented relationship for PSP_ADJUSTMENT_LINES_ARCH is its primary key constraint, PSP_ADJUSTMENT_LINES_ARCH_PK, on the ADJUSTMENT_LINE_ID column. This table is a historical snapshot, so its most critical relationship is to the active PSP_ADJUSTMENT_LINES table, from which records are sourced upon batch posting. It is also intrinsically related to the PSP_ADJUSTMENTS table (and its archive, PSP_ADJUSTMENTS_ARCH) via the ADJUSTMENT_ID foreign key, which links each line to its parent adjustment batch. For reporting, it is commonly joined to project accounting tables (PA_PROJECTS, PA_TASKS) and the general ledger tables (GL_CODE_COMBINATIONS) to resolve IDs into descriptive values.