Search Results pspfv_org_schedule_lines

Overview

The view PSPFV_ORG_SCHEDULE_LINES is a reporting object within the Oracle E-Business Suite PSP – Labor Distribution module. It exposes the schedule lines that drive automated labor cost distribution, presenting the default labor schedules assigned to organizations, projects, tasks, and awards. Each row represents a single schedule line, identified by an organization schedule and bounded by a begin and end date, with the corresponding distribution percentage held in the SCHEDULE_PERCENTAGE column. This is the column most commonly sought by users searching on the term schedule_percentage.

The view is read-only, as indicated by the WITH READ ONLY clause in its definition, and is intended for query and reporting rather than transactional maintenance. It plays a central role in reconciliation and audit scenarios, allowing functional and technical users to verify how labor costs are split across accounts, projects, tasks, awards, and expenditure organizations for a given effective period.

Underlying Base Objects

The view is defined over the following documented base objects, combined through an outer-join pattern anchored on PSP_DEFAULT_LABOR_SCHEDULES:

• PSP_DEFAULT_LABOR_SCHEDULES (PDL) – the driving table holding the schedule header and line attributes, including SCHEDULE_PERCENT, SCHEDULE_BEGIN_DATE, and SCHEDULE_END_DATE.
• GL_CODE_COMBINATIONS (GCC) – supplies the accounting flexfield key flexfield reference, exposed via the "_KF:GL_ACCOUNT" column.
• HR_ORGANIZATION_UNITS (HOU) – resolves the expenditure organization name.
• HR_ALL_ORGANIZATION_UNITS (HOU2) – resolves the business group name; note this join is an inner join on BUSINESS_GROUP_ID = ORGANIZATION_ID.
• GL_SETS_OF_BOOKS (GSB) – provides the set of books name.
• PA_PROJECTS_ALL (PPA) – project name.
• PA_TASKS (PT) – task name.
• GMS_AWARDS_ALL (GAA) – award full name.

All joins other than the business group are outer joins, ensuring that schedule lines are returned even when project, task, award, or accounting references are null.

Key Columns

• ORGANIZATION_SCHEDULE_ID – unique identifier of the schedule line; useful as a grouping key.
• SCHEDULE_BEGIN_DATE / SCHEDULE_END_DATE – effective dating of the schedule line.
• SCHEDULE_PERCENTAGE – the distribution percentage applied to labor costs for the line (derived from PDL.SCHEDULE_PERCENT).
• SET_OF_BOOKS_ID / SET_OF_BOOKS_NAME – ledger context for the schedule.
• BUSINESS_GROUP_ID / BUSINESS_GRP_NAME – the HR business group owning the schedule.
• _KF:GL_ACCOUNT – the accounting flexfield combination to which costs are distributed.
• PROJECT_ID / PROJECT_NAME, TASK_ID / TASK_NAME, AWARD_ID / AWARD_FULL_NAME – the project, task, and award dimensions to which labor is charged.
• EXPEND_ORGANIZATION_ID / ORGANIZATION_NAME – the expenditure organization receiving the charge.
• EXPENDITURE_TYPE – the expenditure type associated with the schedule line.
• COMMENTS – free-form notes maintained on the schedule line.
• Audit columns – CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE.

Common Use Cases and Queries

Typical uses include auditing distribution percentages for a project, verifying that schedule percentages sum to 100% for an effective period, and validating award or expenditure organization assignments. A representative query follows:

SELECT organization_schedule_id,
       schedule_begin_date,
       schedule_end_date,
       schedule_percentage,
       project_name,
       task_name,
       award_full_name,
       organization_name
FROM   pspfv_org_schedule_lines
WHERE  schedule_begin_date <= SYSDATE
AND    (schedule_end_date IS NULL OR schedule_end_date >= SYSDATE)
AND    project_id = :project_id
ORDER BY organization_schedule_id, schedule_begin_date;

Because the view is read-only and joins several PSP, PA, GL, HR, and GMS objects, it is best suited to reporting and reconciliation rather than high-volume OLTP access. Appropriate indexing on project, task, and award identifiers in the base tables supports these queries.