Results for “wp_usage_flag”

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

Overview

PA_RBS_PRJ_ASSIGNMENTS is a Projects (PA) module table that stores the association between a Resource Breakdown Structure (RBS) and a project. In Oracle EBS 12.1.1 and 12.2.2, an RBS defines the hierarchical resource structure used for planning, reporting, and capturing project effort and cost. This table records which RBS versions and headers are assigned to a given project, and it controls how the assigned RBS is used across reporting, workplan, and financial plan contexts.

The table resides in the PA schema and is implemented as PA.PA_RBS_PRJ_ASSIGNMENTS, secured by the primary key constraint PA_RBS_PRJ_ASSIGN_PK on RBS_PRJ_ASSIGNMENT_ID. Based on the foreign key structure provided in the ETRM metadata, the table exhibits the characteristics of a link entity in a Data Vault model: it resolves many-to-many style relationships between projects and RBS definitions rather than acting as an independent hub or a descriptive satellite. This classification should be treated as a modeling suggestion only.

Key Information Stored

Each row represents a single assignment of an RBS version to a project. The most significant columns include:

• RBS_PRJ_ASSIGNMENT_ID — The surrogate primary key, sourced from the sequence-backed PA_RBS_PRJ_ASSIGN_PK constraint and the unique index PA_RBS_PRJ_ASSIGNMENTS_U1. It uniquely identifies each RBS-to-project assignment.
• PROJECT_ID — Foreign key to PA_PROJECTS_ALL, identifying the project receiving the RBS assignment.
• RBS_VERSION_ID — Foreign key to PA_RBS_VERSIONS_B, denoting the specific RBS version involved.
• RBS_HEADER_ID — Foreign key to PA_RBS_HEADERS_B, linking to the RBS header definition.
• REPORTING_USAGE_FLAG, WP_USAGE_FLAG, FP_USAGE_FLAG, and PROG_REP_USAGE_FLAG — Usage indicator flags that govern whether the assignment applies to reporting, workplan, financial plan, and progress reporting respectively.
• PRIMARY_REPORTING_RBS_FLAG — Marks the assignment as the primary RBS used for reporting when multiple assignments exist.
• ASSIGNMENT_STATUS — Tracks the lifecycle state of the assignment (for example, active or inactive).
• RECORD_VERSION_NUMBER — Supports optimistic concurrency control during updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns capturing who created and modified the record and when.

Common Use Cases and Queries

Typical scenarios include determining which RBS is assigned to a project, identifying the primary reporting RBS, and validating usage flags before enabling workplan or financial plan functionality. The following pattern joins the assignment to its principal parents:

• Project RBS listing: SELECT a.PROJECT_ID, a.RBS_VERSION_ID, a.RBS_HEADER_ID, a.PRIMARY_REPORTING_RBS_FLAG, a.ASSIGNMENT_STATUS FROM PA_RBS_PRJ_ASSIGNMENTS a WHERE a.PROJECT_ID = :project_id;
• Primary reporting RBS lookup: Filter on PRIMARY_REPORTING_RBS_FLAG = 'Y' to isolate the reporting RBS for a project.
• Usage analysis: Query WP_USAGE_FLAG or FP_USAGE_FLAG to audit which assignments support workplan or financial plan processing.
• Reporting use cases include reconciliation of project resource structures, RBS assignment audits, and data migration validation prior to upgrades between 12.1.1 and 12.2.2.

Related Objects

PA_RBS_PRJ_ASSIGNMENTS depends on several core Projects objects through documented foreign keys and is queried alongside others:

• PA_PROJECTS_ALL — Referenced via PROJECT_ID; the primary project master.
• PA_RBS_VERSIONS_B — Referenced via RBS_VERSION_ID; holds RBS version definitions.
• PA_RBS_HEADERS_B — Referenced via RBS_HEADER_ID; holds RBS header definitions.
• PA_RBS_PRJ_ASSIGN_PK — The primary key constraint governing uniqueness of RBS_PRJ_ASSIGNMENT_ID.
• PA_RBS_PRJ_ASSIGNMENTS_U1 — The unique index on RBS_PRJ_ASSIGNMENT_ID, serving as the business-key candidate.

Together these relationships establish the assignment as the connective record linking project master data to the RBS definition hierarchy.