Search Results organization_schedule_id

Overview

PSPBV_ORG_SCHEDULE_LINES is a read-only view shipped with the Oracle E-Business Suite PSP – Labor Distribution module. It presents the charging account information associated with an organization-level labor schedule, that is, the account distribution records that determine how an employee's charges are split across accounts for a given scheduling period. In Oracle Labor Distribution, schedule lines describe the percentage of effort or cost allocated to a particular charging account, project, task, award, or expenditure type. The view consolidates these allocation rows with the descriptive flexfield reference to the general ledger account, enabling reporting on scheduled labor distributions at the organization level. Because the view is declared WITH READ ONLY, it is intended strictly for inquiry and reporting, not for data manipulation. Note that ETRM documentation records this view as "Not implemented in this database," meaning it may not exist in every environment and should be validated against the target instance before being referenced.

Underlying Base Objects

The view is defined over two base objects:

• PSP_DEFAULT_LABOR_SCHEDULES (PDL) – the primary table holding the schedule line rows, including organization schedule identifiers, schedule dates, percentages, and account references.
• GL_CODE_COMBINATIONS (GCC) – joined to provide the accounting flexfield context through the condition PDL.GL_CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID.

A key-filter column, _KF:SQLGL:GL#:GCC:_CO, is emitted from GL_CODE_COMBINATIONS, exposing the GL account segment via the key flexfield mechanism. The view also applies a security predicate, _SEC:PDL.EXPENDITURE_ORGANIZATION_ID, restricting rows based on the operating unit or organization security context. Although ETRM lists no referenced base objects in its documented view metadata, the view text clearly identifies these two sources.

Key Columns

• ORG_SCHEDULE_ID / ORGANIZATION_SCHEDULE_ID – the identifier of the organization-level schedule, central to the queried term "organization_schedule_id."
• SCHEDULE_BEGIN_DATE / SCHEDULE_END_DATE – the effective date range of the schedule line.
• SCHEDULE_PERCENT – the distribution percentage assigned to the charging account.
• SET_OF_BOOKS_ID – the ledger context for the schedule.
• BUSINESS_GROUP_ID – the HR business group associated with the record.
• ORGANIZATION_ID – the organization owning the schedule line.
• PROJECT_ID, TASK_ID, AWARD_ID – project accounting references for cost collection.
• EXPENDITURE_ORGANIZATION_ID (EXPEND_ORGANIZATION_ID) – the expenditure organization; also the security driver.
• EXPENDITURE_TYPE – the classification of the labor expenditure.
• COMMENTS and audit columns (LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE).

Common Use Cases and Queries

This view is used to audit and report on scheduled labor distributions per organization. Typical scenarios include verifying that schedule percentages sum correctly, reconciling scheduled versus actual charges, and reviewing account assignments for a project or award.

Example: retrieve all lines for a given organization schedule.

• SELECT organization_schedule_id, schedule_begin_date, schedule_end_date, schedule_percentage, organization_id, project_id, task_id, award_id, expenditure_type
• FROM psppv_org_schedule_lines
• WHERE organization_schedule_id = :p_schedule_id
• ORDER BY schedule_begin_date;

Example: aggregate distribution percentages by organization schedule.

• SELECT organization_schedule_id, SUM(schedule_percentage)
• FROM psppv_org_schedule_lines
• GROUP BY organization_schedule_id;

Because the view enforces organization security and is read-only, it is safe for ad-hoc inquiry and for feeding downstream reporting or integration extracts.