Search Results psp_enc_controls




Overview
Explore in AI Chat

Overview

PSP_ENC_CONTROLS is a core transactional table within the PSP – Labor Distribution module of Oracle E-Business Suite (documented across 12.1.1 and 12.2.2). It stores one record for each time period batch processed during labor encumbrance and cost distribution. Each row represents a control header that governs how salary, wage, and related labor costs are summarized, encumbered, and posted to the General Ledger (GL) and Oracle Grants Management (OGM) for a specific time period and payroll action.

The table acts as the central anchor for the encumbrance batch lifecycle, capturing both the counts and monetary totals of debit and credit activity, the summarization rules applied, and the resulting GL and OGM amounts. It is owned by the PSP schema and is classified as VALID in the data dictionary.

From a heuristic Data Vault modeling perspective, the FK structure indicates a hub-leaning classification. The table carries a stable business key (ENC_CONTROL_ID) and references surrounding dimensions such as time periods and payroll actions, making it suitable as a hub in a Data Vault design, with its descriptive columns distributed to satellites.

Key Information Stored

The table exposes 37 documented columns. The most significant include:

Common Use Cases and Queries

Typical reporting and reconciliation scenarios include verifying that summarized amounts equal the sum of detail lines, auditing encumbrance batches by period, and monitoring the GL/GMS posting phases.

  • Batch control totals for a period: query TOTAL_DR_AMOUNT, TOTAL_CR_AMOUNT, and row counts by TIME_PERIOD_ID.
  • Reconciliation against detail: join to PSP_ENC_LINES and PSP_ENC_SUMMARY_LINES on ENC_CONTROL_ID to compare control totals with line-level sums.
  • Posting status reporting: filter on GL_PHASE and GMS_PHASE to identify batches not yet transferred to the GL or Grants.
  • Archive management: select records where ARCHIVE_FLAG indicates completed processing.

A representative query pattern:

SELECT ENC_CONTROL_ID, TIME_PERIOD_ID, TOTAL_DR_AMOUNT, TOTAL_CR_AMOUNT, GL_PHASE, GMS_PHASE FROM PSP.PSP_ENC_CONTROLS WHERE TIME_PERIOD_ID = :period AND ARCHIVE_FLAG = 'N';

Related Objects

The control record anchors a well-defined parent/child structure within Labor Distribution:

  • PSP_ENC_LINES — Detail lines joining on ENC_CONTROL_ID.
  • PSP_ENC_LINES_HISTORY and PSP_ENC_LINES_ARCH — Historical and archived detail records.
  • PSP_ENC_SUMMARY_LINES — Summarized cost lines referencing the control via ENC_CONTROL_ID and ENC_SUMMARY_LINE_ID.
  • PSP_ENC_SUMMARY_LINES_ARCH — Archived summary lines.
  • PER_TIME_PERIODS — Referenced through TIME_PERIOD_ID.
  • PAY_PAYROLL_ACTIONS — Referenced through PAYROLL_ACTION_ID.

These relationships make PSP_ENC_CONTROLS the pivotal control entity for reconciling, auditing, and reporting labor encumbrance activity across Labor Distribution, Payroll, General Ledger, and Grants.