Search Results pa_role_profile_lines




Overview
Explore in AI Chat

Overview

PA_ROLE_PROFILE_LINES is a child table within the Oracle Projects (PA) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the individual project roles that make up a project role profile, together with the weighting assigned to each role. A role profile in Oracle Projects is a reusable template that defines which project roles participate in a given staffing or evaluation model and how much each role contributes, expressed as a percentage. The critical business rule enforced by this table is that the sum of role weightings for any single profile must equal 100. This constraint governs the integrity of every profile created in the application and is validated at the application layer when profile lines are entered or amended.

The table resides in the PA schema and holds eight documented columns. Based on the foreign key structure mined from the data model, the object is best characterized, as a modeling suggestion, as a standalone or link-style entity rather than a hub or satellite: it has no parent foreign key to a profile header in the documented FK data, but it does reference PA_PROJECT_ROLE_TYPES through PROJECT_ROLE_ID, making it a relationship carrier between a profile and the role definitions used across Projects.

Key Information Stored

The eight documented columns capture both the business content of each profile line and the standard Oracle EBS audit trail. The most important columns are:

  • PROFILE_ID — Identifies the project role profile to which the line belongs. Together with PROJECT_ROLE_ID it forms the natural composite business key for a line.
  • PROJECT_ROLE_ID — The project role being weighted, joining to PA_PROJECT_ROLE_TYPES. This is the FK documented for the table.
  • ROLE_WEIGHTING — The percentage weight assigned to the role within the profile. The sum across all lines for a given PROFILE_ID must equal 100.
  • CREATED_BY, CREATION_DATE — Standard audit columns recording the user and timestamp of the initial insert.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns recording the most recent change to the line.
  • LAST_UPDATE_LOGIN — The login session identifier associated with the last update, used for audit sequencing in a multi-user environment.

No separate surrogate primary key column is documented beyond the profile/role pairing; the composite of PROFILE_ID and PROJECT_ROLE_ID serves as the defacto unique identifier, while PROFILE_ID and PROJECT_ROLE_ID are the primary business-key candidates.

Common Use Cases and Queries

Typical usage centers on profile definition review, weight validation, and staffing or resource reporting. A common validation query checks that each profile's weightings sum to 100:

  • Weight integrity check: SELECT PROFILE_ID, SUM(ROLE_WEIGHTING) FROM PA_ROLE_PROFILE_LINES GROUP BY PROFILE_ID HAVING SUM(ROLE_WEIGHTING) <> 100;
  • Role composition lookup: SELECT l.PROFILE_ID, r.ROLE_NAME, l.ROLE_WEIGHTING FROM PA_ROLE_PROFILE_LINES l, PA_PROJECT_ROLE_TYPES r WHERE l.PROJECT_ROLE_ID = r.PROJECT_ROLE_ID ORDER BY l.PROFILE_ID, l.ROLE_WEIGHTING DESC;
  • Audit extraction: query CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE to identify recently modified weightings for change-control review.

Reporting scenarios include staffing model documentation, competence or evaluation weighting analysis, and migration validation when copying profiles between environments.

Related Objects

The following objects are the most significant related tables and dependencies:

  • PA_PROJECT_ROLE_TYPES — Referenced by PROJECT_ROLE_ID; supplies the role name and definition for each weighted line.
  • PA_ROLE_PROFILES — The profile header table; PROFILE_ID in this table corresponds to the profile identifier held at header level, forming the parent-child relationship for profile composition.
  • PA_PROJECT_ROLE_TYPES_TL — Provides translated role descriptions for reporting.
  • PA_PROJECT_ASSIGNMENTS — Consumes role information in staffing decisions that may draw on profile definitions.
  • PA_RESOURCE_ASSIGNMENTS — Uses project role references in resource planning related to weighted profiles.

Together these objects support the end-to-end definition, validation, and reporting of project role profiles across Oracle EBS 12.1.1 and 12.2.2.