Results for “psp_temp_orig_lines”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PSP_TEMP_ORIG_LINES is a transient staging table in the Oracle E-Business Suite Labor Distribution module (PSP). It stores the set of original distribution lines that match a given selection criteria during a Labor Distribution processing run. In practice, this table functions as the working set for the Labor Distribution engine: candidate payroll and labor cost lines are collected here at the start of a run, keyed by a RUN_ID, and subsequently filtered, transformed, and redistributed into the final cost allocation results. Rows are typically short-lived and are populated and consumed within a single concurrent process execution.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is standalone. This classification is offered as a modeling suggestion only; because the table primarily serves as a run-scoped staging area rather than an enduring entity of record, it does not naturally map to a hub, link, or satellite construct. Its grain is the combination of a processing run and an individual original line.

Key Information Stored

The table comprises 31 documented columns. The most significant of these are:

• RUN_ID — Identifier of the Labor Distribution processing run that owns this set of lines. Part of the composite primary key.
• ORIG_LINE_ID — Identifier of the original distribution line itself. Also part of the composite primary key and the column most frequently used as a business-key search term.
• ORIG_DISTRIBUTION_DATE and EFFECTIVE_DATE — Dates that anchor the line to its accounting and effective periods.
• DISTRIBUTION_AMOUNT and DR_CR_FLAG — The monetary amount and its debit/credit indicator.
• TIME_PERIOD_ID, PAYROLL_CONTROL_ID, and ELEMENT_GROUP_ID — Foreign keys tying the line to a time period, a payroll control record, and an element group respectively.
• ELEMENT_TYPE_ID, ACCT_GROUP_ID, and SET_OF_BOOKS_ID — Reference identifiers for the element type, accounting group, and ledger.
• GL_CODE_COMBINATION_ID — The general ledger account combination assigned to the line.
• PROJECT_ID, TASK_ID, AWARD_ID, and EXPENDITURE_TYPE — Project accounting attributes used when costs are charged to projects or awards.
• EXPENDITURE_ORGANIZATION_ID and BUSINESS_GROUP_ID — Organizational context for the line.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE10 — Flexfield descriptive columns available for extensibility.

The surrogate primary key is PSP_TEMP_ORIG_LINES_PK, defined over (RUN_ID, ORIG_LINE_ID). The pairing of these two columns constitutes the composite business key; ORIG_LINE_ID alone is not unique across the table because the same original line may be selected by multiple runs.

Common Use Cases and Queries

The primary use case is diagnostic and operational: when a Labor Distribution concurrent program produces unexpected results, the staging rows for a specific run can be inspected to confirm which original lines were selected and how they were populated.

• Retrieving all lines for a processing run:
  SELECT * FROM psp_temp_orig_lines WHERE run_id = :p_run_id;
• Locating a specific original line across runs:
  SELECT run_id, orig_line_id, distribution_amount, dr_cr_flag FROM psp_temp_orig_lines WHERE orig_line_id = :p_orig_line_id;
• Aggregating selected amounts by running total:
  SELECT run_id, SUM(distribution_amount) FROM psp_temp_orig_lines GROUP BY run_id;
• Reconciling staged lines against project and GL attributes:
  SELECT t.orig_line_id, t.project_id, t.gl_code_combination_id, t.distribution_amount FROM psp_temp_orig_lines t WHERE t.run_id = :p_run_id AND t.project_id IS NOT NULL;

Reporting against this table is normally confined to troubleshooting and audit of a specific run, since content is overwritten or purged as runs are re-executed.

Related Objects

The documented foreign keys and primary key relationships connect PSP_TEMP_ORIG_LINES to the following significant objects:

• PER_TIME_PERIODS — joined via TIME_PERIOD_ID to resolve the accounting or time period of the line.
• PSP_PAYROLL_CONTROLS — joined via PAYROLL_CONTROL_ID to identify the payroll control record governing the run.
• PSP_ELEMENT_GROUPS — joined via ELEMENT_GROUP_ID to associate the line with its element group.
• IGF_AW_AWARD_ALL — joined via AWARD_ID when labor costs are charged to sponsored awards.
• PSP_TEMP_ORIG_LINES_PK — the composite primary key constraint (RUN_ID, ORIG_LINE_ID) that enforces uniqueness of staged lines within a run.

These relationships confirm the table's position as a run-scoped collection point that references core payroll, element, period, and awards master data during Labor Distribution processing.