Search Results psp_enc_lines




Overview
Explore in AI Chat

Overview

PSP_ENC_LINES is a transient staging and audit table within the Oracle E-Business Suite Labor Distribution (PSP) module. It stores the individual encumbrance lines generated by the Create Encumbrance and Update Encumbrance concurrent processes. These processes translate labor cost distributions into encumbrance accounting entries, and PSP_ENC_LINES holds the resulting line-level detail before or alongside posting to the General Ledger. Because the table captures one row per encumbrance line derived from a payroll or labor schedule, it acts as the authoritative source for examining how costs were mapped to accounts, awards, projects, and tasks.

Under a heuristic Data Vault classification mined from its foreign-key structure, PSP_ENC_LINES is best modeled as a link entity. It sits at the intersection of multiple business keys — payroll, element type, project, award, time period, and encumbrance control — and its 61 columns encode both the transactional mapping (the link itself) and descriptive attributes (effectively satellite-style content) such as amounts, dates, and status codes.

Key Information Stored

The surrogate primary key is ENC_LINE_ID, enforced through the PSP_ENC_LINES_PK constraint and the unique index PSP_ENC_LINES_U1. The principal business-key relationships and descriptive columns include:

Common Use Cases and Queries

Typical reporting scenarios include reconciliation of labor encumbrances to GL balances, investigation of suspense-account postings (via SUSPENSE_ORG_ACCOUNT_ID and SUSPENSE_REASON_CODE), and audit of project/award cost transfers. A common query joins encumbrance lines to their payroll and GL account:

  • Encumbrances by payroll period: join PSP_ENC_LINES to PER_TIME_PERIODS on TIME_PERIOD_ID and group by ENCUMBRANCE_AMOUNT.
  • Project cost verification: filter by PROJECT_ID and AWARD_ID, comparing GL_CODE_COMBINATION_ID against ORIG_GL_CODE_COMBINATION_ID to detect reclassifications.
  • Suspense monitoring: select lines where SUSPENSE_REASON_CODE is not null to identify labor charges lacking a valid account.
  • Encumbrance reversal analysis: use CHANGE_FLAG and STATUS_CODE to identify lines created or modified by the Update Encumbrance process.

Related Objects

  • PSP_ENC_PAYROLLS — Parent payroll header; joined on PAYROLL_ID.
  • PSP_ENC_CONTROLS — Encumbrance run control; joined on ENC_CONTROL_ID.
  • PSP_ENC_SUMMARY_LINES — Aggregated encumbrance summary; joined on ENC_LINE_ID.
  • PSP_ELEMENT_TYPE_ACCOUNTS — Defines element charge accounts; joined on ELEMENT_ACCOUNT_ID.
  • PSP_DEFAULT_LABOR_SCHEDULES — Organization schedule source; joined on ORG_SCHEDULE_ID.
  • PER_TIME_PERIODS — Accounting period; joined on TIME_PERIOD_ID.
  • IGF_AW_AWARD_ALL — Grants award master; joined on AWARD_ID.
  • PAY_PAYROLL_ACTIONS — Payroll action reference; joined on PAYROLL_ACTION_ID.