Search Results pa_forecast_items




Overview
Explore in AI Chat

Overview

The PA_FORECAST_ITEMS table is a core transactional table within the Oracle E-Business Suite Project Resource Management module. It serves as the detailed repository for daily resource demand and supply data. Specifically, it stores granular, day-level information for both project requirements (demand) and resource assignments (supply). A critical aspect of its design is its ability to also hold data for unassigned days for schedulable resources, enabling comprehensive capacity planning and forecasting. Its primary role is to support the scheduling engine, facilitate resource utilization analysis, and provide the underlying data for forecasting reports within Oracle Projects.

Key Information Stored

The table's structure is designed to capture the intersection of resource, project, time, and effort. While the full column list is extensive, key columns inferred from its description and foreign key relationships include FORECAST_ITEM_ID (the primary key), ASSIGNMENT_ID (linking to PA_PROJECT_ASSIGNMENTS), and the forecast date. It also holds organizational context via PROJECT_ORGANIZATION_ID and EXPENDITURE_ORGANIZATION_ID, and job role information via JOB_ID. Crucially, it stores the quantitative effort or hours planned for each day, which is the foundational data for understanding resource loading and availability.

Common Use Cases and Queries

This table is central to reporting on resource forecasts and schedules. Common use cases include analyzing daily resource allocations against a project plan, identifying overallocation or underutilization of resources by day, and generating capacity vs. demand reports. A typical query pattern involves joining to assignment, project, and resource tables to contextualize the forecast data. For example, to retrieve a daily forecast for a specific project, one might query:

  • SELECT pfi.forecast_date, SUM(pfi.quantity) FROM pa_forecast_items pfi, pa_projects_all ppa WHERE pfi.project_id = ppa.project_id AND ppa.segment1 = 'PROJ123' GROUP BY pfi.forecast_date;

Data from this table is also essential for reconciling forecasted effort with actuals captured in the PA_EXPENDITURES table.

Related Objects

PA_FORECAST_ITEMS has defined relationships with several other key EBS tables, as documented in the provided metadata. Its primary foreign key relationships are:

  • PA_PROJECT_ASSIGNMENTS: Joined via ASSIGNMENT_ID. This links forecast details to the specific project assignment record.
  • PER_JOBS: Joined via JOB_ID. This provides the job role for the forecasted effort.
  • HR_ALL_ORGANIZATION_UNITS: Joined via both PROJECT_ORGANIZATION_ID and EXPENDITURE_ORGANIZATION_ID. These links provide the executing and financial organizational context.
  • PA_FI_AMOUNT_DETAILS: This table references PA_FORECAST_ITEMS via FORECAST_ITEM_ID, storing detailed financial amounts (e.g., raw cost, burdened cost) associated with the forecasted effort.

The primary key, FORECAST_ITEM_ID, is the central point for these relationships, ensuring data integrity across the resource forecasting model.

  • Table: PA_FORECAST_ITEMS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FORECAST_ITEMS,  object_name:PA_FORECAST_ITEMS,  status:VALID,  product: PA - Projects ,  description: This table stores the detail information by day for each requirement and assignment in Oracle Project Resource Management. It also stores similar information for each unassigned day for all resources that can be scheduled ,  implementation_dba_data: PA.PA_FORECAST_ITEMS , 

  • Table: PA_FORECAST_ITEMS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FORECAST_ITEMS,  object_name:PA_FORECAST_ITEMS,  status:VALID,  product: PA - Projects ,  description: This table stores the detail information by day for each requirement and assignment in Oracle Project Resource Management. It also stores similar information for each unassigned day for all resources that can be scheduled ,  implementation_dba_data: PA.PA_FORECAST_ITEMS , 

  • Table: PA_FI_AMOUNT_DETAILS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FI_AMOUNT_DETAILS,  object_name:PA_FI_AMOUNT_DETAILS,  status:VALID,  product: PA - Projects ,  description: This table stores the amount details information for a forecast item. ,  implementation_dba_data: PA.PA_FI_AMOUNT_DETAILS , 

  • Table: PA_FI_AMOUNT_DETAILS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_FI_AMOUNT_DETAILS,  object_name:PA_FI_AMOUNT_DETAILS,  status:VALID,  product: PA - Projects ,  description: This table stores the amount details information for a forecast item. ,  implementation_dba_data: PA.PA_FI_AMOUNT_DETAILS , 

  • View: PA_REP_RES_SCHHRS_GL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_GL_V,  object_name:PA_REP_RES_SCHHRS_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_GL_V is a view that shows scheduled resource hours for a gl period ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_GL_V , 

  • View: PA_REP_RES_SCHHRS_PA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_PA_V,  object_name:PA_REP_RES_SCHHRS_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_PA_V is view that shows scheduled resource hours for a pa period ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_PA_V , 

  • View: PA_REP_RES_SCHHRS_WK_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_WK_V,  object_name:PA_REP_RES_SCHHRS_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_WK_V is a view that shows the scheduled resource hours for a global week ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_WK_V , 

  • View: PA_REP_RES_SCHHRS_PA_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_PA_V,  object_name:PA_REP_RES_SCHHRS_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_PA_V is view that shows scheduled resource hours for a pa period ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_PA_V , 

  • View: PA_REP_RES_SCHHRS_WK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_WK_V,  object_name:PA_REP_RES_SCHHRS_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_WK_V is a view that shows the scheduled resource hours for a global week ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_WK_V , 

  • View: PA_REP_RES_SCHHRS_GL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_GL_V,  object_name:PA_REP_RES_SCHHRS_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_GL_V is a view that shows scheduled resource hours for a gl period ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_GL_V , 

  • View: PA_RES_OVC_HOURS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_OVC_HOURS_V,  object_name:PA_RES_OVC_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_OVC_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_OVC_HOURS_V , 

  • View: PA_REP_PROJ_REQHRS_WK_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_WK_V,  object_name:PA_REP_PROJ_REQHRS_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_WK_V is a view that shows required project hours for global expenditure week ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_WK_V , 

  • View: PA_RES_OVC_HOURS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_OVC_HOURS_V,  object_name:PA_RES_OVC_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_OVC_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_OVC_HOURS_V , 

  • View: PA_REP_RES_CAP_WKD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_CAP_WKD_V,  object_name:PA_REP_RES_CAP_WKD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_CAP_WKD_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_CAP_WKD_V , 

  • View: PA_REP_RES_OVC_WK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_OVC_WK_V,  object_name:PA_REP_RES_OVC_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_OVC_WK_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_OVC_WK_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 , 

  • View: PA_REP_RES_CAP_WKD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_CAP_WKD_V,  object_name:PA_REP_RES_CAP_WKD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_CAP_WKD_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_CAP_WKD_V , 

  • View: PA_REP_PROJ_REQHRS_WK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_WK_V,  object_name:PA_REP_PROJ_REQHRS_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_WK_V is a view that shows required project hours for global expenditure week ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_WK_V , 

  • View: PA_REP_RES_OVC_WK_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_OVC_WK_V,  object_name:PA_REP_RES_OVC_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_OVC_WK_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_OVC_WK_V , 

  • View: PA_REP_RES_AVL_WK_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_AVL_WK_V,  object_name:PA_REP_RES_AVL_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_AVL_WK_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_AVL_WK_V , 

  • View: PA_RES_AVL_HOURS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_AVL_HOURS_V,  object_name:PA_RES_AVL_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_AVL_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_AVL_HOURS_V , 

  • View: PA_RES_AVL_HOURS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_AVL_HOURS_V,  object_name:PA_RES_AVL_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_AVL_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_AVL_HOURS_V , 

  • View: PA_REP_RES_AVL_WK_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_AVL_WK_V,  object_name:PA_REP_RES_AVL_WK_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_AVL_WK_V is a view that shows resource capacity for a gloabl week ,  implementation_dba_data: APPS.PA_REP_RES_AVL_WK_V , 

  • View: PA_RES_OVC_HOURS_STAFF_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_OVC_HOURS_STAFF_V,  object_name:PA_RES_OVC_HOURS_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_OVC_HOURS_STAFF_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_OVC_HOURS_STAFF_V , 

  • View: PA_REP_PROJ_REQHRS_PA_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_PA_V,  object_name:PA_REP_PROJ_REQHRS_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_PA_V is a view that shows required project hours for a pa period ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_PA_V , 

  • 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 , 

  • View: PA_REP_PROJ_REQHRS_WKD_V 12.1.1

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

  • View: PA_RES_AVL_HOURS_STAFF_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_AVL_HOURS_STAFF_V,  object_name:PA_RES_AVL_HOURS_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_AVL_HOURS_STAFF_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_AVL_HOURS_STAFF_V , 

  • View: PA_REP_RES_SCHHRS_GLD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_GLD_V,  object_name:PA_REP_RES_SCHHRS_GLD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_GLD_V is a view that shows team role details for a gl period ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_GLD_V , 

  • View: PA_REP_PROJ_REQHRS_PAD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_PAD_V,  object_name:PA_REP_PROJ_REQHRS_PAD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_PAD_V is a view that shows team role details for a pa period ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_PAD_V , 

  • View: PA_RES_OVC_HOURS_STAFF_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_OVC_HOURS_STAFF_V,  object_name:PA_RES_OVC_HOURS_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_OVC_HOURS_STAFF_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_OVC_HOURS_STAFF_V , 

  • View: PA_REP_RES_SCHHRS_WKD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_WKD_V,  object_name:PA_REP_RES_SCHHRS_WKD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_WKD_V is a view that shows team role details for a global week ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_WKD_V , 

  • View: PA_REP_PROJ_REQHRS_PA_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_PA_V,  object_name:PA_REP_PROJ_REQHRS_PA_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_PA_V is a view that shows required project hours for a pa period ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_PA_V , 

  • View: PA_REP_RES_SCHHRS_WKD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_WKD_V,  object_name:PA_REP_RES_SCHHRS_WKD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_WKD_V is a view that shows team role details for a global week ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_WKD_V , 

  • View: PA_RES_AVL_HOURS_STAFF_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_AVL_HOURS_STAFF_V,  object_name:PA_RES_AVL_HOURS_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_AVL_HOURS_STAFF_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_AVL_HOURS_STAFF_V , 

  • View: PA_REP_PROJ_REQHRS_WKD_V 12.2.2

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

  • View: PA_REP_PROJ_REQHRS_GL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_GL_V,  object_name:PA_REP_PROJ_REQHRS_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_GL_V is a view that shows required project hours for a gl period ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_GL_V , 

  • View: PA_REP_PROJ_REQHRS_GL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_GL_V,  object_name:PA_REP_PROJ_REQHRS_GL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_GL_V is a view that shows required project hours for a gl period ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_GL_V , 

  • View: PA_REP_PROJ_REQHRS_GLD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_GLD_V,  object_name:PA_REP_PROJ_REQHRS_GLD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_GLD_V is a view that shows team role details for a gl period ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_GLD_V , 

  • View: PA_REP_RES_SCHHRS_PAD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_PAD_V,  object_name:PA_REP_RES_SCHHRS_PAD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_PAD_V is a view that shows the team role details for a pa period ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_PAD_V , 

  • View: PA_REP_PROJ_REQHRS_PAD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_PAD_V,  object_name:PA_REP_PROJ_REQHRS_PAD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_PAD_V is a view that shows team role details for a pa period ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_PAD_V , 

  • View: PA_REP_RES_SCHHRS_PAD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_PAD_V,  object_name:PA_REP_RES_SCHHRS_PAD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_PAD_V is a view that shows the team role details for a pa period ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_PAD_V , 

  • View: PA_REP_RES_SCHHRS_GLD_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_SCHHRS_GLD_V,  object_name:PA_REP_RES_SCHHRS_GLD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_SCHHRS_GLD_V is a view that shows team role details for a gl period ,  implementation_dba_data: APPS.PA_REP_RES_SCHHRS_GLD_V , 

  • View: PA_REP_PROJ_REQHRS_GLD_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_REQHRS_GLD_V,  object_name:PA_REP_PROJ_REQHRS_GLD_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_PROJ_REQHRS_GLD_V is a view that shows team role details for a gl period ,  implementation_dba_data: APPS.PA_REP_PROJ_REQHRS_GLD_V ,