Search Results pa_rbs_headers_b




Overview
Explore in AI Chat

Overview

The PA_RBS_HEADERS_B table is a core data object within the Oracle E-Business Suite Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for Resource Breakdown Structure (RBS) header information that is not specific to any particular version of an RBS. An RBS is a hierarchical framework used to categorize and organize project resources, which is fundamental for planning, budgeting, and reporting. This table acts as the parent entity, storing the foundational, non-versioned attributes of an RBS, while its version-specific details and translations are maintained in related tables. Its primary role is to provide a stable identifier and core metadata for each unique RBS defined within a business group.

Key Information Stored

The table's primary key is the RBS_HEADER_ID, a unique system-generated identifier for each RBS. A critical foreign key column is BUSINESS_GROUP_ID, which links to HR_ALL_ORGANIZATION_UNITS and enforces the security and partitioning of RBS data by the business group, a fundamental organizational construct in Oracle HRMS. Other important columns typically include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY for auditing purposes. While the provided metadata does not list all columns, the table's description confirms it holds invariant header data such as the RBS name, status, and other attributes that remain constant across all versions of that RBS.

Common Use Cases and Queries

This table is central to queries that list all RBS definitions within the system or a specific business group, often for administration or setup validation. A common reporting use case involves joining it with the version table to analyze the evolution of RBS structures over time. For instance, to retrieve a list of all active RBS headers with their latest version, one might use a query pattern such as:

  • SELECT ph.rbs_header_id, ph.business_group_id, pv.version_number, pv.name FROM pa_rbs_headers_b ph, pa_rbs_versions_b pv WHERE ph.rbs_header_id = pv.rbs_header_id AND pv.current_version_flag = 'Y';

It is also frequently referenced in data fix scripts, migration programs, and custom integrations that need to manage or synchronize RBS master data.

Related Objects

The PA_RBS_HEADERS_B table has defined foreign key relationships with several key objects, as documented in the ETRM metadata:

  • HR_ALL_ORGANIZATION_UNITS: Linked via PA_RBS_HEADERS_B.BUSINESS_GROUP_ID. This enforces that every RBS is associated with a valid business group.
  • PA_RBS_VERSIONS_B: Linked via PA_RBS_VERSIONS_B.RBS_HEADER_ID. This is a critical one-to-many relationship where each header can have multiple versions, storing the time-sensitive structural details of the RBS.
  • PA_RBS_HEADERS_TL: Linked via PA_RBS_HEADERS_TL.RBS_HEADER_ID. This table holds the translated names and descriptions for the RBS header, supporting multiple languages.

These relationships form the core data model for managing Resource Breakdown Structures in Oracle Projects.

  • Table: PA_RBS_HEADERS_B 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RBS_HEADERS_B,  object_name:PA_RBS_HEADERS_B,  status:VALID,  product: PA - Projects ,  description: This table stores the RBS Header information that is not version specific. ,  implementation_dba_data: PA.PA_RBS_HEADERS_B , 

  • Table: PA_RBS_HEADERS_B 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RBS_HEADERS_B,  object_name:PA_RBS_HEADERS_B,  status:VALID,  product: PA - Projects ,  description: This table stores the RBS Header information that is not version specific. ,  implementation_dba_data: PA.PA_RBS_HEADERS_B , 

  • Table: PA_RBS_HEADERS_TL 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RBS_HEADERS_TL,  object_name:PA_RBS_HEADERS_TL,  status:VALID,  product: PA - Projects ,  description: Stores all translated RBS header information that is not version specific. ,  implementation_dba_data: PA.PA_RBS_HEADERS_TL , 

  • Table: PA_RBS_HEADERS_TL 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RBS_HEADERS_TL,  object_name:PA_RBS_HEADERS_TL,  status:VALID,  product: PA - Projects ,  description: Stores all translated RBS header information that is not version specific. ,  implementation_dba_data: PA.PA_RBS_HEADERS_TL , 

  • View: PA_RBS_HEADERS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RBS_HEADERS_VL,  object_name:PA_RBS_HEADERS_VL,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_RBS_HEADERS_VL , 

  • Table: PA_RBS_VERSIONS_B 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RBS_VERSIONS_B,  object_name:PA_RBS_VERSIONS_B,  status:VALID,  product: PA - Projects ,  description: This table stores the RBS information that is version specific. ,  implementation_dba_data: PA.PA_RBS_VERSIONS_B , 

  • Table: PA_RBS_VERSIONS_B 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RBS_VERSIONS_B,  object_name:PA_RBS_VERSIONS_B,  status:VALID,  product: PA - Projects ,  description: This table stores the RBS information that is version specific. ,  implementation_dba_data: PA.PA_RBS_VERSIONS_B , 

  • View: PA_RBS_HEADERS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RBS_HEADERS_VL,  object_name:PA_RBS_HEADERS_VL,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_RBS_HEADERS_VL , 

  • View: PA_RBS_HEADERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RBS_HEADERS_V,  object_name:PA_RBS_HEADERS_V,  status:VALID,  product: PA - Projects ,  description: This view shows the header information, such as dates and usage, for a resource breakdown structure. ,  implementation_dba_data: APPS.PA_RBS_HEADERS_V , 

  • View: PA_RBS_HEADERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RBS_HEADERS_V,  object_name:PA_RBS_HEADERS_V,  status:VALID,  product: PA - Projects ,  description: This view shows the header information, such as dates and usage, for a resource breakdown structure. ,  implementation_dba_data: APPS.PA_RBS_HEADERS_V ,