Search Results pa_forecast_item_details

Overview

The PA_FORECAST_ITEM_DETAILS table is a core transactional data store within the Oracle E-Business Suite Projects module (PA). It functions as the detailed ledger for financial and non-financial forecast items, capturing granular planning data at the resource, organization, and period level. Its primary role is to persist the quantified details of project forecasts, which are used for budgeting, resource planning, and performance analysis. By storing this detailed information separately from summary forecast headers, it enables robust reporting, variance analysis, and detailed inquiry into projected project costs and revenues across multiple dimensions.

Key Information Stored

The table stores detailed forecast amounts, with labor hours cited as a canonical example in the documentation. Its structure is defined by key foreign key relationships that provide critical context for each forecast line. The most significant columns include those linking to related master data: PROJECT_ID (references PA_PROJECTS_ALL), RESOURCE_ID (references PA_RESOURCES), JOB_ID (references PER_JOBS), and EXPENDITURE_ORGANIZATION_ID (references HR_ALL_ORGANIZATION_UNITS). These relationships anchor each forecast detail to a specific project, a person or resource, a job role, and an executing organization. Additional columns typically store period dates, forecast amounts (in both transaction and project functional currency), quantity, and rate information, forming a complete record for each forecasted item.

Common Use Cases and Queries

This table is central to forecast analysis and reconciliation. Common operational and reporting use cases include generating detailed forecast vs. actual reports, analyzing resource loading by organization or job, and drilling into forecast data from summary screens. A typical analytical query might join this table to its related master tables to produce a resource forecast report. For example:

SELECT p.segment1 project_number, r.resource_name, j.name job_name, hou.name org_name, fid.quantity, fid.raw_cost
FROM pa_forecast_item_details fid,
    pa_projects_all p,
    pa_resources r,
    per_jobs j,
    hr_all_organization_units hou
WHERE fid.project_id = p.project_id
  AND fid.resource_id = r.resource_id
  AND fid.job_id = j.job_id(+)
  AND fid.expenditure_organization_id = hou.organization_id
  AND p.segment1 = 'P10001';

Data from this table is also essential for month-end close processes within Projects, where forecast data may be compared to accrued actuals.

Related Objects

As indicated by its foreign keys, PA_FORECAST_ITEM_DETAILS has direct dependencies on several key master tables: PA_PROJECTS_ALL for project definitions, PA_RESOURCES for the resource list, PER_JOBS for job roles, and HR_ALL_ORGANIZATION_UNITS for organizational hierarchy. It is a child table to a forecast header table (such as PA_FORECAST_ITEMS), which stores summary-level information. For reporting and application logic, this table is typically accessed via standard Oracle Projects views or through the public APIs provided by the PA_FORECAST_ITEMS_PKG package. Direct manipulation of this table outside of these certified interfaces is strongly discouraged, as it can compromise data integrity.