Search Results psp_enc_summary_lines




Overview
Explore in AI Chat

Overview

PSP_ENC_SUMMARY_LINES is a table owned by the PSP schema within the Oracle EBS Labor Distribution module. It stores the summarized encumbrance lines produced when Labor Distribution processes and consolidates payroll and expenditure activity against awards, projects, and general ledger accounts. Encumbrance summarization is a critical step in the labor costing lifecycle: raw encumbrance detail from payroll and expenditure transactions is aggregated into summary records that can be interfaced to Oracle General Ledger and Project Accounting for burdening, costing, and posting. Each row therefore represents a summarized encumbrance position tied to a specific time period, person, assignment, expenditure, award, and account combination.

From a dimensional modeling perspective, the heuristic Data Vault classification for this object is hub-leaning. This suggests that PSP_ENC_SUMMARY_LINES functions primarily as a durable repository of summarized business keys (such as expenditure, award, time period, and payroll identifiers), with descriptive and amount attributes attached. Modelers should consider treating the unique business key ENC_SUMMARY_LINE_ID as a hub key, with satellite structures capturing the summarization amounts, status codes, and audit attributes.

Key Information Stored

The table contains 74 documented columns. The following are the most significant for functional and reporting purposes:

Common Use Cases and Queries

Typical reporting and reconciliation scenarios include retrieving summarized encumbrances by award, time period, or payroll action, and verifying amounts before GL posting.

  • Encumbrance reconciliation by award and period: 
    SELECT esl.enc_summary_line_id, esl.summary_amount, esl.dr_cr_flag,
       esl.status_code, esl.expenditure_id, esl.payroll_action_id
FROM   psp_enc_summary_lines esl
WHERE  esl.award_id = :award_id
AND    esl.time_period_id = :period_id;
  • Failed or rejected summary lines: 
    SELECT enc_summary_line_id, reject_reason_code, status_code
FROM   psp_enc_summary_lines
WHERE  status_code = 'REJECTED'
OR     reject_reason_code IS NOT NULL;
  • Interface status monitoring — Query by INTERFACE_STATUS, INTERFACE_ID, or GL_PERIOD_ID to track which lines remain unposted to General Ledger.
  • Drill-down to detail — Join back to PSP_ENC_LINES and PSP_ENC_LINES_HISTORY on ENC_LINE_ID to reconcile summarized totals against source detail lines.

Related Objects

  • PSP_ENC_LINES — References PSP_ENC_SUMMARY_LINES via ENC_LINE_ID; provides the detail lines that were summarized.
  • PSP_ENC_LINES_HISTORY — Historical detail referencing ENC_LINE_ID; supports historical reconciliation.
  • PSP_ENC_CONTROLS — Parent control record joined via ENC_CONTROL_ID (and referenced by ENC_SUMMARY_LINE_ID).
  • PA_EXPENDITURES_ALL — Source of expenditure detail, joined via EXPENDITURE_ID.
  • PA_EXPENDITURE_ITEMS_ALL — Expenditure line detail, joined via EXPENDITURE_ITEM_ID.
  • IGF_AW_AWARD_ALL — Award master, joined via AWARD_ID.
  • PER_TIME_PERIODS — Accounting period reference, joined via TIME_PERIOD_ID.
  • PAY_PAYROLL_ACTIONS — Payroll action reference, joined via PAYROLL_ACTION_ID.