Search Results pa_forecasting_options_all_u1

Overview

PA.PA_FORECASTING_OPTIONS_ALL is a setup and configuration table in the Oracle E-Business Suite Projects (PA) schema that stores the parameters and defaults governing utilization forecasting behavior. Each row defines the forecasting options for a single operating unit, so multi-organization installations must create and maintain one row per ORG_ID. Because the table is organization-striped, it carries the _ALL suffix, and the ORG_ID column is the discriminator enforced by the unique index PA_FORECASTING_OPTIONS_ALL_U1.

The table captures two broad categories of information: date-driven forecasting boundaries (the dates through which actuals and forecast utilization are calculated) and defaulting attributes for requirements, assignments, and transfer pricing, including labor expenditure types and transfer price amount types. Several legacy columns remain in the physical schema but are documented as obsolete and unused, reflecting the table's evolution across releases.

From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning. This is consistent with a table whose business key is effectively the operating unit identifier and whose non-key attributes are descriptive configuration values subject to change over time rather than transactional relationships.

Key Information Stored

Although the documented 12.2.2 schema contains 32 columns, the most operationally significant are:

• ORG_ID — the operating unit identifier. This is the business-key candidate, uniquely enforced by PA_FORECASTING_OPTIONS_ALL_U1. There is no separate surrogate primary key column documented; the organization identifier functions as the practical key.
• FORECAST_THRU_DATE — the date through which forecast utilization has been calculated.
• ACTUALS_THRU_DATE — the date through which actuals utilization has been calculated.
• DEFAULT_ASSIGN_EXP_TYPE_CLASS — default labor expenditure type class for the requirement or assignment, used in determining forecast burdened cost.
• DEFAULT_ASSIGN_EXP_TYPE — default labor expenditure type for the requirement or assignment.
• DEFAULT_TP_AMOUNT_TYPE — default transfer price amount type, used in classifying forecast cross-charged cost.
• BILL_UNASSIGN_TIME_FLAG and NONBILL_UNASSIGN_TIME_FLAG — flags controlling treatment of unassigned time for billable and non-billable scenarios.
• BILL_UNASSIGN_PROJ_ID, BILL_UNASSIGN_EXP_TYPE_CLASS, BILL_UNASSIGN_EXP_TYPE — defaulting targets for billable unassigned time.
• NONBILL_UNASSIGN_PROJ_ID, NONBILL_UNASSIGN_EXP_TYP_CLS, NONBILL_UNASSIGN_EXP_TYPE — equivalent defaults for non-billable unassigned time.
• JOB_COST_RATE_SCHEDULE_ID and KEY_MEMBER_ROLE_ID — rate schedule and role references used during forecast costing.
• FORECAST_CLASS_CATEGORY, ORG_FCST_PERIOD_TYPE, START_PERIOD_NAME, NUMBER_OF_PERIODS, and WEIGHTED_OR_FULL_CODE — parameters controlling forecast period generation and spreading.
• ORG_FCST_PROJECT_TEMPLATE_ID — foreign key to PA_PROJECTS_ALL, identifying the project template used for organization forecasting.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical usage centers on verifying forecasting setup per operating unit and auditing utilization calculation cutoffs. A common retrieval pattern selects configuration for a given organization:

• SELECT * FROM pa.pa_forecasting_options_all WHERE org_id = :org_id;
• Reporting on which operating units have stale FORECAST_THRU_DATE or ACTUALS_THRU_DATE values to detect forecasting jobs that have not run.
• Reviewing default expenditure type and transfer price amount type configuration before running forecast burdened cost calculations.
• Joining to PA_PROJECTS_ALL on ORG_FCST_PROJECT_TEMPLATE_ID = PROJECT_ID to confirm the template assigned to organization forecasting.
• Inspecting unassigned-time defaulting flags to reconcile how billable versus non-billable time is routed during forecast processing.

Related Objects

• PA.PA_PROJECTS_ALL — referenced via the documented foreign key ORG_FCST_PROJECT_TEMPLATE_ID → PROJECT_ID, linking the organization forecasting template.
• PA.PA_FORECASTING_OPTIONS_ALL_U1 — the unique index on ORG_ID that enforces one row per operating unit.
• HR_OPERATING_UNITS / HR_ALL_ORGANIZATION_UNITS — source of the ORG_ID operating unit definition used in multi-organization filtering.
• PA.PA_PROJECT_TEMPLATES and related template tables — consumed through ORG_FCST_PROJECT_TEMPLATE_ID when organization forecasting projects are created.
• PA.PA_EXPENDITURE_TYPES — supplies valid values for the default labor expenditure type and class columns.
• PA.PA_TRANSFER_PRICE_AMOUNT_TYPES — supplies values for DEFAULT_TP_AMOUNT_TYPE.
• Utilization and forecast reporting views in the PA schema that read these configuration values at runtime.