Search Results pa_frcst_items_ar




Overview
Explore in AI Chat

Overview

PA_FRCST_ITEMS_AR is a transaction-detail table in the Oracle Projects (PA) schema. It stores daily granularity forecasts for every requirement and assignment managed within Oracle Project Resource Management, and it additionally holds equivalent information for each unassigned day across all schedulable resources. In practice, the table represents the most atomic forecasting layer in the resource management model: rather than storing a single aggregate for a requirement, it persists one row per requirement, resource, and calendar day, allowing planners and reporting processes to interrogate forecasted quantities, costs, and revenue at a day-by-day resolution.

Because its rows attach attributes to combinations of forecast items, dates, resources, and organizations, the table behaves as an association between otherwise independent business entities. Mined from its foreign-key structure, the heuristic Data Vault classification is link. This should be treated as a modeling suggestion rather than a documented fact: the table's defining characteristic is that it records relationships (forecast item to resource to day), which is consistent with link-style modeling, while still carrying measurable satellite-type attributes such as quantities, costs, and flags.

Key Information Stored

The table is physically documented with 78 columns in the 12.2.2 ETRM schema. The most operationally significant columns include:

No surrogate single-column primary key is asserted in the metadata; the ETRM documentation identifies the table through its foreign-key relationships rather than a declared primary key. Business-key candidates for uniqueness are effectively the composite of FORECAST_ITEM_ID, ITEM_DATE, and the resource or assignment identifiers, which together distinguish each daily forecast row.

Common Use Cases and Queries

Typical uses of PA_FRCST_ITEMS_AR center on resource forecasting, capacity utilization reporting, and purge/archival processing.

  • Daily forecast extraction: join to PA_FORECAST_ITEMS to retrieve forecasts for a project or organization over a date range. A representative pattern is SELECT fi.* FROM pa_frcst_items_ar fi WHERE fi.forecast_item_id = :item_id AND fi.item_date BETWEEN :start_date AND :end_date.
  • Availability and over-commitment analysis: filter on AVAILABILITY_FLAG, OVERCOMMITMENT_FLAG, and OVERCOMMITMENT_QUANTITY to surface days where assigned effort exceeds resource capacity.
  • Financial roll-ups: the table stores raw, burdened, and transfer-price amounts in both project and expenditure functional currencies (PROJECT_RAW_COST, PROJFUNC_BURDENED_COST, EXPFUNC_TRANSFER_PRICE, TXN_RAW_COST, and similar). Reporting queries aggregate these by ITEM_DATE to produce forecast cost and revenue curves.
  • Rejection and error review: columns such as ERROR_FLAG, COST_REJECTION_CODE, REV_REJECTION_CODE, and BURDEN_REJECTION_CODE allow support teams to find rows rejected during cost or revenue processing.
  • Period reconciliation: PVDR_PA_PERIOD_NAME, RCVR_PA_PERIOD_NAME, and the corresponding GL period name columns support provider/receiver period matching.
  • Purge processing: rows grouped by PURGE_BATCH_ID and PURGE_PROJECT_ID are removed by the purge concurrent program after the retention criteria are met.

Related Objects

The following relationships are documented and are the most significant dependencies for this table:

  • PA_FORECAST_ITEMS — joined via FORECAST_ITEM_ID; this is the parent forecast definition that gives each detail row its business context.
  • HR_ALL_ORGANIZATION_UNITS — joined twice, via EXPENDITURE_ORGANIZATION_ID and PROJECT_ORGANIZATION_ID, to resolve delivering and owning organization names.
  • PA_PURGE_BATCHES_ALL — joined via PURGE_BATCH_ID to identify the purge run under which the row is scheduled for removal.
  • PER_ALL_PEOPLE_F and PER_ALL_ASSIGNMENTS_F — commonly joined through PERSON_ID or RESOURCE_ID to obtain resource names and assignment attributes, since RESOURCE_ID and PERSON_ID are carried on the table.
  • PA_PROJECTS_ALL — joined via PROJECT_ID to obtain project number, name, and project type for reporting.

In summary, PA_FRCST_ITEMS_AR is the daily fact layer of Oracle Project Resource Management forecasting, anchored by PA_FORECAST_ITEMS and organization and project lookups, and distinguished by its rich set of quantity, availability, cost, rejection, and purge attributes.