Search Results pa_resource_lists_u2

Overview

PA.PA_RESOURCE_LISTS_ALL_BG is a foundational container table in the Oracle Projects (PA) schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the master definitions of resource lists, which provide an effective mechanism for grouping a set of similar resources that are typically used for specific kinds of project work. Oracle Projects supports resource lists with up to a two-level hierarchy of resource groups and resources. Because resources are owned by a business group, they can be shared across operating units that share the same business group; this table consequently holds all resource lists defined within the system, while the PA_RESOURCE_LISTS view exposes only those owned by the business group specified in the implementation options under which the user is logged on.

The table is physically stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its indexes reside in APPS_TS_TX_IDX. It serves as a central hub referenced throughout budgeting, planning, allocation, and resource-formatting functionality. From a Data Vault modeling perspective, the metadata's heuristic classification identifies this object as a hub: RESOURCE_LIST_ID acts as the durable business key around which surrounding references cluster.

Key Information Stored

• RESOURCE_LIST_ID — System-generated number uniquely identifying the resource list. This is the surrogate primary key (PA_RESOURCE_LISTS_PK) and the leading column of unique index PA_RESOURCE_LISTS_U1 (RESOURCE_LIST_ID, ZD_EDITION_NAME). The user's search term, pa_resource_lists_u1, resolves to this unique index.
• NAME and BUSINESS_GROUP_ID — The user-defined name plus owning business group form the documented business-key candidate, enforced by unique index PA_RESOURCE_LISTS_U2 (NAME, BUSINESS_GROUP_ID, ZD_EDITION_NAME).
• DESCRIPTION — User-defined description of the resource list.
• PUBLIC_FLAG — Indicates whether the list may be used by all projects; currently set to 'Y' for all lists, with project-specific lists intended as 'N'.
• GROUP_RESOURCE_TYPE_ID — Identifies how the list is grouped (by Expenditure Category, Revenue Category, or ungrouped), storing the Resource Type identifier when grouped.
• START_DATE_ACTIVE and END_DATE_ACTIVE — Effective-dating columns governing when the list is active.
• UNCATEGORIZED_FLAG — Marks lists containing uncategorized resources.
• JOB_GROUP_ID — Associates the list with a job group.
• RESOURCE_LIST_TYPE, CONTROL_FLAG, USE_FOR_WP_FLAG, RESOURCE_CLASS_FLAG — Control classification and usage behavior flags.
• ZD_EDITION_NAME — Enterprise-command/editioning column participating in both unique indexes; also present are standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and migration columns.

Common Use Cases and Queries

Typical scenarios include identifying the default resource lists assigned to a project type, validating the list behind a budget or forecast version, and reporting which lists drive allocation rules.

• Retrieve active lists for the current business group:
  SELECT resource_list_id, name, description FROM pa.pa_resource_lists_all_bg WHERE business_group_id = :p_bg AND (end_date_active IS NULL OR end_date_active > SYSDATE);
• Trace the default list configured on a project type:
  SELECT pt.project_type, prl.name FROM pa.pa_project_types_all pt JOIN pa.pa_resource_lists_all_bg prl ON prl.resource_list_id = pt.default_resource_list_id;
• Find resource lists consumed by planning formats or budget versions via PA_PLAN_RL_FORMATS.RESOURCE_LIST_ID and PA_BUDGET_VERSIONS.RESOURCE_LIST_ID for downstream reporting.

Related Objects

• PA_RESOURCE_LISTS_TL — Translation table joined on RESOURCE_LIST_ID, supplying language-specific names and descriptions.
• PA_RESOURCE_LIST_MEMBERS — Holds the two-level hierarchy of groups and resources belonging to a list; join on RESOURCE_LIST_ID.
• PA_RESOURCE_LIST_ASSIGNMENTS — Maps lists to owning entities via RESOURCE_LIST_ID.
• PA_PROJECT_TYPES_ALL — References this table through DEFAULT_RESOURCE_LIST_ID, COST_BUDGET_RESOURCE_LIST_ID, and REV_BUDGET_RESOURCE_LIST_ID.
• PA_BUDGET_VERSIONS and GMS_BUDGET_VERSIONS — Reference RESOURCE_LIST_ID to bind budgets and grants budgets to a list.
• PA_ALLOC_RULES_ALL — References both ALLOC_RESOURCE_LIST_ID and BASIS_RESOURCE_LIST_ID.
• PA_PROJ_FP_OPTIONS and PA_PLAN_RL_FORMATS — Drive forecast/plan configuration and plan formatting through RESOURCE_LIST_ID.
• Foreign keys from this table point to PA_RESOURCE_TYPES (GROUP_RESOURCE_TYPE_ID) and PER_JOB_GROUPS (JOB_GROUP_ID), anchoring resource grouping and job classification.