Search Results pa_schedules




Overview
Explore in AI Chat

Overview

The PA_SCHEDULES table is a core data repository within the Oracle E-Business Suite Projects (PA) module, specifically in versions 12.1.1 and 12.2.2. It serves as the central table for storing and managing schedule information. As defined in the ETRM, its primary role is to display schedule details for project requirements and assignments, and to store calendar schedules. This table is fundamental for modeling the time-based aspects of project planning, enabling the system to track when work is scheduled to occur, whether for a specific project assignment or a defined requirement. It acts as a bridge between project staffing data and the calendar structures that define working days and exceptions.

Key Information Stored

The table's structure is designed to link schedule data to other key project entities. The primary key is SCHEDULE_ID, which uniquely identifies each schedule record. Two critical foreign keys define the table's relationships: the ASSIGNMENT_ID links a schedule to a specific project assignment in the PA_PROJECT_ASSIGNMENTS table, and the CALENDAR_ID links the schedule to a defined working calendar in the JTF_CALENDARS_B table. While the provided metadata does not list all columns, typical data stored includes schedule start and end dates, baseline dates, schedule type indicators, and attributes for managing schedule versions and statuses. This structure allows the system to answer fundamental questions about when work is planned and which calendar governs that work period.

Common Use Cases and Queries

This table is central to reporting and processes involving project staffing timelines and resource availability. Common use cases include generating assignment timelines for a project, analyzing resource loading against scheduled dates, and auditing schedule compliance. A typical query might join PA_SCHEDULES with PA_PROJECT_ASSIGNMENTS and PER_ALL_PEOPLE_F to list all assignments and their scheduled dates for a given project. Another frequent pattern is to join with JTF_CALENDARS_B to validate scheduled work against defined working days. For reporting, schedules are often aggregated to show planned effort over time or to compare baseline schedules against current forecasts. The table is also critical for APIs and processes that create or update project assignments, as the schedule is an integral component of the assignment record.

Related Objects

  • PA_PROJECT_ASSIGNMENTS: A direct parent table linked via the foreign key on ASSIGNMENT_ID. This is the primary relationship, as every assignment can have an associated schedule.
  • JTF_CALENDARS_B: A direct parent table linked via the foreign key on CALENDAR_ID. This relationship defines the working days and exceptions applicable to the schedule.
  • PA_REQUIREMENTS: While not explicitly listed in the provided foreign keys, the description notes the table stores schedule details for requirements, implying a likely relationship with this or a related requirements table.
  • Views and APIs: Various PA module views (e.g., PA_ASSIGNMENTS_V) likely aggregate data from PA_SCHEDULES for reporting. Public APIs such as PA_RESOURCE_PVT and PA_ASSIGNMENT_PUB would internally read from and write to this table when managing assignment schedules.
  • Table: PA_SCHEDULES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SCHEDULES,  object_name:PA_SCHEDULES,  status:VALID,  product: PA - Projects ,  description: PA_SCHEDULES displays the schedule details for requirements and assignments. It also displays calendar schedules ,  implementation_dba_data: PA.PA_SCHEDULES , 

  • Table: PA_SCHEDULES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SCHEDULES,  object_name:PA_SCHEDULES,  status:VALID,  product: PA - Projects ,  description: PA_SCHEDULES displays the schedule details for requirements and assignments. It also displays calendar schedules ,  implementation_dba_data: PA.PA_SCHEDULES , 

  • Table: PA_SCHEDULES_AR 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SCHEDULES_AR,  object_name:PA_SCHEDULES_AR,  status:VALID,  product: PA - Projects ,  description: PA_SCHEDULES displays the schedule details for requirements and assignments. It also displays calendar schedules ,  implementation_dba_data: PA.PA_SCHEDULES_AR , 

  • Table: PA_SCHEDULES_AR 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_SCHEDULES_AR,  object_name:PA_SCHEDULES_AR,  status:VALID,  product: PA - Projects ,  description: PA_SCHEDULES displays the schedule details for requirements and assignments. It also displays calendar schedules ,  implementation_dba_data: PA.PA_SCHEDULES_AR , 

  • View: PA_PROJ_ASSIGNMENTS_ACTUALS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_ASSIGNMENTS_ACTUALS_V,  object_name:PA_PROJ_ASSIGNMENTS_ACTUALS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROJ_ASSIGNMENTS_ACTUALS_V , 

  • View: PA_PROJ_ASSIGNMENTS_ACTUALS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJ_ASSIGNMENTS_ACTUALS_V,  object_name:PA_PROJ_ASSIGNMENTS_ACTUALS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROJ_ASSIGNMENTS_ACTUALS_V , 

  • View: PA_SCHEDULES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_SCHEDULES_V,  object_name:PA_SCHEDULES_V,  status:VALID,  product: PA - Projects ,  description: PA_SCHEDULES_V displays the schedule details for requirements and assignments. It also displays calendar schedules ,  implementation_dba_data: APPS.PA_SCHEDULES_V , 

  • View: PA_SCHEDULES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_SCHEDULES_V,  object_name:PA_SCHEDULES_V,  status:VALID,  product: PA - Projects ,  description: PA_SCHEDULES_V displays the schedule details for requirements and assignments. It also displays calendar schedules ,  implementation_dba_data: APPS.PA_SCHEDULES_V , 

  • Table: PA_PROJECT_ASSIGNMENTS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECT_ASSIGNMENTS,  object_name:PA_PROJECT_ASSIGNMENTS,  status:VALID,  product: PA - Projects ,  description: PA_PROJECT_ASSIGNMENTS stores details of all Assignments for a project. ,  implementation_dba_data: PA.PA_PROJECT_ASSIGNMENTS , 

  • Table: PA_PROJECT_ASSIGNMENTS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_PROJECT_ASSIGNMENTS,  object_name:PA_PROJECT_ASSIGNMENTS,  status:VALID,  product: PA - Projects ,  description: PA_PROJECT_ASSIGNMENTS stores details of all Assignments for a project. ,  implementation_dba_data: PA.PA_PROJECT_ASSIGNMENTS ,