Search Results pa_resources_denorm




Overview
Explore in AI Chat

Overview

The PA_RESOURCES_DENORM table is a denormalized data structure within the Oracle E-Business Suite (EBS) Projects module (PA). Its primary role is to serve as a performance-optimized repository of resource attributes. By consolidating and flattening data from multiple related transactional tables, it provides a single, efficient point of access for reporting, analytics, and data retrieval processes that require comprehensive resource information. This denormalization is a common architectural pattern in EBS to improve the performance of complex joins across master data tables, particularly for high-volume reporting and integration scenarios.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the table's description and foreign key relationships define its core content. It stores a denormalized set of attributes pertaining to project resources. The documented foreign keys indicate it centrally holds the RESOURCE_ID, which links to the base PA_RESOURCES table. It also integrates key Human Resources data, including JOB_ID (linked to PER_JOBS) and RESOURCE_ORGANIZATION_ID (linked to HR_ALL_ORGANIZATION_UNITS). Typically, such a table would also contain pre-joined descriptive columns like resource name, job name, organization name, and other classification attributes to avoid runtime joins.

Common Use Cases and Queries

This table is predominantly used for reporting and data extraction where performance is critical. Common scenarios include generating resource utilization reports, building data marts for business intelligence tools, and supporting custom integrations that need a complete resource profile. A typical query pattern involves a simple SELECT from this single table instead of complex multi-table joins.

  • Sample Query for Resource Listing: SELECT resource_name, job_name, organization_name FROM pa_resources_denorm WHERE resource_organization_id = :p_org_id;
  • Reporting Use Case: It serves as the primary source for reports analyzing resource pools by job role or department, as all necessary descriptors are readily available in one row.

Related Objects

As per the provided metadata, PA_RESOURCES_DENORM has direct foreign key relationships with several core EBS tables, indicating its role as an integrator of information.

  • PA_RESOURCES: The foundational transactional table for project resources. PA_RESOURCES_DENORM is denormalized from and linked to this table via RESOURCE_ID.
  • PER_JOBS: The Jobs table from the Human Resources module. The JOB_ID foreign key integrates job classification data.
  • HR_ALL_ORGANIZATION_UNITS: The Organizations table from HR. The RESOURCE_ORGANIZATION_ID foreign key integrates the resource's assigned organization hierarchy data.
  • Table: PA_RESOURCES_DENORM 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RESOURCES_DENORM,  object_name:PA_RESOURCES_DENORM,  status:VALID,  product: PA - Projects ,  description: PA_RESOURCES_DENORM is a denormalized table containing attributes for resources. ,  implementation_dba_data: PA.PA_RESOURCES_DENORM , 

  • Table: PA_RESOURCES_DENORM 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_RESOURCES_DENORM,  object_name:PA_RESOURCES_DENORM,  status:VALID,  product: PA - Projects ,  description: PA_RESOURCES_DENORM is a denormalized table containing attributes for resources. ,  implementation_dba_data: PA.PA_RESOURCES_DENORM , 

  • View: PA_REP_ALL_MGR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_MGR_V,  object_name:PA_REP_ALL_MGR_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ALL_MGR_V is a view that list all direct and indirect managers in HR for a given application user has a Resource Authority ,  implementation_dba_data: APPS.PA_REP_ALL_MGR_V , 

  • View: PA_REP_ALL_MGR_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_MGR_V,  object_name:PA_REP_ALL_MGR_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ALL_MGR_V is a view that list all direct and indirect managers in HR for a given application user has a Resource Authority ,  implementation_dba_data: APPS.PA_REP_ALL_MGR_V , 

  • View: PA_REP_ALL_RES_MGR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_RES_MGR_V,  object_name:PA_REP_ALL_RES_MGR_V,  status:VALID,  product: PA - Projects ,  description: This view shows starting resource managers based on users security ,  implementation_dba_data: APPS.PA_REP_ALL_RES_MGR_V , 

  • View: PA_REP_ALL_RES_MGR_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_RES_MGR_V,  object_name:PA_REP_ALL_RES_MGR_V,  status:VALID,  product: PA - Projects ,  description: This view shows starting resource managers based on users security ,  implementation_dba_data: APPS.PA_REP_ALL_RES_MGR_V , 

  • View: PA_REP_MANAGERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_V,  object_name:PA_REP_MANAGERS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists all managers in the system ,  implementation_dba_data: APPS.PA_REP_MANAGERS_V , 

  • View: PA_REP_MANAGERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_V,  object_name:PA_REP_MANAGERS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists all managers in the system ,  implementation_dba_data: APPS.PA_REP_MANAGERS_V , 

  • View: PA_REP_MGR_ORG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MGR_ORG_V,  object_name:PA_REP_MGR_ORG_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_MGR_ORG_V is a view that lists all managers for the given organization ,  implementation_dba_data: APPS.PA_REP_MGR_ORG_V , 

  • View: PA_REP_RESOURCES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RESOURCES_V,  object_name:PA_REP_RESOURCES_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists resources ,  implementation_dba_data: APPS.PA_REP_RESOURCES_V , 

  • View: PA_REP_MGR_ORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MGR_ORG_V,  object_name:PA_REP_MGR_ORG_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_MGR_ORG_V is a view that lists all managers for the given organization ,  implementation_dba_data: APPS.PA_REP_MGR_ORG_V , 

  • View: PA_REP_RESOURCES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RESOURCES_V,  object_name:PA_REP_RESOURCES_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists resources ,  implementation_dba_data: APPS.PA_REP_RESOURCES_V , 

  • View: PA_CANDIDATE_LOG_AMG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CANDIDATE_LOG_AMG_V,  object_name:PA_CANDIDATE_LOG_AMG_V,  status:VALID,  product: PA - Projects ,  description: This view shows all candidate reviews. ,  implementation_dba_data: APPS.PA_CANDIDATE_LOG_AMG_V , 

  • View: PA_CANDIDATE_LOG_AMG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CANDIDATE_LOG_AMG_V,  object_name:PA_CANDIDATE_LOG_AMG_V,  status:VALID,  product: PA - Projects ,  description: This view shows all candidate reviews. ,  implementation_dba_data: APPS.PA_CANDIDATE_LOG_AMG_V , 

  • View: PA_RESOURCE_AUTHORITY_V 12.2.2

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

  • View: PA_TIMELINE_RESOURCE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_TIMELINE_RESOURCE_V,  object_name:PA_TIMELINE_RESOURCE_V,  status:VALID,  product: PA - Projects ,  description: View will be used to select resources (LOV) for rebuilding the timeline records using a concurrent program ,  implementation_dba_data: APPS.PA_TIMELINE_RESOURCE_V , 

  • View: PA_RES_EMP_HCOUNT_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_EMP_HCOUNT_V,  object_name:PA_RES_EMP_HCOUNT_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_EMP_HCOUNT_V is a view to provide employee headcounts by organization and periods. This information is used by OA Screens ,  implementation_dba_data: APPS.PA_RES_EMP_HCOUNT_V , 

  • View: PA_RESOURCE_AUTHORITY_V 12.1.1

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

  • View: PA_TIMELINE_RESOURCE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_TIMELINE_RESOURCE_V,  object_name:PA_TIMELINE_RESOURCE_V,  status:VALID,  product: PA - Projects ,  description: View will be used to select resources (LOV) for rebuilding the timeline records using a concurrent program ,  implementation_dba_data: APPS.PA_TIMELINE_RESOURCE_V , 

  • View: PA_REP_ORG_RES_COMP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_RES_COMP_V,  object_name:PA_REP_ORG_RES_COMP_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by organizations ,  implementation_dba_data: APPS.PA_REP_ORG_RES_COMP_V , 

  • View: PA_REP_PROJ_RES_COMP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_RES_COMP_V,  object_name:PA_REP_PROJ_RES_COMP_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by projects ,  implementation_dba_data: APPS.PA_REP_PROJ_RES_COMP_V , 

  • View: PA_RES_EMP_HCOUNT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_EMP_HCOUNT_V,  object_name:PA_RES_EMP_HCOUNT_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_EMP_HCOUNT_V is a view to provide employee headcounts by organization and periods. This information is used by OA Screens ,  implementation_dba_data: APPS.PA_RES_EMP_HCOUNT_V , 

  • View: PA_REP_PROJ_RES_COMP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_RES_COMP_V,  object_name:PA_REP_PROJ_RES_COMP_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by projects ,  implementation_dba_data: APPS.PA_REP_PROJ_RES_COMP_V , 

  • View: PA_REP_ORG_RES_COMP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_RES_COMP_V,  object_name:PA_REP_ORG_RES_COMP_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by organizations ,  implementation_dba_data: APPS.PA_REP_ORG_RES_COMP_V , 

  • View: PA_RESOURCE_AVAILABILITY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RESOURCE_AVAILABILITY_V,  object_name:PA_RESOURCE_AVAILABILITY_V,  status:VALID,  product: PA - Projects ,  description: PA_RESOURCE_AVAILABILITY_V is a view that shows all resources with their resource manager AND availability. ,  implementation_dba_data: APPS.PA_RESOURCE_AVAILABILITY_V , 

  • View: PA_RESOURCE_AVAILABILITY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RESOURCE_AVAILABILITY_V,  object_name:PA_RESOURCE_AVAILABILITY_V,  status:VALID,  product: PA - Projects ,  description: PA_RESOURCE_AVAILABILITY_V is a view that shows all resources with their resource manager AND availability. ,  implementation_dba_data: APPS.PA_RESOURCE_AVAILABILITY_V , 

  • View: PA_REP_ORG_COM_RES_LST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_COM_RES_LST_V,  object_name:PA_REP_ORG_COM_RES_LST_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_COM_RES_LST_V is a view that shows resource listing for organization and competence ,  implementation_dba_data: APPS.PA_REP_ORG_COM_RES_LST_V , 

  • View: PA_RESOURCE_AVAIL_STAFF_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RESOURCE_AVAIL_STAFF_V,  object_name:PA_RESOURCE_AVAIL_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RESOURCE_AVAIL_STAFF_V is a view that shows all resources with their resource manager AND availability. ,  implementation_dba_data: APPS.PA_RESOURCE_AVAIL_STAFF_V , 

  • View: PA_C_RES_DENORM_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_C_RES_DENORM_V,  object_name:PA_C_RES_DENORM_V,  status:VALID,  product: PA - Projects ,  description: PA_C_RES_DENORM_V is a view that identifies all resources that are available for use at this time or in the future based on resources available in Projects ,  implementation_dba_data: APPS.PA_C_RES_DENORM_V , 

  • View: PA_REP_ORG_COM_RES_LST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_COM_RES_LST_V,  object_name:PA_REP_ORG_COM_RES_LST_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_COM_RES_LST_V is a view that shows resource listing for organization and competence ,  implementation_dba_data: APPS.PA_REP_ORG_COM_RES_LST_V , 

  • View: PA_REP_RES_COMP_DTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_COMP_DTS_V,  object_name:PA_REP_RES_COMP_DTS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_COMP_DTS_V is a view that lists all resources and their organization, competencies details and job details ,  implementation_dba_data: APPS.PA_REP_RES_COMP_DTS_V , 

  • View: PA_RESOURCE_AVAIL_STAFF_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RESOURCE_AVAIL_STAFF_V,  object_name:PA_RESOURCE_AVAIL_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RESOURCE_AVAIL_STAFF_V is a view that shows all resources with their resource manager AND availability. ,  implementation_dba_data: APPS.PA_RESOURCE_AVAIL_STAFF_V , 

  • View: PA_RES_APRVL_ROLES_V 12.2.2

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

  • View: PA_REP_RES_COMP_DTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_COMP_DTS_V,  object_name:PA_REP_RES_COMP_DTS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_COMP_DTS_V is a view that lists all resources and their organization, competencies details and job details ,  implementation_dba_data: APPS.PA_REP_RES_COMP_DTS_V , 

  • View: PA_RES_APRVL_ROLES_V 12.1.1

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

  • View: PA_REP_ORG_COMP_SUM_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_COMP_SUM_V,  object_name:PA_REP_ORG_COMP_SUM_V,  status:VALID,  product: PA - Projects ,  description: A view that shows organization competence summary ,  implementation_dba_data: APPS.PA_REP_ORG_COMP_SUM_V , 

  • View: PA_REP_MANAGERS_DIST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_DIST_V,  object_name:PA_REP_MANAGERS_DIST_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_MANAGERS_DIST_V is a view that shows all distinct resource managers ,  implementation_dba_data: APPS.PA_REP_MANAGERS_DIST_V , 

  • View: PA_REP_MANAGERS_DIST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_DIST_V,  object_name:PA_REP_MANAGERS_DIST_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_MANAGERS_DIST_V is a view that shows all distinct resource managers ,  implementation_dba_data: APPS.PA_REP_MANAGERS_DIST_V , 

  • View: PA_REP_ORG_COMP_SUM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_COMP_SUM_V,  object_name:PA_REP_ORG_COMP_SUM_V,  status:VALID,  product: PA - Projects ,  description: A view that shows organization competence summary ,  implementation_dba_data: APPS.PA_REP_ORG_COMP_SUM_V , 

  • View: PA_REP_RES_ORGS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_ORGS_V,  object_name:PA_REP_RES_ORGS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_ORGS_V is a view that lists all organizations of the resources for the manager ,  implementation_dba_data: APPS.PA_REP_RES_ORGS_V , 

  • View: PA_RESOURCE_DETAILS_V 12.1.1

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

  • View: PA_RESOURCE_DETAILS_V 12.2.2

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

  • View: PA_REP_ASMT_RES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ASMT_RES_V,  object_name:PA_REP_ASMT_RES_V,  status:VALID,  product: PA - Projects ,  description: pa_rep_asmt_res_v is a view that shows all resources participating in assignments ,  implementation_dba_data: APPS.PA_REP_ASMT_RES_V , 

  • View: PA_REP_ASMT_RES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ASMT_RES_V,  object_name:PA_REP_ASMT_RES_V,  status:VALID,  product: PA - Projects ,  description: pa_rep_asmt_res_v is a view that shows all resources participating in assignments ,  implementation_dba_data: APPS.PA_REP_ASMT_RES_V , 

  • View: PA_REP_RES_ORGS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_ORGS_V,  object_name:PA_REP_RES_ORGS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_ORGS_V is a view that lists all organizations of the resources for the manager ,  implementation_dba_data: APPS.PA_REP_RES_ORGS_V , 

  • View: PA_REP_ASMT_DTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ASMT_DTS_V,  object_name:PA_REP_ASMT_DTS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ASMT_DTS_V is a view to show the deails of the assignments for organizations and projects ,  implementation_dba_data: APPS.PA_REP_ASMT_DTS_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_REP_ASMT_DTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ASMT_DTS_V,  object_name:PA_REP_ASMT_DTS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ASMT_DTS_V is a view to show the deails of the assignments for organizations and projects ,  implementation_dba_data: APPS.PA_REP_ASMT_DTS_V , 

  • View: PA_REP_RES_MGR_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_MGR_V,  object_name:PA_REP_RES_MGR_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_MGR_V is a view that list all direct and indirect managers in HR for a given application user ,  implementation_dba_data: APPS.PA_REP_RES_MGR_V , 

  • View: PA_REP_RES_MGR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_MGR_V,  object_name:PA_REP_RES_MGR_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_MGR_V is a view that list all direct and indirect managers in HR for a given application user ,  implementation_dba_data: APPS.PA_REP_RES_MGR_V ,