Results for “net_zero_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_FORECAST_ITEM_DETAILS is a transaction-detail table in the Oracle Projects (PA) schema that stores the detailed amount information associated with each forecast item. Where PA_FORECAST_ITEMS captures the header-level definition of a forecast line, PA_FORECAST_ITEM_DETAILS holds the granular, periodic values that quantify that line — labor hours, quantities, and multi-currency monetary amounts — broken down by date, amount type, resource, job, and organization. In Oracle EBS 12.1.1 and 12.2.2, this table is central to project forecasting, resource planning, utilization analysis, and capacity management, feeding reporting on committed, provisional, and confirmed forecast figures.

From a Data Vault modeling perspective, the FK structure mined from the metadata suggests this object behaves primarily as a link — it resolves relationships between forecast items, resources, jobs, organizations, projects, and amount types across time. Its descriptive measures (quantities, currency amounts, utilization weights, and flags) also give it satellite-like characteristics, so a hybrid link-satellite classification is a reasonable modeling suggestion. The table is owned by the PA schema and is VALID in the documented release.

Key Information Stored

The table contains 52 documented columns. The most significant are summarized below.

• FORECAST_ITEM_ID — Foreign key to PA_FORECAST_ITEMS; forms part of the unique business key and identifies the parent forecast line.
• ITEM_DATE — The date to which the detailed amount applies; a business-key component supporting period-by-period forecasting.
• LINE_NUM — Sequence number within the forecast item; the third business-key component.
• AMOUNT_TYPE_ID — Foreign key to PA_AMOUNT_TYPES_B, identifying the amount type (e.g., labor hours, cost, revenue).
• ITEM_QUANTITY and ITEM_UOM — The detailed quantity and its unit of measure.
• RESOURCE_ID and JOB_ID — The resource and job associated with the forecast detail.
• PROJECT_ID and EXPENDITURE_ORGANIZATION_ID — Project and expenditure organization context.
• PROJ_AMOUNT / PROJ_CURRENCY_CODE — Amounts expressed in project currency.
• PVDR_ACCT_AMOUNT / PVDR_ACCT_CURR_CODE and RCVR_ACCT_AMOUNT / RCVR_ACCT_CURR_CODE — Provider and receiver accounting currency amounts.
• CAPACITY_QUANTITY, CONFIRMED_QTY, PROVISIONAL_QTY, and OVERCOMMITMENT_QTY — Capacity and commitment metrics used in resource planning.
• PROVISIONAL_FLAG, REVERSED_FLAG, NET_ZERO_FLAG, and REDUCE_CAPACITY_FLAG — Status and control indicators.
• Standard WHO audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, REQUEST_ID, PROGRAM_ID.

The documented unique index PA_FORECAST_ITEM_DETAILS_U1 spans (FORECAST_ITEM_ID, ITEM_DATE, LINE_NUM), establishing those three columns as the business-key candidate; no separate surrogate primary key is documented beyond the composite key implied by that index.

Common Use Cases and Queries

Typical reporting scenarios include extracting forecast labor hours by resource and period, reconciling provisional versus confirmed quantities, and analyzing utilization against capacity. A representative query pattern joins the detail table to its parent and lookups:

• Forecast detail by project and date: select from PA_FORECAST_ITEM_DETAILS joined to PA_FORECAST_ITEMS on FORECAST_ITEM_ID, filtered by ITEM_DATE range.
• Resource utilization reporting: aggregate ITEM_QUANTITY or CAPACITY_QUANTITY grouped by RESOURCE_ID, joined to PA_RESOURCES.
• Job-based forecasting: join JOB_ID to PER_JOBS to report requirements by job.
• Organization-level analysis: join EXPENDITURE_ORGANIZATION_ID to HR_ALL_ORGANIZATION_UNITS.
• Amount-type rollups: join AMOUNT_TYPE_ID to PA_AMOUNT_TYPES_B for grouping by amount classification.

Related Objects

• PA_FORECAST_ITEMS — Parent forecast item (FORECAST_ITEM_ID).
• PA_AMOUNT_TYPES_B — Amount type lookup (AMOUNT_TYPE_ID).
• PA_PROJECTS_ALL — Project master (PROJECT_ID).
• PA_RESOURCES — Resource definitions (RESOURCE_ID).
• PER_JOBS — Job definitions (JOB_ID).
• HR_ALL_ORGANIZATION_UNITS — Organization units (EXPENDITURE_ORGANIZATION_ID).

These joins enable comprehensive forecasting, utilization, and capacity reporting within the Oracle Projects module.