Search Results psp_adjustment_control_table




Overview
Explore in AI Chat

Overview

The PSP_ADJUSTMENT_CONTROL_TABLE is a core transactional table within the Oracle E-Business Suite (EBS) Labor Distribution module (PSP). It functions as the master control record for adjustment batches. In the context of payroll and project accounting, labor cost distributions often require corrections after initial posting. This table stores the header-level metadata for each distinct batch of such adjustments, enabling systematic tracking, approval, and posting of corrections to the General Ledger. Its existence is critical for maintaining audit trails and ensuring data integrity during the adjustment process for labor costs across projects and tasks.

Key Information Stored

While the provided metadata does not list all columns, the documented primary and foreign keys reveal the essential data points stored. The primary key, ADJUSTMENT_BATCH_NAME, uniquely identifies each adjustment batch. The table links to foundational EBS structures via foreign keys: SET_OF_BOOKS_ID references the accounting context (GL_SETS_OF_BOOKS), and BUSINESS_GROUP_ID references the HR organizational context (HR_ALL_ORGANIZATION_UNITS). This structure ensures adjustments are processed within the correct legal entity and chart of accounts. Other typical columns in such a control table would include batch creation date, status (e.g., 'Entered', 'Validated', 'Posted'), requested by, and description, forming a complete control record.

Common Use Cases and Queries

This table is central to queries for monitoring the lifecycle of labor cost adjustments. Common operational reports include listing all pending adjustment batches for a specific business group or set of books, or summarizing batches created within a date range. A typical query would join to the related lines table to report on batch totals. For example:

  • Batch Status Inquiry: SELECT adjustment_batch_name, creation_date, status FROM psp_adjustment_control_table WHERE business_group_id = :p_bg_id AND set_of_books_id = :p_sob_id ORDER BY creation_date DESC;
  • Batch Detail Summary: SELECT ctrl.adjustment_batch_name, ctrl.status, COUNT(line.batch_name) AS line_count FROM psp_adjustment_control_table ctrl, psp_adjustment_lines line WHERE ctrl.adjustment_batch_name = line.batch_name GROUP BY ctrl.adjustment_batch_name, ctrl.status;

These queries support audit reviews and operational oversight of the adjustment workflow.

Related Objects

The PSP_ADJUSTMENT_CONTROL_TABLE has defined relationships with several key tables, as per the provided metadata:

  • Parent/Reference Tables:
    • GL_SETS_OF_BOOKS: Joined via SET_OF_BOOKS_ID. Provides the accounting setup.
    • HR_ALL_ORGANIZATION_UNITS: Joined via BUSINESS_GROUP_ID. Provides the HR business group context.
  • Child/Detail Tables:
    • PSP_ADJUSTMENT_LINES: The primary detail table. Joined on PSP_ADJUSTMENT_LINES.BATCH_NAME = PSP_ADJUSTMENT_CONTROL_TABLE.ADJUSTMENT_BATCH_NAME. Stores the individual adjustment transactions.
    • PSP_ADJUSTMENT_LINES_HISTORY: The historical archive for detail lines. Joined on PSP_ADJUSTMENT_LINES_HISTORY.ADJUSTMENT_BATCH_NAME = PSP_ADJUSTMENT_CONTROL_TABLE.ADJUSTMENT_BATCH_NAME.

This relationship hierarchy establishes a clear parent-child data model where the control table acts as the header record for one or many lines in both active and historical tables.