Search Results default_org_account_id




Overview
Explore in AI Chat

Overview

The PSP_DISTRIBUTION_LINES_HISTORY table resides in the PSP schema and belongs to the Labor Distribution module of Oracle E-Business Suite, applicable to releases 12.1.1 and 12.2.2. It stores distributed Oracle and non-Oracle payroll sublines that have not yet been transferred to General Ledger or Grants Accounting. As an intermediate staging structure, it captures the outcome of the labor distribution process — including defaulted, suspense, and adjusted charges — prior to final accounting transfer and reconciliation.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification is link. This classification is suggested because the table's structure resolves relationships among payroll sublines, summary lines, schedule lines, element accounts, effort reports, and accounting sets of books, rather than functioning as a standalone hub or a purely descriptive satellite. Modelers designing a warehouse layer may therefore treat it as a transactional link between payroll and accounting entities.

Key Information Stored

The table contains 48 documented columns. The surrogate primary key is DISTRIBUTION_LINE_ID, enforced by PSP_DISTRIBUTION_LINES_HIST_PK and mirrored in the unique index PSP_DISTRIBUTION_LINES_HIST_U1. The most significant columns include:

Salary-cap and suspense handling columns, including CAP_EXCESS_DIST_LINE_ID, CAP_EXCESS_GLCCID, ANNUAL_SALARY_CAP, SUSPENSE_AUTO_GLCCID, and ADJ_ACCOUNT_FLAG, support exception processing for capped and adjusted distributions.

Common Use Cases and Queries

Labor distribution administrators and grants accountants query this table to identify undistributed or suspense amounts, verify the accounting entries awaiting transfer, and reconcile payroll costs against effort reporting. A typical diagnostic query lists lines that have not been transferred, filtered by status and reason code:

  • SELECT distribution_line_id, payroll_sub_line_id, distribution_amount, status_code, suspense_reason_code FROM psp_distribution_lines_history WHERE status_code = :p_status;
  • Join to PSP_PAYROLL_SUB_LINES on PAYROLL_SUB_LINE_ID to trace distribution back to source payroll.
  • Join to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID to group undistributed amounts by ledger.
  • Filter on EFFORT_REPORT_ID and VERSION_NUM to analyze effort-report-driven adjustments.
  • Aggregate DISTRIBUTION_AMOUNT by DEFAULT_REASON_CODE or SUSPENSE_REASON_CODE to quantify exception volumes.

Reporting use cases include pre-transfer distribution audits, suspense clearing analysis, salary-cap excess reporting, and reconciliation of ledger transfer batches identified by ADJUSTMENT_BATCH_NAME.

Related Objects

The table is densely linked through foreign keys to core Labor Distribution and General Ledger objects:

Together these relationships position PSP_DISTRIBUTION_LINES_HISTORY as the pivotal link between payroll cost origination and downstream General Ledger or Grants Accounting transfer.