Search Results pa_role_profiles




Overview
Explore in AI Chat

Overview

The PA_ROLE_PROFILES table is a core data object within the Oracle E-Business Suite Projects module (PA). It functions as the central repository for defining and storing project role profiles, which are essential for resource management and costing. A project role profile establishes the business-level attributes—such as job, position, and organization—that determine the costing and billing rates applicable to a resource when they are assigned to a project task in a specific role. The table supports two distinct profile types: resource-specific profiles, which are linked to an individual resource, and default business-level profiles, which serve as templates or fallback options. This structure enables flexible and granular control over how labor and other costs are calculated and captured across the project portfolio.

Key Information Stored

The table's primary function is to associate a project role with specific business attributes. While the full column list is not provided in the metadata, the documented foreign keys reveal its critical data elements. The core identifier is likely a PROFILE_ID. Crucially, the table stores a RESOURCE_ID to link to the PA_RESOURCES table for resource-specific profiles. For defining the business context, it holds a JOB_ID (referencing PER_JOBS), a POSITION_ID (referencing PER_ALL_POSITIONS), and an ORGANIZATION_ID (referencing HR_ALL_ORGANIZATION_UNITS). The table must also store a PROJECT_ROLE_ID to define the role itself and a column to distinguish between the 'resource profile' and 'default' profile types mentioned in the description. These columns collectively define the qualifying conditions for applying a specific set of rates.

Common Use Cases and Queries

This table is primarily accessed for rate derivation during transaction processing (like expenditure entry) and for reporting on resource costing setups. A common operational query involves finding the applicable rate profile for a given resource, role, and date to validate cost calculations. For example, a report to list all resource-specific role profiles would join PA_ROLE_PROFILES to PA_RESOURCES and PER_JOBS. Administrators may query the table to audit and maintain default profiles, ensuring correct fallback rates exist for common job and role combinations. Furthermore, integration points with Oracle Project Costing and Project Billing will reference this table to determine the correct RAW_COST and BURDENED_COST rates for labor transactions based on the matching attributes of the expenditure item.

Related Objects

As indicated by its foreign keys, PA_ROLE_PROFILES has direct dependencies on several fundamental HR and Projects tables. Its primary relationship is with PA_RESOURCES, which stores the detailed resource record. For business attribute validation, it references PER_JOBS, PER_ALL_POSITIONS, and HR_ALL_ORGANIZATION_UNITS. The table is intrinsically linked to the rate definition tables (such as PA_COST_BASE_EXPENDITURES, PA_BILL_BASE_EXPENDITURES), which use the profile identifier to store the actual rate values. Key APIs, like the PA_RESOURCE_PVT package, likely create and maintain records in this table. For reporting, it is commonly joined to PA_PROJECT_ROLES_TL for the role name and to the HR tables for descriptive job, position, and organization names.

  • Table: PA_ROLE_PROFILES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ROLE_PROFILES,  object_name:PA_ROLE_PROFILES,  status:VALID,  product: PA - Projects ,  description: PA_ROLE_PROFILES stores business level attributes and resource id for each project role profile. The entries are categorized into two types: resource profile and business level specific (default) profile. A resource profile has all business ,  implementation_dba_data: PA.PA_ROLE_PROFILES , 

  • Table: PA_ROLE_PROFILES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_ROLE_PROFILES,  object_name:PA_ROLE_PROFILES,  status:VALID,  product: PA - Projects ,  description: PA_ROLE_PROFILES stores business level attributes and resource id for each project role profile. The entries are categorized into two types: resource profile and business level specific (default) profile. A resource profile has all business ,  implementation_dba_data: PA.PA_ROLE_PROFILES , 

  • View: PA_RES_PROFILES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_PROFILES_V,  object_name:PA_RES_PROFILES_V,  status:VALID,  product: PA - Projects ,  description: This view shows the detail information of the resource role profiles ,  implementation_dba_data: APPS.PA_RES_PROFILES_V , 

  • View: PA_RES_PROFILES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_PROFILES_V,  object_name:PA_RES_PROFILES_V,  status:VALID,  product: PA - Projects ,  description: This view shows the detail information of the resource role profiles ,  implementation_dba_data: APPS.PA_RES_PROFILES_V , 

  • Table: PA_RESOURCES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RESOURCES,  object_name:PA_RESOURCES,  status:VALID,  product: PA - Projects ,  description: Resources used in budgeting and project summary amounts ,  implementation_dba_data: PA.PA_RESOURCES , 

  • View: PA_ROLE_PROFILE_LINES_V 12.1.1

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

  • View: PA_ROLE_PROFILE_LINES_V 12.2.2

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

  • Table: PA_RESOURCES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RESOURCES,  object_name:PA_RESOURCES,  status:VALID,  product: PA - Projects ,  description: Resources used in budgeting and project summary amounts ,  implementation_dba_data: PA.PA_RESOURCES , 

  • View: PA_DEFAULT_PROFILES_V 12.1.1

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

  • View: PA_DEFAULT_PROFILES_V 12.2.2

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