Search Results pa_resource_lists_all_bg

Overview

The PA_RESOURCE_LISTS_ALL_BG table is a core setup and reference table within Oracle E-Business Suite Projects (PA) module. It serves as the master repository for implementation-defined resource lists, which are foundational constructs for financial planning and analysis. These lists define logical groupings of resources—such as employees, jobs, expenditure types, or other resource types—used for budgeting, forecasting, and summarizing project financial amounts. The table supports multi-organization structures, as indicated by the "_ALL_BG" suffix, meaning it stores data across multiple business groups. Its primary role is to provide a centralized, reusable definition of resource groupings that drive financial calculations and reporting consistency across projects.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the primary and foreign key relationships reveal the critical data attributes. The table's primary key is RESOURCE_LIST_ID, which uniquely identifies each resource list definition. Key foreign keys include GROUP_RESOURCE_TYPE_ID, linking to PA_RESOURCE_TYPES to define the category of resources in the list (e.g., "Person" or "Job"), and JOB_GROUP_ID, linking to PER_JOB_GROUPS for lists based on job groupings. Other essential columns typically include NAME, DESCRIPTION, and effective date columns (START_DATE_ACTIVE, END_DATE_ACTIVE). The table's structure is designed to support the hierarchical and categorical organization of project resources for financial purposes.

Common Use Cases and Queries

This table is central to configuration and reporting scenarios. A primary use case is during project type or financial plan configuration, where a specific resource list is assigned as the default for cost or revenue budgeting. For reporting, analysts query this table to understand the resource basis for budget versions or project summaries. Common SQL patterns include joining to its descriptive translation table (PA_RESOURCE_LISTS_TL) and member table (PA_RESOURCE_LIST_MEMBERS). A typical query to retrieve active resource lists with their type would be:

• SELECT prl.RESOURCE_LIST_ID, prlt.NAME, prt.RESOURCE_TYPE
  FROM PA_RESOURCE_LISTS_ALL_BG prl,
  PA_RESOURCE_LISTS_TL prlt,
  PA_RESOURCE_TYPES prt
  WHERE prl.RESOURCE_LIST_ID = prlt.RESOURCE_LIST_ID
  AND prl.GROUP_RESOURCE_TYPE_ID = prt.RESOURCE_TYPE_ID
  AND SYSDATE BETWEEN prl.START_DATE_ACTIVE AND NVL(prl.END_DATE_ACTIVE, SYSDATE+1);

Related Objects

As evidenced by its extensive foreign key relationships, PA_RESOURCE_LISTS_ALL_BG is a heavily referenced master table. Key dependent objects include:

• Budgeting & Forecasting: PA_BUDGET_VERSIONS, PA_PROJ_FP_OPTIONS, and GMS_BUDGET_VERSIONS (for Grants) directly reference a resource list to define the budget structure.
• Project Setup: PA_PROJECT_TYPES_ALL uses it for default cost and revenue budget lists.
• Allocation Rules: PA_ALLOC_RULES_ALL uses it to define both the allocation basis and the resources being allocated.
• Accumulation & Summarization: PA_PROJECT_ACCUM_HEADERS and PA_RESOURCE_ACCUM_DETAILS use it for project summary processes.
• List Definition Details: PA_RESOURCE_LIST_MEMBERS stores the individual resources within each list, and PA_RESOURCE_LISTS_TL stores translated names.