Search Results schedule_percentage




Overview
Explore in AI Chat

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:

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

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.