Search Results pa_super_resource




Overview
Explore in AI Chat

Overview

APPS.PA_REP_ALL_RES_MGR_V is a reporting view in the Oracle E-Business Suite Projects (PA) module that exposes the set of resource managers available to the currently logged-in user. It is a security-filtered view, meaning the rows returned are dynamically constrained by Oracle EBS security grants and by the value of the PA_SUPER_RESOURCE profile option. The view is closely associated with the search term "pa_super_resource" because that profile option drives a fundamental branch in its UNION-based logic. When PA_SUPER_RESOURCE is set to 'Y', the user is treated as a "super resource" and the view returns all distinct resource managers without organizational security restrictions. When it is 'N' (the default via NVL), the view restricts the returned managers to those the user is authorized to see, combining results from the PA_REP_RES_MGR_V view and a grant-based authorization path.

The name "ALL_RES_MGR" reflects its purpose: to present the complete, security-permitted list of resource managers for reporting, LOV (List of Values) population, and integration use within the Projects application.

Underlying Base Objects

The view is defined over the following documented base objects: FND_GLOBAL (package), FND_GRANTS, FND_OBJECTS, FND_PROFILE (package), FND_USER, PA_REP_RES_MGR_V (view), PA_RESOURCES_DENORM (synonym), PA_RESOURCE_UTILS (package), PA_SECURITY_PVT (package), and DUAL. The core resource data comes from PA_RESOURCES_DENORM, a denormalized resource repository containing resource managers, effective dates, and organization associations. PA_REP_RES_MGR_V supplies a baseline manager list. PA_SECURITY_PVT provides the menu identifier used for the resource authorization path through get_menu_id('PA_PRM_RES_AUTH'). FND_PROFILE supplies the PA_SUPER_RESOURCE value, while FND_GRANTS, FND_OBJECTS, and FND_USER drive user-level security grants by joining on party and organization identity.

Key Columns

  • MANAGER_ID — The unique identifier (person_id) of the resource manager.
  • MANAGER_NAME — The display name of the resource manager.

The view exposes only these two columns, which is typical for a reporting or LOV-oriented view. Because the view returns a UNION of multiple paths, duplicate manager entries are possible across branches unless DISTINCT is applied in the consuming query.

Common Use Cases and Queries

The view is typically consumed in reporting to populate manager selection lists. A basic query returns the security-filtered manager set for the current user:

SELECT manager_id, manager_name FROM apps.pa_rep_all_res_mgr_v ORDER BY manager_name;

To find a specific manager by name:

SELECT manager_id, manager_name FROM apps.pa_rep_all_res_mgr_v WHERE manager_name = :p_name;

To deduplicate results (since the UNION may repeat managers across branches):

SELECT DISTINCT manager_id, manager_name FROM apps.pa_rep_all_res_mgr_v;

Administrators verifying behavior of the PA_SUPER_RESOURCE profile can toggle its value and observe the change in returned rows, since the profile branch directly controls whether organizational security is applied. This view is therefore a useful diagnostic for validating resource-manager security configuration in both 12.1.1 and 12.2.2 environments.