Results for “pa_rbs_headers_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_RBS_HEADERS_B is the base table in the Oracle EBS Projects (PA) module that stores Resource Breakdown Structure (RBS) header information which is not version specific. The RBS is a hierarchical classification of project resources — such as labor, expense, and organizations — used throughout Oracle Projects for resource grouping, budgeting, costing, and reporting. Because the header definition is independent of any particular RBS version or date range, PA_RBS_HEADERS_B acts as the stable anchor for the RBS structure, while versioned details and translated descriptions are held in separate related tables.

From a modeling perspective, the supplied relationship metadata classifies this object as hub-leaning within a Data Vault heuristic. PA_RBS_HEADERS_B carries the durable business key (RBS_HEADER_ID) and a limited set of descriptive attributes, while associated translation, version, and assignment tables attach detail to it. This positions the table as a natural hub candidate, with dependent tables behaving as satellites or links.

Key Information Stored

• RBS_HEADER_ID — Surrogate primary key defined by PA_RBS_HEADERS_B_PK, and also the subject of unique index PA_RBS_HEADERS_B_U1, confirming it as the documented business-key candidate.
• BUSINESS_GROUP_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS, identifying the business group that owns the RBS header.
• EFFECTIVE_FROM_DATE / EFFECTIVE_TO_DATE — Date-range boundary columns that govern the header's validity window.
• RECORD_VERSION_NUMBER — Optimistic-locking attribute used to detect concurrent updates.
• ACTIVE_FLAG — Indicates whether the RBS header is active and available for use.
• USE_FOR_ALLOC_FLAG — Controls whether the RBS is eligible for allocation processing.
• CBS_ENABLED — Indicates whether the Cost Breakdown Structure integration is enabled for this RBS.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS auditing columns recording who created and last modified the row and when.

Common Use Cases and Queries

Typical usage retrieves the organizational and control attributes of an RBS header, often joining to its translated name and its versions. A common pattern is:

• Resolving the RBS header for a business group: SELECT rbs_header_id, business_group_id, active_flag, cbs_enabled FROM pa_rbs_headers_b WHERE business_group_id = :p_bg_id AND active_flag = 'Y';
• Selecting headers valid as of a date using EFFECTIVE_FROM_DATE and EFFECTIVE_TO_DATE.
• Joining to PA_RBS_HEADERS_TL on RBS_HEADER_ID to obtain the user-facing RBS name in the session language.
• Joining to PA_RBS_VERSIONS_B on RBS_HEADER_ID to list all versions of a given RBS.
• Identifying which RBS structures are available for allocations via USE_FOR_ALLOC_FLAG, or which support Cost Breakdown Structure integration via CBS_ENABLED.

These queries support reporting on project resource structures, configuring budgeting and costing, and validating RBS setup prior to project or assignment creation.

Related Objects

• HR_ALL_ORGANIZATION_UNITS — Referenced by BUSINESS_GROUP_ID; the parent business group entity.
• PA_RBS_HEADERS_TL — Translation table referencing PA_RBS_HEADERS_B on RBS_HEADER_ID; stores language-specific descriptions.
• PA_RBS_VERSIONS_B — Version table referencing PA_RBS_HEADERS_B on RBS_HEADER_ID; holds date-versioned RBS detail.
• PA_RBS_PRJ_ASSIGNMENTS — References PA_RBS_HEADERS_B on RBS_HEADER_ID; associates an RBS header with projects.

Together these objects form the RBS header aggregate, with PA_RBS_HEADERS_B serving as the master record from which translations, versions, and project assignments depend.