Search Results pa_resource_maps

Overview

The PA_RESOURCE_MAPS table is a core transactional table within the Oracle E-Business Suite Projects (PA) module, specifically in versions 12.1.1 and 12.2.2. Its primary function is to store the detailed mapping rules that link a member of a resource list to a specific combination of resource transaction attributes. This mapping is a critical component of the Project Resource Management functionality, enabling the system to automatically determine the correct resource—be it an employee, job, vendor, or non-labor item—to charge when a transaction is entered, based on attributes like expenditure type, category, event type, and organization. It acts as the execution layer for resource list assignments, translating high-level assignment rules into precise, actionable mappings.

Key Information Stored

The table stores the linkage between a resource list member and the transaction context. Key columns include the foreign key RESOURCE_LIST_ASSIGNMENT_ID, which ties the map to its parent assignment rule. The RESOURCE_LIST_MEMBER_ID identifies the specific member within a resource list. Crucially, the table holds attribute columns that define the transaction context for the mapping, such as EXPENDITURE_TYPE, EXPENDITURE_CATEGORY, EVENT_TYPE, ORGANIZATION_ID, and JOB_ID. The resulting target resource is identified by either RESOURCE_ID (for labor), VENDOR_ID, or NON_LABOR_RESOURCE. The SYSTEM_LINKAGE_FUNCTION column links to integration points with other modules like Purchasing or General Ledger.

Common Use Cases and Queries

This table is central to transaction processing and audit reporting. A common operational use case is troubleshooting why a particular resource was automatically selected for a project expenditure item. Administrators query this table to validate and audit mapping rules. A typical diagnostic SQL pattern joins PA_RESOURCE_MAPS to PA_RESOURCE_LIST_ASSIGNMENTS and PA_RESOURCE_LIST_MEMBERS to see all active mappings for a given project or resource list. For reporting, queries often aggregate mappings by expenditure type or organization to analyze coverage and identify gaps in resource assignment rules. Sample query:

SELECT prm.expenditure_type, prm.resource_id, prl.name resource_list_name FROM pa_resource_maps prm, pa_resource_lists_all_bg prl WHERE prm.resource_list_id = prl.resource_list_id AND prm.organization_id = 100;

Related Objects

PA_RESOURCE_MAPS has extensive foreign key relationships, underscoring its integrative role. Key documented dependencies include:

PA_RESOURCE_LIST_ASSIGNMENTS: Via RESOURCE_LIST_ASSIGNMENT_ID. This is the parent assignment rule.
PA_RESOURCE_LIST_MEMBERS and PA_RESOURCE_LISTS_ALL_BG: Via RESOURCE_LIST_MEMBER_ID and RESOURCE_LIST_ID, defining the source list and member.
PA_RESOURCES: Via RESOURCE_ID, for mapped labor resources.
HR_ALL_ORGANIZATION_UNITS, PER_JOBS, PO_VENDORS: Via ORGANIZATION_ID, JOB_ID, and VENDOR_ID, for mapping context and targets.
PA_EXPENDITURE_TYPES, PA_EXPENDITURE_CATEGORIES, PA_EVENT_TYPES, PA_NON_LABOR_RESOURCES: Via their respective columns, defining the transactional attributes for the mapping.
PA_SYSTEM_LINKAGES: Via SYSTEM_LINKAGE_FUNCTION, for cross-module integration.

Table: PA_RESOURCE_MAPS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RESOURCE_MAPS, object_name:PA_RESOURCE_MAPS, status:VALID, product: PA - Projects , description: Mapping of a resource list member to a combination of resource transaction attributes , implementation_dba_data: PA.PA_RESOURCE_MAPS ,
Table: PA_RESOURCE_MAPS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RESOURCE_MAPS, object_name:PA_RESOURCE_MAPS, status:VALID, product: PA - Projects , description: Mapping of a resource list member to a combination of resource transaction attributes , implementation_dba_data: PA.PA_RESOURCE_MAPS ,
Table: PA_RESOURCE_LIST_MEMBERS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RESOURCE_LIST_MEMBERS, object_name:PA_RESOURCE_LIST_MEMBERS, status:VALID, product: PA - Projects , description: Resources within a resource list , implementation_dba_data: PA.PA_RESOURCE_LIST_MEMBERS ,
Table: PA_RESOURCE_LIST_MEMBERS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RESOURCE_LIST_MEMBERS, object_name:PA_RESOURCE_LIST_MEMBERS, status:VALID, product: PA - Projects , description: Resources within a resource list , implementation_dba_data: PA.PA_RESOURCE_LIST_MEMBERS ,
Table: PA_RESOURCE_LIST_ASSIGNMENTS 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RESOURCE_LIST_ASSIGNMENTS, object_name:PA_RESOURCE_LIST_ASSIGNMENTS, status:VALID, product: PA - Projects , description: Resource list assignments to projects , implementation_dba_data: PA.PA_RESOURCE_LIST_ASSIGNMENTS ,
Table: PA_NON_LABOR_RESOURCES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_NON_LABOR_RESOURCES, object_name:PA_NON_LABOR_RESOURCES, status:VALID, product: PA - Projects , description: Non-labor assets utilized during project work , implementation_dba_data: PA.PA_NON_LABOR_RESOURCES ,
Table: PA_EVENT_TYPES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_EVENT_TYPES, object_name:PA_EVENT_TYPES, status:VALID, product: PA - Projects , description: Implementation-defined classifications of events , implementation_dba_data: PA.PA_EVENT_TYPES ,
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 ,
Table: PA_RESOURCE_LIST_ASSIGNMENTS 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RESOURCE_LIST_ASSIGNMENTS, object_name:PA_RESOURCE_LIST_ASSIGNMENTS, status:VALID, product: PA - Projects , description: Resource list assignments to projects , implementation_dba_data: PA.PA_RESOURCE_LIST_ASSIGNMENTS ,
Table: PA_NON_LABOR_RESOURCES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_NON_LABOR_RESOURCES, object_name:PA_NON_LABOR_RESOURCES, status:VALID, product: PA - Projects , description: Non-labor assets utilized during project work , implementation_dba_data: PA.PA_NON_LABOR_RESOURCES ,
Table: PA_EXPENDITURE_CATEGORIES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_EXPENDITURE_CATEGORIES, object_name:PA_EXPENDITURE_CATEGORIES, status:VALID, product: PA - Projects , description: Implementation-defined groupings of expenditure types by type of cost , implementation_dba_data: PA.PA_EXPENDITURE_CATEGORIES ,
Table: PA_EVENT_TYPES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_EVENT_TYPES, object_name:PA_EVENT_TYPES, status:VALID, product: PA - Projects , description: Implementation-defined classifications of events , implementation_dba_data: PA.PA_EVENT_TYPES ,
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 ,
Table: PA_EXPENDITURE_CATEGORIES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_EXPENDITURE_CATEGORIES, object_name:PA_EXPENDITURE_CATEGORIES, status:VALID, product: PA - Projects , description: Implementation-defined groupings of expenditure types by type of cost , implementation_dba_data: PA.PA_EXPENDITURE_CATEGORIES ,
Table: PA_SYSTEM_LINKAGES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_SYSTEM_LINKAGES, object_name:PA_SYSTEM_LINKAGES, status:VALID, product: PA - Projects , description: System-defined categories that classify expenditure types and determine how expenditure items of each type are processed , implementation_dba_data: PA.PA_SYSTEM_LINKAGES ,
Table: PA_SYSTEM_LINKAGES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_SYSTEM_LINKAGES, object_name:PA_SYSTEM_LINKAGES, status:VALID, product: PA - Projects , description: System-defined categories that classify expenditure types and determine how expenditure items of each type are processed , implementation_dba_data: PA.PA_SYSTEM_LINKAGES ,
Table: PA_RESOURCE_LISTS_ALL_BG 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RESOURCE_LISTS_ALL_BG, object_name:PA_RESOURCE_LISTS_ALL_BG, status:VALID, product: PA - Projects , description: Implementation-defined lists of resources for budgeting and project summary amounts , implementation_dba_data: PA.PA_RESOURCE_LISTS_ALL_BG ,
Table: PA_RESOURCE_LISTS_ALL_BG 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_RESOURCE_LISTS_ALL_BG, object_name:PA_RESOURCE_LISTS_ALL_BG, status:VALID, product: PA - Projects , description: Implementation-defined lists of resources for budgeting and project summary amounts , implementation_dba_data: PA.PA_RESOURCE_LISTS_ALL_BG ,
Table: PA_EXPENDITURE_TYPES 12.2.2
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_EXPENDITURE_TYPES, object_name:PA_EXPENDITURE_TYPES, status:VALID, product: PA - Projects , description: Implementation-defined classifications of expenditures charged to projects and tasks , implementation_dba_data: PA.PA_EXPENDITURE_TYPES ,
Table: PA_EXPENDITURE_TYPES 12.1.1
owner:PA, object_type:TABLE, fnd_design_data:PA.PA_EXPENDITURE_TYPES, object_name:PA_EXPENDITURE_TYPES, status:VALID, product: PA - Projects , description: Implementation-defined classifications of expenditures charged to projects and tasks , implementation_dba_data: PA.PA_EXPENDITURE_TYPES ,