Search Results psp_pre_gen_dist_lines




Overview
Explore in AI Chat

Overview

The PSP_PRE_GEN_DIST_LINES table is a core transactional table within the Oracle E-Business Suite Labor Distribution module (PSP). It serves as a critical staging repository for labor cost distribution lines that have been calculated but are not yet finalized and transferred to the General Ledger (GL) or Grants Accounting (PA) modules. Its primary role is to hold pre-generated distributions in an intermediate state, allowing for validation, correction, and approval workflows before the financial entries are permanently posted. This table is fundamental to the batch processing and audit control of labor distribution, ensuring data integrity between payroll, projects, and the general ledger.

Key Information Stored

The table stores detailed attributes for each pending distribution line. Its primary key is the system-generated PRE_GEN_DIST_LINE_ID. Key transactional columns include the AMOUNT and CURRENCY_CODE for the distribution value, and the STATUS_FLAG indicating the line's processing state. Critical foreign key columns link the distribution to its source and destination, including DISTRIBUTION_INTERFACE_ID (linking to the source payroll batch), SET_OF_BOOKS_ID, and GL_CODE_COMBINATION_ID for the target accounting flexfield. For project-related distributions, it holds PROJECT_ID and TASK_ID. The table also captures organizational context via EXPENDITURE_ORGANIZATION_ID and period information via TIME_PERIOD_ID. The SUSPENSE_ORG_ACCOUNT_ID is pivotal for holding distributions in suspense during error resolution.

Common Use Cases and Queries

A primary use case is troubleshooting distributions that fail to transfer to GL. A common query identifies lines in an error or suspense status for a specific payroll batch or time period. For example: SELECT * FROM PSP.PSP_PRE_GEN_DIST_LINES WHERE DISTRIBUTION_INTERFACE_ID = &batch_id AND STATUS_FLAG = 'ERROR';. Reporting on unposted labor costs by organization or project before period-end close is another critical scenario, often joining to HR_ALL_ORGANIZATION_UNITS and PA_PROJECTS_ALL. Analysts also query this table to validate the accounting rules applied, comparing the GL_CODE_COMBINATION_ID against PSP_ORGANIZATION_ACCOUNTS. Data in this table is typically processed by the "Transfer to General Ledger" concurrent program, which moves approved lines and purges them from this staging table.

Related Objects

PSP_PRE_GEN_DIST_LINES has extensive integration points, as evidenced by its foreign key relationships. It is a central hub connecting labor distribution to other EBS modules:

These relationships underscore its role as the nexus between HR/Payroll, Projects, and Financials.