Search Results pspfv_labor_schedule_lines

Overview

PSPFV_LABOR_SCHEDULE_LINES is a read-only reporting view in the Oracle E-Business Suite Labor Distribution module (PSP). It exposes labor schedule line records stored in the PSP_SCHEDULE_LINES table, joined to the descriptive attributes of the projects, tasks, awards, organizations, and sets of books that those lines reference. The view is intended for reporting and integration rather than for transaction processing; it is declared WITH READ ONLY and is vendor-owned, meaning it should be queried but never modified.

In the context of a user searching for encumbrance_status, this view is directly relevant because it surfaces the ENCUMBER_STATUS_CODE column from the underlying schedule lines table, exposed under the column alias ENCUMBRANCE_STATUS. This column indicates how labor schedule lines interact with encumbrance accounting, which determines whether scheduled labor costs generate encumbrance entries against awards and projects. The view therefore serves as a convenient single source for reviewing labor schedule distributions alongside their encumbrance treatment and the descriptive context needed to interpret them.

Underlying Base Objects

The view is defined over PSP_SCHEDULE_LINES as the driving table, with outer joins (denoted by the (+) operator) to the following reference objects:

• GL_SETS_OF_BOOKS — supplies the set of books name.
• PA_PROJECTS_ALL — supplies the project name.
• PA_TASKS — supplies the task name.
• GMS_AWARDS_ALL — supplies the award full name.
• HR_ALL_ORGANIZATION_UNITS (aliased HOU) — supplies the expenditure organization name.
• GL_CODE_COMBINATIONS — supplies the accounting flexfield, exposed through the key flexfield alias "_KF:GL_ACCOUNT".
• HR_ALL_ORGANIZATION_UNITS (aliased HOU2) — supplies the business group name.

Because the reference tables are outer-joined, schedule lines are retained in the result set even when a related project, task, award, organization, or accounting combination is missing or inaccessible. A mandatory inner join on business group (PSL.BUSINESS_GROUP_ID = HOU2.ORGANIZATION_ID) and a security predicate ("_SEC:PSL.EXPENDITURE_ORGANIZATION_ID") constrain the rows according to the querying user's organization access.

Key Columns

• ENCUMBRANCE_STATUS — the encumbrance status of the schedule line (sourced from ENCUMBER_STATUS_CODE); central to determining how the line participates in encumbrance accounting.
• SCHEDULE_LINE_ID — primary identifier for the schedule line.
• SCHEDULE_BEGIN_DATE / SCHEDULE_END_DATE / SCHEDULE_PERCENTAGE — the effective period and percentage allocation of the line.
• DEFAULT_INDICATOR / WARNING_CODE — flags indicating default status and any warning associated with the line.
• SET_OF_BOOKS_ID / SET_OF_BOOKS_NAME, BUSINESS_GROUP_ID / BUSINESS_GRP_NAME — accounting and HR context.
• PROJECT_ID / PROJECT_NAME, TASK_ID / TASK_NAME, AWARD_ID / AWARD_FULL_NAME — descriptive project, task, and award attributes.
• ORGANIZATION_ID / ORGANIZATION_NAME, EXPENDITURE_TYPE — expenditure organization and type charged.
• _KF:GL_ACCOUNT — the concatenated accounting flexfield.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — audit columns.

Common Use Cases and Queries

Typical scenarios include auditing labor schedule distributions for encumbrance treatment, reconciling scheduled labor to awards and projects, and feeding downstream reporting or integration extracts.

To list schedule lines by encumbrance status:

• SELECT schedule_line_id, project_name, task_name, award_full_name, encumbrance_status, schedule_percentage FROM pspfv_labor_schedule_lines WHERE encumbrance_status = :status;

To review encumbrance status by award for a given set of books:

• SELECT award_full_name, encumbrance_status, COUNT(*) FROM pspfv_labor_schedule_lines WHERE set_of_books_name = :sob GROUP BY award_full_name, encumbrance_status;

Because the view enforces organization security and is read only, it is safe for ad hoc reporting and scheduled extracts without risk of altering base data.