Search Results psp_distribution_interface




Overview
Explore in AI Chat

Overview

The PSP_DISTRIBUTION_INTERFACE table is a core interface table within the Oracle E-Business Suite Labor Distribution module (PSP). It functions as a staging area for labor cost distribution lines that originate from pre-generated sources before they are processed and transferred to the General Ledger. Its primary role is to hold detailed distribution data, most commonly sourced from timecards processed through Oracle Time & Labor (OTL), enabling validation, adjustment, and batch processing prior to final journal creation. This table is integral to the labor costing workflow in both EBS 12.1.1 and 12.2.2, acting as the critical link between captured time and accounted labor expenses.

Key Information Stored

The table stores a comprehensive record for each distribution line, keyed by a unique DISTRIBUTION_INTERFACE_ID. Critical columns define the accounting and project dimensions of the labor cost. These include SET_OF_BOOKS_ID for the ledger, GL_CODE_COMBINATION_ID for the accounting flexfield, and TIME_PERIOD_ID for the accounting period. For project-related costing, it holds PROJECT_ID and TASK_ID from Oracle Projects, along with EXPENDITURE_TYPE and EXPENDITURE_ORGANIZATION_ID. The table also stores the monetary AMOUNT and quantity (HOURS or UNITS) of the distribution, a PROCESS_STATUS to track its lifecycle (e.g., 'U' for unprocessed, 'P' for processed), and references to the source transaction, such as a batch name or source document identifier.

Common Use Cases and Queries

A primary use case is troubleshooting the labor distribution process. Consultants often query for lines stuck in an error state or with a specific process status to identify load or validation failures. Common reporting needs include summarizing labor costs by project, task, or account for a given period before journal posting. Sample SQL patterns include status checks and project expenditure summaries:

  • SELECT distribution_interface_id, process_status, error_message FROM psp_distribution_interface WHERE process_status = 'E';
  • SELECT project_id, task_id, expenditure_type, SUM(amount) FROM psp_distribution_interface WHERE time_period_id = 12345 AND set_of_books_id = 1 GROUP BY project_id, task_id, expenditure_type;

Data in this table is typically populated by the Labor Distribution pre-generation process and is consumed by the Labor Distribution transfer to GL process, which creates journal entries and updates the status accordingly.

Related Objects

As indicated by its foreign keys, PSP_DISTRIBUTION_INTERFACE has strong dependencies on fundamental EBS tables. It references GL_CODE_COMBINATIONS for the account, PA_PROJECTS_ALL and PA_TASKS for project details, PA_EXPENDITURE_TYPES, HR_ALL_ORGANIZATION_UNITS, PER_TIME_PERIODS, and GL_SETS_OF_BOOKS. Crucially, it is the parent table for PSP_PRE_GEN_DIST_LINES and PSP_PRE_GEN_DIST_LINES_HISTORY, which store the individual pre-generated distribution line details that roll up into a single interface record. Key related APIs include the Labor Distribution processes accessible via the PSP_LD_INT_PUB package, which manage the population and processing of this interface table.