Search Results psp_distribution_lines_arch_pk

Overview

The PSP_DISTRIBUTION_LINES_ARCH table is a core data object within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It serves as the historical archive for distribution lines, which are the detailed accounting breakdowns of labor costs. When distribution lines are modified, purged, or otherwise processed out of the primary transactional table (PSP_DISTRIBUTION_LINES), their historical records are preserved in this archive. This table is critical for maintaining a complete audit trail of labor cost allocations over time, supporting compliance, historical reporting, and reconciliation processes without cluttering active transactional tables.

Key Information Stored

The table's primary purpose is to store a historical snapshot of distribution line details. While the full column list is not provided in the excerpt, the structure is centered on the DISTRIBUTION_LINE_ID column, which is the table's primary key. This identifier uniquely defines each archived record. Typically, an archive table like this would also contain all the critical data from the original distribution line, such as the assignment ID, project accounting date, GL code combination (account), percentage or amount of distribution, and the source batch information. Crucially, it would also include metadata about the archival event itself, such as the archive date or the process that triggered the move from the live table.

Common Use Cases and Queries

The primary use case is auditing and historical reporting on labor cost distributions. Financial auditors may query this table to verify the complete history of cost allocations for a specific project or employee. Another common scenario is troubleshooting, where analysts need to reconstruct the state of distributions at a past point in time. A typical query pattern involves filtering by the source assignment or project to see all historical distributions.

Sample Query Pattern:
SELECT * FROM PSP.PSP_DISTRIBUTION_LINES_ARCH WHERE DISTRIBUTION_LINE_ID = :1;
This query retrieves the full archived record for a specific distribution line, which is essential for detailed audit inquiries. For broader analysis, queries often join to related project or assignment tables using foreign keys to provide context like employee name or project number.

Related Objects

Based on the provided relationship data, the table has a defined primary key constraint (PSP_DISTRIBUTION_LINES_ARCH_PK) on the DISTRIBUTION_LINE_ID column. The most direct relationship is with the active transactional table, PSP_DISTRIBUTION_LINES, from which records are sourced. The DISTRIBUTION_LINE_ID in the archive table would typically correspond to the same ID in the live table before archival. Other related objects would include the core labor distribution setup and transaction tables, such as PSP_ASSIGNMENTS and PSP_PAYROLL_DISTRIBUTIONS, which provide the source context for the archived distribution lines. Reports and interfaces that pull historical labor data will reference this archive table.