Search Results pa_resource_classes_b




Overview
Explore in AI Chat

Overview

The PA_RESOURCE_CLASSES_B table is a core master data table within the Oracle E-Business Suite Projects module (PA). It serves as the primary repository for defining and storing resource classes, which are fundamental categorization entities used to group and manage project resources. Resource classes are essential for configuring planning, costing, and reporting functionalities. They act as a key dimension for defining resource breakdown structures, setting up planning defaults, and establishing resource formats. As a base table, it holds the transactional language-independent data, while its corresponding translation table, PA_RESOURCE_CLASSES_TL, stores the language-specific descriptions.

Key Information Stored

The table's primary column is the RESOURCE_CLASS_ID, a unique system-generated identifier serving as the primary key for all resource class records. While the provided ETRM metadata does not list all columns, standard implementation suggests the table typically includes columns for the resource class code (RESOURCE_CLASS_CODE), a start date active (START_DATE_ACTIVE), an end date active (END_DATE_ACTIVE), and standard Oracle EBS audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY. The RESOURCE_CLASS_ID is the critical foreign key referenced by numerous dependent objects to maintain data integrity across the resource management framework.

Common Use Cases and Queries

This table is central to queries involving resource categorization and setup. Common use cases include generating master lists of all active resource classes for setup purposes, validating resource class assignments, and supporting reports that analyze resource planning by class. A typical query to retrieve active resource classes, joining with the translation table for the description, would follow this pattern:

  • SELECT prcb.RESOURCE_CLASS_CODE, prctl.NAME, prcb.START_DATE_ACTIVE, prcb.END_DATE_ACTIVE
  • FROM PA.PA_RESOURCE_CLASSES_B prcb,
  • PA.PA_RESOURCE_CLASSES_TL prctl
  • WHERE prcb.RESOURCE_CLASS_ID = prctl.RESOURCE_CLASS_ID
  • AND prctl.LANGUAGE = USERENV('LANG')
  • AND SYSDATE BETWEEN NVL(prcb.START_DATE_ACTIVE, SYSDATE) AND NVL(prcb.END_DATE_ACTIVE, SYSDATE);

Data from this table is also frequently joined to planning and resource list tables for operational reporting.

Related Objects

As indicated by the foreign key relationships, PA_RESOURCE_CLASSES_B is a pivotal parent table. Key related objects include:

  • PA_RESOURCE_CLASSES_TL: The translation table that provides the language-specific NAME for each RESOURCE_CLASS_ID.
  • PA_PLAN_RES_DEFAULTS: References the table to define default planning options for resources belonging to a specific class.
  • PA_RESOURCE_LIST_MEMBERS: Uses the RESOURCE_CLASS_ID to assign individual resources to a resource class within a resource list.
  • PA_RES_FORMATS_B: References the table to associate a resource format layout with a particular resource class for reporting and data entry.

Direct modification of this table should be avoided; setups are typically performed via the Oracle Projects application interface, which maintains all related data integrity.