Search Results pa_res_types_b

Overview

The PA_RES_TYPES_B table is a core reference data table within the Oracle E-Business Suite Projects (PA) module. It serves as the master repository for defining and storing all resource types available for assignment and planning across project structures. A resource type is a fundamental classification, such as "Employee," "Contractor," or "Equipment," that categorizes the nature of a project resource. This table's integrity is critical as it underpins resource management, staffing, forecasting, and the definition of resource breakdown structures (RBS). Its role is to provide a standardized, controlled list of resource types that are referenced throughout the Projects application to ensure consistency in resource-related transactions and reporting.

Key Information Stored

The table's primary column is the RES_TYPE_ID, a unique system-generated identifier serving as the primary key for each resource type record. While the provided ETRM metadata does not list all columns, standard implementation columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY are invariably present for auditing. The base table (denoted by the '_B' suffix) typically holds seed data and transactional columns, while user-facing names and descriptions are stored in the corresponding translation table, PA_RES_TYPES_TL, keyed by the same RES_TYPE_ID and LANGUAGE column. This design supports multilingual implementations.

Common Use Cases and Queries

This table is primarily queried for validation, reporting, and setup purposes. Common scenarios include validating resource assignments during project staffing, generating reports that categorize project costs or effort by resource type, and administering the list of available resource types via setup forms. A fundamental query retrieves the active resource types for use in a list of values (LOV) or a report:

• SELECT res_type_id, name FROM pa_res_types_vl ORDER BY name;

Analytical queries often join this table to resource assignment or planning tables to summarize planned or actual quantities by resource type. Administrators may also query it to audit setup data or identify unused resource types before attempting to disable them, ensuring no foreign key dependencies are violated.

Related Objects

PA_RES_TYPES_B is central to the resource data model, with several key relationships documented in the ETRM. The primary key (RES_TYPE_ID) is referenced by the following objects:

• PA_RBS_ELEMENTS: The RESOURCE_TYPE_ID column in this table links a specific element within a Resource Breakdown Structure (RBS) to a resource type defined in PA_RES_TYPES_B.
• PA_RES_FORMATS_B: The RES_TYPE_ID column in this table associates a specific resource formatting rule or template with a resource type.
• PA_RES_TYPES_TL: The translation table, where RES_TYPE_ID and LANGUAGE form a unique key to store the user-readable name and description for each resource type in multiple languages.

For most application queries and reports, it is standard practice to use the view PA_RES_TYPES_VL (Verified for Language), which performs an outer join between PA_RES_TYPES_B and PA_RES_TYPES_TL to return the translated names based on the current session language.