Results for “pspfv_cost_dist_line_adjust”

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

Overview

PSPFV_COST_DIST_LINE_ADJUST is a reporting view in the Oracle EBS Labor Distribution (PSP) module. It exposes information about distribution lines generated as a result of cost adjustments processed within Labor Distribution. Adjustment lines represent corrections, reclassifications, or retrospective redistributions applied to previously distributed payroll or labor costs, and this view presents those lines together with their associated payroll control, person, assignment, element, project, task, award, and general ledger accounting context.

The view is intended for inquiry, reporting, and integration rather than transactional update. It is a non-updatable query surface that joins adjustment line data with history and reference tables to provide a denormalized, reporting-friendly representation. In Oracle EBS 12.1.1 and 12.2.2 the object is exposed as a standard view within the Labor Distribution schema, enabling customers and integrators to build concurrent programs, BI Publisher reports, OBIEE extracts, and custom SQL without joining the base PSP tables directly.

Note that the ETRM metadata lists this object as "Not implemented in this database," meaning the view may not be deployed in every environment. Prior to relying on it, verify its existence in the target instance.

Underlying Base Objects

The view is defined over a substantial set of base tables. The primary driver is PSP_ADJUSTMENT_LINES (aliased PAL), which holds the adjustment distribution lines themselves, and PSP_ADJUSTMENT_LINES_HISTORY (PAH), which supplies historical/header-level adjustment context. Supporting joins include:

• PSP_PAYROLL_CONTROLS (PPC) — payroll control batch and status information.
• PER_ALL_PEOPLE_F (PPF) and PER_ALL_ASSIGNMENTS_F (PAA) — person and assignment details.
• PAY_ELEMENT_TYPES_F (PET) — element type names for the payroll element involved.
• PER_TIME_PERIODS (PTP) — period names for the adjustment.
• HR_ALL_ORGANIZATION_UNITS (HOU, HOU1, HOU3) — expenditure organization names.
• PA_TASKS (PT, PT1) — task names for the line and header.
• GMS_AWARDS_ALL / GMS_AWARDS (GAA, GAA1) — award full names.
• GL-related joins via SQLGL key flexfield references for the accounting flexfield.

All joins are inner joins to these reference tables, so a row is returned only when the related person, assignment, task, award, and organization records are resolvable.

Key Columns

• ADJUSTMENT_LINE_ID, ORIG_LINE_ID, SUMMARY_LINE_ID — identifiers for the adjustment line and its related lines.
• DR_CR_FLAG, REVERSAL_ENTRY_FLAG, ORIGINAL_LINE_FLAG — debit/credit indicator, reversal indicator, and whether this is the original line, exposed with lookup meanings via the GL_LOOKUPS.
• SOURCE_TYPE, SOURCE_CODE, STATUS_CODE — the adjustment source and status, with meanings resolved through PSP_LOOKUPS.
• DISTRIBUTION_AMOUNT, PERCENT, DISTRIBUTION_DATE, EFFECTIVE_DATE — monetary and percentage detail for the line.
• GL# (GCC1, GCC2) — the GL accounting flexfield for the line and header, exposed as concatenated key flexfield segments.
• PERSON_ID, ASSIGNMENT_ID, ASSIGNMENT_NUMBER, EMPLOYEE_NUMBER, FIRST_NAME, LAST_NAME — who the adjustment relates to.
• PROJECT_ID/NAME, TASK_ID/TASK_NAME, AWARD_ID/AWARD_FULL_NAME, EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_ID — project, task, award, and expenditure context.
• ELEMENT_NAME, TIME_PERIOD_ID/PERIOD_NAME, PAYROLL_CONTROL_ID, BATCH_NAME — payroll element, period, and control batch.
• SET_OF_BOOKS_ID, GL.NAME, BUSINESS_GROUP_ID — ledger and business group identifiers.
• Standard WHO columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY.

Common Use Cases and Queries

Typical scenarios include reconciling adjusted labor costs to the GL, validating adjustment batches, and reporting adjustments by project, award, or employee. A representative query:

• SELECT adjustment_line_id, person_id, employee_number, distribution_amount, distribution_date, project_id, task_name, award_full_name, status_code FROM PSPFV_COST_DIST_LINE_ADJUST WHERE distribution_date BETWEEN :from_date AND :to_date;
• Aggregate distribution amounts by project and expenditure type for a given period.
• Identify reversal entries and original lines using REVERSAL_ENTRY_FLAG and ORIGINAL_LINE_FLAG.

Because the view already resolves lookup meanings and key flexfield concatenations, it is well suited to downstream reporting and integration feeds where raw coded values are not acceptable.