Search Results pa_resource_list_members

Overview

The PA_RESOURCE_LIST_MEMBERS table is a core transactional table within Oracle E-Business Suite Projects (PA) module, specifically for releases 12.1.1 and 12.2.2. It serves as the detailed repository for defining the specific resources that constitute a resource list. A resource list is a foundational construct used for planning, budgeting, and controlling project costs and assignments. This table stores each individual member entry, linking a resource—which can be a person, job, organization, vendor, non-labor item, or expenditure category—to a parent resource list header. Its role is critical for enforcing project financial and staffing policies, as transactions and forecasts are validated against the approved resources defined in this table.

Key Information Stored

The table's primary key is RESOURCE_LIST_MEMBER_ID, a unique identifier for each member record. Key foreign key columns define the member's relationship to other master data, including RESOURCE_LIST_ID (link to PA_RESOURCE_LISTS_ALL_BG), RESOURCE_ID (link to PA_RESOURCES for labor), and JOB_ID, ORGANIZATION_ID, and VENDOR_ID. For non-labor planning, critical columns include NON_LABOR_RESOURCE, EXPENDITURE_CATEGORY, EXPENDITURE_TYPE, and ITEM_CATEGORY_ID. The table also stores classification and formatting attributes via RESOURCE_CLASS_ID, RESOURCE_TYPE_ID, and RESOURCE_FORMAT_ID. The PARENT_MEMBER_ID column supports hierarchical groupings within a list, allowing for nested resource structures.

Common Use Cases and Queries

A primary use case is validating expenditure items or forecast lines against an approved project resource list. Integration points include Project Costing, Project Billing, and Project Management. Common reporting needs involve listing all resources available for a given project or template. A typical query to retrieve all labor resource members for a specific list would be:

• SELECT prlm.resource_list_member_id, prlm.resource_id, per.full_name
• FROM pa_resource_list_members prlm,
• pa_resources pr,
• per_all_people_f per
• WHERE prlm.resource_list_id = :p_list_id
• AND prlm.resource_id = pr.resource_id
• AND pr.person_id = per.person_id
• AND SYSDATE BETWEEN per.effective_start_date AND per.effective_end_date;

Another common scenario is analyzing resource list composition for audit purposes, joining to lookup tables like PA_RESOURCE_CLASSES_B and PA_RESOURCE_TYPES.

Related Objects

As indicated by its extensive foreign key constraints, PA_RESOURCE_LIST_MEMBERS has strong dependencies on numerous master data tables. Key related objects include the header table PA_RESOURCE_LISTS_ALL_BG and the labor resource definition in PA_RESOURCES. For non-labor, it relates to PA_NON_LABOR_RESOURCES, PA_EXPENDITURE_CATEGORIES, and MTL_CATEGORIES_B. It is referenced by the Grants Accounting (GMS) module, as shown by the foreign key from GMS_BALANCES.RESOURCE_LIST_MEMBER_ID. The table also integrates with Human Resources (PER_JOBS, HR_ALL_ORGANIZATION_UNITS), Supply Chain (BOM_RESOURCES), and Cost Management (CST_COST_TYPES), highlighting its central role in cross-modular project resource definition.