Search Results use_for_wp_flag

Overview

PA_RESOURCE_LISTS_ALL_BG is the base table in the Oracle Projects (PA) schema that stores implementation-defined lists of resources used for budgeting and project summary amounts. A resource list defines a named grouping of resources—such as expenditure categories, job groups, or item master entries—that Oracle Projects uses to aggregate, plan, and report cost and revenue figures consistently across a project or project type. In Oracle EBS 12.1.1 and 12.2.2 the table is the anchor for resource-based budgeting, summary amount generation, allocation basis definitions, and project forecasting options.

Under the ETRM Data Vault heuristic classification derived from its foreign-key structure, PA_RESOURCE_LISTS_ALL_BG functions as a hub. It carries the surrogate identifier RESOURCE_LIST_ID as its declared primary key (PA_RESOURCE_LISTS_PK) and is referenced extensively by many downstream transactional and configuration tables, while itself referencing only a small number of code and group tables. This pattern is characteristic of a hub entity in a dimensional or Data Vault modeling view, though the table as shipped is a fully normalized OLTP structure rather than a warehouse artifact.

Key Information Stored

The table contains 28 columns. The most significant include:

RESOURCE_LIST_ID — surrogate primary key; the single-column identifier used by every referencing table.
NAME and DESCRIPTION — the user-facing identity of the resource list; NAME forms part of the business-key candidate constrained by unique index PA_RESOURCE_LISTS_U2 (NAME, BUSINESS_GROUP_ID, ZD_EDITION_NAME).
BUSINESS_GROUP_ID — operating unit / business group context, also part of unique index PA_RESOURCE_LISTS_U2.
PUBLIC_FLAG — indicates whether the list is shared across projects or private to its owning context.
GROUP_RESOURCE_TYPE_ID — foreign key to PA_RESOURCE_TYPES, qualifying the type of resources the list groups.
JOB_GROUP_ID — foreign key to PER_JOB_GROUPS, tying the list to a specific job group for HR resource rollup.
START_DATE_ACTIVE and END_DATE_ACTIVE — effective-date window controlling when the list is usable.
UNCATEGORIZED_FLAG — flags handling of uncategorized expenditure.
RESOURCE_LIST_TYPE and CONTROL_FLAG — classification and control behavior of the list.
USE_FOR_WP_FLAG — used to control workplan resource-list behavior.
RESOURCE_CLASS_FLAG, ITEM_MASTER_ID, ITEM_CATEGORY_SET_ID — resource classification and item-based resource selection.
DEFAULT_EXPENDITURE_TYPE and DEFAULT_COST_TYPE_ID — default categorization applied to resources in the list.
ZD_EDITION_NAME — editioning / multi-tenant discriminator; appears in both unique indexes and in the primary key structure (PA_RESOURCE_LISTS_U1 on RESOURCE_LIST_ID, ZD_EDITION_NAME).
Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and migration tracking columns (MIGRATION_CODE, RECORD_VERSION_NUMBER, MIGRATED_RBS_VERSION_ID).

Distinguish the surrogate key RESOURCE_LIST_ID from the two documented business-key candidates: PA_RESOURCE_LISTS_U1 (RESOURCE_LIST_ID, ZD_EDITION_NAME) and PA_RESOURCE_LISTS_U2 (NAME, BUSINESS_GROUP_ID, ZD_EDITION_NAME), the latter providing the meaningful uniqueness constraint on the resource list name within its business group.

Common Use Cases and Queries

Typical uses include reporting the resource lists defined for a project type, tracing which budget versions or allocation rules consume a given list, and resolving the list attached to a project's cost or revenue budget. A frequently executed pattern joins the base table to its translated names:

Select RESOURCE_LIST_ID, NAME, RESOURCE_LIST_TYPE, PUBLIC_FLAG from PA_RESOURCE_LISTS_ALL_BG where BUSINESS_GROUP_ID = :p_bg and END_DATE_ACTIVE is null or END_DATE_ACTIVE > sysdate.
Join to PA_RESOURCE_LISTS_TL on RESOURCE_LIST_ID to retrieve language-specific NAME and DESCRIPTION for reporting.
Join to PA_PROJECT_TYPES_ALL on DEFAULT_RESOURCE_LIST_ID, COST_BUDGET_RESOURCE_LIST_ID, or REV_BUDGET_RESOURCE_LIST_ID to determine which lists a project type assigns for budgeting.
Join to PA_BUDGET_VERSIONS or GMS_BUDGET_VERSIONS on RESOURCE_LIST_ID to trace budget version configuration, and to PA_ALLOC_RULES_ALL on ALLOC_RESOURCE_LIST_ID / BASIS_RESOURCE_LIST_ID to analyze allocation setups.
Join to PA_RESOURCE_LIST_MEMBERS on RESOURCE_LIST_ID to enumerate the individual resources contained in a list.

These queries support implementation audits, budget configuration documentation, and validation of resource list assignments when troubleshooting budget generation or summary amount discrepancies.

Related Objects

The most significant related objects, per the documented FK relationships, are:

PA_RESOURCE_LIST_MEMBERS — child table on RESOURCE_LIST_ID holding the individual resource entries of each list.
PA_RESOURCE_LISTS_TL — translated name and description table, joined on RESOURCE_LIST_ID.
PA_RESOURCE_LIST_ASSIGNMENTS — assignment of lists to projects or contexts, on RESOURCE_LIST_ID.
PA_BUDGET_VERSIONS and GMS_BUDGET_VERSIONS — budget version configuration referencing RESOURCE_LIST_ID.
PA_ALLOC_RULES_ALL — allocation rules referencing the list through ALLOC_RESOURCE_LIST_ID and BASIS_RESOURCE_LIST_ID.
PA_PROJECT_TYPES_ALL — default, cost budget, and revenue budget resource list assignments.
PA_PROJ_FP_OPTIONS — forecasting options referencing ALL_RESOURCE_LIST_ID, COST_RESOURCE_LIST_ID, and REVENUE_RESOURCE_LIST_ID.
PA_RESOURCE_ACCUM_DETAILS and PA_PROJECT_ACCUM_HEADERS — summary/accumulation structures tied to resource lists.
PA_RESOURCE_TYPES and PER_JOB_GROUPS — parent reference tables via GROUP_RESOURCE_TYPE_ID and JOB_GROUP_ID.
PA_PLAN_RL_FORMATS and PA_RESOURCE_MAPS — planning formats and resource map definitions referencing the list.

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 ,
View: PA_RESOURCE_LIST_ASSIGNMENTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LIST_ASSIGNMENTS_V, object_name:PA_RESOURCE_LIST_ASSIGNMENTS_V, status:VALID, product: PA - Projects , description: Resource list assignments to self service budget and workplan. , implementation_dba_data: APPS.PA_RESOURCE_LIST_ASSIGNMENTS_V ,
View: PA_RESOURCE_LIST_ASSIGNMENTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LIST_ASSIGNMENTS_V, object_name:PA_RESOURCE_LIST_ASSIGNMENTS_V, status:VALID, product: PA - Projects , description: Resource list assignments to self service budget and workplan. , implementation_dba_data: APPS.PA_RESOURCE_LIST_ASSIGNMENTS_V ,
View: PA_RESOURCE_LISTS_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LISTS_VL, object_name:PA_RESOURCE_LISTS_VL, status:VALID, product: PA - Projects , description: View that displays all resource lists Comprehensive Description : View that displays all resource lists irrespective of the business group in implementation options. , implementation_dba_data: APPS.PA_RESOURCE_LISTS_VL ,
View: PA_RESOURCE_LISTS_R 12.1.1
product: PA - Projects , description: Brief Description : View that displays resource lists for the business group in implementation options Comprehensive Description : View that displays resource lists for the business group in implementation options. , implementation_dba_data: Not implemented in this database ,
View: PA_RESOURCE_LISTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LISTS, object_name:PA_RESOURCE_LISTS, status:VALID, product: PA - Projects , description: Brief Description : View that displays resource lists for the business group in implementation options Comprehensive Description : View that displays resource lists for the business group in implementation options. , implementation_dba_data: APPS.PA_RESOURCE_LISTS ,
View: PA_RESOURCE_LISTS_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LISTS_VL, object_name:PA_RESOURCE_LISTS_VL, status:VALID, product: PA - Projects , description: View that displays all resource lists Comprehensive Description : View that displays all resource lists irrespective of the business group in implementation options. , implementation_dba_data: APPS.PA_RESOURCE_LISTS_VL ,
View: PA_RESOURCE_LISTS_R 12.2.2
product: PA - Projects , description: Brief Description : View that displays resource lists for the business group in implementation options Comprehensive Description : View that displays resource lists for the business group in implementation options. , implementation_dba_data: Not implemented in this database ,
View: PA_RESOURCE_LISTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_RESOURCE_LISTS, object_name:PA_RESOURCE_LISTS, status:VALID, product: PA - Projects , description: Brief Description : View that displays resource lists for the business group in implementation options Comprehensive Description : View that displays resource lists for the business group in implementation options. , implementation_dba_data: APPS.PA_RESOURCE_LISTS ,