Search Results pa_schedules_history




Overview
Explore in AI Chat

Overview

The PA_SCHEDULES_HISTORY table is a critical audit and historical data repository within the Oracle E-Business Suite Projects module (PA). Its primary function is to store immutable copies of schedule records from the PA_SCHEDULES table whenever those records are modified. This design pattern is central to maintaining a complete audit trail for project planning and resource scheduling data, enabling historical reporting, compliance, and analysis of how project schedules have evolved over time. The table operates as part of a broader history architecture in Projects, ensuring that changes to assignments, tasks, and their associated schedules are permanently recorded for traceability.

Key Information Stored

The table captures a snapshot of a schedule record at the moment of a change. Its structure is closely aligned with its source table, PA_SCHEDULES. The metadata indicates a composite primary key consisting of CHANGE_ID and SCHEDULE_ID, which links each historical record to a specific change event and the original schedule identifier. Key foreign key relationships define its context: the ASSIGNMENT_ID column links to both PA_PROJECT_ASSIGNMENTS (the current assignment) and PA_ASSIGNMENTS_HISTORY (the historical assignment record), the PROJECT_ID links to PA_PROJECTS_ALL, and the STATUS_CODE links to PA_PROJECT_STATUSES. This structure ensures each historical schedule record is anchored to the specific project, assignment, and status valid at the time of the change.

Common Use Cases and Queries

The primary use case is auditing and historical analysis of project schedule changes. This supports answering questions such as how a resource's planned hours on a task were adjusted over the project lifecycle or what the schedule baseline was at a specific milestone. Common reporting needs include generating change logs for project audits and analyzing schedule variance from an original plan. A typical query pattern involves joining PA_SCHEDULES_HISTORY with PA_ASSIGNMENTS_HISTORY and PA_PROJECTS_ALL to reconstruct a historical view of a project's resource plan.

  • Sample Query Pattern: Selecting all historical schedule records for a specific project assignment, ordered by change date to show evolution.
  • Reporting Use Case: Comparing current schedule values in PA_SCHEDULES against the earliest or a specific prior version in PA_SCHEDULES_HISTORY to calculate total change magnitude.

Related Objects

PA_SCHEDULES_HISTORY is integrally linked to several core Projects tables, as defined by its foreign keys. Its immediate parent is the PA_SCHEDULES table, from which it receives its data. It has a mandatory relationship with PA_ASSIGNMENTS_HISTORY via the composite foreign key on ASSIGNMENT_ID and CHANGE_ID, ensuring schedule history is synchronized with assignment history. It also references PA_PROJECT_ASSIGNMENTS for the current assignment context, PA_PROJECTS_ALL for project master data, and PA_PROJECT_STATUSES for valid status codes. This table is typically accessed indirectly via standard Oracle Projects reporting views or through dedicated audit reports rather than via direct public APIs.