Search Results pa_utilization_options_all_u1




Overview
Explore in AI Chat

Overview

PA.PA_UTILIZATION_OPTIONS_ALL is a configuration and state-tracking table in the Oracle Projects (PA) schema. It stores the operating-unit-level settings that govern how utilization information is calculated and displayed within Oracle Projects, together with the high-water dates reached by the most recent utilization processing runs. Because the table is defined per operating unit, it controls whether utilization reporting is driven by GL periods, PA periods, or global expenditure periods, and it records the cutoff dates through which actuals and forecast utilization have been computed.

The object resides in the APPS_TS_SEED tablespace, the standard repository for seed and setup data in Oracle E-Business Suite, which confirms its role as a configuration table rather than a high-volume transactional entity. The ETRM metadata records the table as VALID and flags it as Oracle Internal Use Only, meaning it is not supported for direct customer access outside standard Oracle Applications programs. Its structure is governed by the FND Design Data definition PA.PA_UTILIZATION_OPTIONS_ALL.

Applying a Data Vault modeling heuristic to the documented foreign key structure — a single reference from ORG_ID to HR_ALL_ORGANIZATION_UNITS with no downstream foreign keys pointing into this table — the object classifies as satellite-leaning. In this interpretation ORG_ID functions as the parent business key inherited from the organization hub, while the flag and date columns act as descriptive, non-key attributes that change over time as utilization processing advances. The classification is a modeling suggestion derived from key topology, not a statement of the physical design.

Key Information Stored

The table contains thirteen documented columns. The most significant are:

  • ORG_ID — Number identifying the Operating Unit for multi-organization installations. This column is the sole participant in the unique index PA_UTILIZATION_OPTIONS_ALL_U1, making it the documented business-key candidate and the natural unique identifier of each row. It is also the foreign key to HR_ALL_ORGANIZATION_UNITS.
  • GL_PERIOD_FLAG — Indicates whether utilization information is available by GL periods. Defaults to "N".
  • PA_PERIOD_FLAG — Indicates whether utilization information is available by PA periods. Defaults to "N".
  • GLOBAL_EXP_PERIOD_FLAG — Indicates whether utilization information is available by global expenditure periods. Defaults to "N".
  • ACTUALS_THRU_DATE — The date through which actual utilization has been calculated.
  • FORECAST_THRU_DATE — The date through which forecast utilization has been calculated.
  • ACTUALS_LAST_RUN_DATE — The date of the most recent utilization run for actuals.
  • FORECAST_LAST_RUN_DATE — The date of the most recent utilization run for forecast.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard Who columns recording audit and row-version information.

No separate surrogate primary key column is documented. The uniqueness constraint is enforced exclusively through the ORG_ID-based unique index, so ORG_ID serves simultaneously as surrogate and business key at the operating-unit grain.

Common Use Cases and Queries

Typical applications center on verifying configuration and tracking the currency of utilization data before running reports. A configuration audit retrieves the period-driver settings for a given operating unit:

  • SELECT ORG_ID, GL_PERIOD_FLAG, PA_PERIOD_FLAG, GLOBAL_EXP_PERIOD_FLAG FROM PA.PA_UTILIZATION_OPTIONS_ALL WHERE ORG_ID = :org_id;
  • SELECT ORG_ID, ACTUALS_THRU_DATE, FORECAST_THRU_DATE, ACTUALS_LAST_RUN_DATE, FORECAST_LAST_RUN_DATE FROM PA.PA_UTILIZATION_OPTIONS_ALL;
  • Reporting currency checks compare the thru dates against the current GL or PA period to determine whether a fresh utilization run is required.

Because the table is flagged Oracle Internal Use Only, these queries should be treated as read-only diagnostics rather than maintenance operations; updates belong to standard Oracle Projects programs.

Related Objects

  • HR_ALL_ORGANIZATION_UNITS — joined on ORG_ID; the FK parent supplying the organization/operating unit definition.
  • PA_UTILIZATION_OPTIONS_ALL_U1 — the unique index on ORG_ID that enforces one configuration row per operating unit.
  • PA_PERIODS and GL_PERIODS — period calendars referenced by the period-flag settings when resolving utilization windows.
  • PA_UTILIZATION — the utilization calculation entities whose output the run and thru dates summarise.
  • FND_FLEX_VALUES / FND_ID_FLEX_STRUCTURES — commonly joined when resolving period and organization key flexfield values.

No downstream tables were documented as referencing this object, consistent with its satellite-leaning classification.