Search Results payroll_interface_id

Overview

The PSP_PAYROLL_INTERFACE table is a core staging table within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). Its primary function is to serve as a data repository for payroll cost information originating from external, non-Oracle payroll systems. This table facilitates the critical process of importing payroll sublines—detailed cost allocations for employee earnings—into the Oracle Labor Distribution system. Once imported and validated, this data is used to generate accounting entries for posting to the General Ledger (GL), ensuring payroll costs are accurately distributed across projects, tasks, and expenditure organizations.

Key Information Stored

The table stores detailed transactional payroll data to be processed. Key columns include a system-generated primary key, PAYROLL_INTERFACE_ID, and BATCH_NAME for grouping and controlling the import process. Critical linkage columns are ASSIGNMENT_ID (relating to the employee assignment), PAYROLL_PERIOD_ID (foreign key to PER_TIME_PERIODS), and ELEMENT_TYPE_ID (identifying the earnings type). The SUB_LINE_START_DATE and SUB_LINE_END_DATE columns define the specific period for the cost allocation. Essential financial data columns typically include the costed amount, hours, and the accounting flexfield combination (CODE_COMBINATION_ID) to which the cost should be charged. The SET_OF_BOOKS_ID column, a foreign key to GL_SETS_OF_BOOKS, is crucial for ensuring the data is processed within the correct financial ledger context.

Common Use Cases and Queries

The primary use case is the execution and troubleshooting of the "Import Payroll Costing" process. Administrators load data into this table via custom interfaces or scripts, then run the standard import program. Common queries involve monitoring batch status, identifying errors, and validating data integrity before submission. For example:

• Identifying unprocessed records for a specific batch: SELECT * FROM psp_payroll_interface WHERE batch_name = '&BATCH_NAME' AND processed_flag IS NULL;
• Summarizing costs by project and task for validation: SELECT project_id, task_id, SUM(costed_amount) FROM psp_payroll_interface WHERE payroll_period_id = &PERIOD_ID GROUP BY project_id, task_id;
• Investigating failed imports by joining to error tables: SELECT pi.*, pe.error_message FROM psp_payroll_interface pi, psp_interface_errors pe WHERE pi.payroll_interface_id = pe.interface_id AND pe.table_name = 'PSP_PAYROLL_INTERFACE';

Related Objects

PSP_PAYROLL_INTERFACE is central to the payroll import workflow and integrates with several key EBS objects. As documented, it holds foreign key relationships to PER_TIME_PERIODS (for validating the payroll period) and GL_SETS_OF_BOOKS (for ledger context). It is the primary source for the "Import Payroll Costing" concurrent program, which likely references standard APIs or packages within the PSP schema. Processed data typically flows into core Labor Distribution tables such as PSP_PAYROLL_LINES. For error handling, records may be referenced in generic interface error tables like PSP_INTERFACE_ERRORS. Direct dependencies on this table are often found in custom data loaders and integration scripts designed to populate it from external payroll systems.