Search Results pa_resource_lists




Overview
Explore in AI Chat

Overview

PA_RESOURCE_LISTS is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite, belonging to the Projects (PA) product family. It exposes resource lists defined for a business group, most notably those referenced in implementation options. A resource list is a reusable grouping of people, roles, or other resource definitions used by Oracle Projects for planning, budgeting, forecasting, and workplan assignment. The view presents a denormalized, language-aware, and business-group-filtered representation of these lists, making it suitable for reporting, concurrent programs, and integration extracts without requiring callers to handle the underlying multi-lingual and cross-business-group logic themselves.

The view has a status of VALID in ETRM releases 12.1.1 and 12.2.2, and is authorized for reporting consumption. Because it encapsulates profile-based filtering and translation joins, it is generally preferred over querying the base tables directly when the objective is to retrieve resource list names and descriptions for the current user's operating context.

Underlying Base Objects

The view text joins a synonym over the base table PA_RESOURCE_LISTS_ALL_BG (aliased R) to a synonym over the translation table PA_RESOURCE_LISTS_TL (aliased RTL) on RESOURCE_LIST_ID, constraining the translation to RTL.LANGUAGE = USERENV('LANG'). The base table stores all business-group-specific rows, while the TL table supplies the language-specific NAME and DESCRIPTION attributes.

Two packages participate in the filter logic. FND_PROFILE supplies the current value of PER_BUSINESS_GROUP_ID, and PA_CROSS_BUSINESS_GRP exposes the ISCROSSBGPROFILE result. The predicate returns rows where either the row's BUSINESS_GROUP_ID matches the profile business group and cross-business-group access is disabled, or cross-business-group access is enabled. This design enables multi-org-aware security without requiring each consumer to reimplement the rule.

Key Columns

Common Use Cases and Queries

Typical scenarios include validating which resource lists are visible to a business group, building LOV-style extracts, and auditing public versus private lists. A standard query retrieving active lists for the current context is:

SELECT resource_list_id, name, description, public_flag, start_date_active, end_date_active FROM pa_resource_lists WHERE NVL(public_flag,'N') = 'Y' AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE + 1) ORDER BY name;

To locate lists associated with a specific resource type or job group, filter on group_resource_type_id or job_group_id. For upgrades and migration reconciliation, join on migrated_rbs_version_id. Because the view already resolves business-group security and translation, reports built over it behave consistently across 12.1.1 and 12.2.2 and remain insulated from the underlying _ALL_BG and _TL table structure.