Search Results pa_res_availability




Overview
Explore in AI Chat

Overview

The PA_RES_AVAILABILITY table is a core transactional table within the Oracle E-Business Suite (EBS) Projects (PA) module, specifically in releases 12.1.1 and 12.2.2. It functions as the system of record for storing calculated resource capacity and utilization data. Its primary role is to hold the available, assigned, and overcommitted percentages and hours for a specific resource over a defined time period. This data is fundamental to resource management, capacity planning, and forecasting within the Projects application, enabling project managers to analyze resource workloads and identify potential bottlenecks or underutilization.

Key Information Stored

The table's structure is designed to capture time-phased resource metrics. While the full column list is not detailed in the provided metadata, the documented primary key and description indicate the presence of critical fields. The primary key consists of RESOURCE_ID, START_DATE, and RECORD_TYPE, which together uniquely identify a specific availability record for a resource at a period's start. Key data points stored include the available percent and hours (capacity), the assigned or committed percent and hours (utilization), and the resulting overcommitted percent and hours. The RECORD_TYPE column is significant for differentiating between different categories of data, such as baseline forecasts, current assignments, or different planning scenarios.

Common Use Cases and Queries

This table is central to resource analysis and reporting. A common use case is generating a resource availability report to compare capacity against assignments for a given date range. Another is identifying resources that are over-allocated (overcommitted) to proactively manage project staffing. Sample SQL patterns often involve aggregating hours by resource and period, or calculating utilization percentages. For example, a query to find overcommitted resources in a specific month might filter on the overcommitted hours column being greater than zero for that period's START_DATE. Data from this table is frequently sourced for custom dashboards and integration with external planning tools to provide a consolidated view of resource demand and supply.

Related Objects

PA_RES_AVAILABILITY has defined relationships with other key tables in the Projects schema, as per the provided foreign key metadata.

  • PA_RESOURCES: This is the primary parent table. The foreign key from PA_RES_AVAILABILITY.RESOURCE_ID to PA_RESOURCES ensures that every availability record is linked to a valid, defined resource in the system. Joining these tables is essential for enriching availability data with resource attributes like name, organization, and job role.

While not listed in the provided excerpt, this table is also conceptually related to assignment tables (e.g., PA_PROJECT_ASSIGNMENTS) which drive the committed hours, and is likely the source for summary views used by Oracle's standard resource management screens and reports.