Search Results starting_manager_id




Overview
Explore in AI Chat

Overview

APPS.PA_REP_MANAGERS_V is a Business Intelligence System (BIS) view in the Oracle E-Business Suite Applications schema (APPS). It is registered in the Oracle ETRM under FND Design Data reference PA.PA_REP_MANAGERS_V and is recorded with a status of VALID in both Oracle EBS 12.1.1 and 12.2.2. Its purpose is to expose the reporting-line relationship between a starting resource manager and a target resource manager within Oracle Project Resource Management, together with a derived indicator that classifies how the two managers are related.

The view is a lightweight, read-only presentation layer. It does not store data; instead it projects a small number of columns from the denormalized resources table into a form convenient for reporting tools, BI Publisher extracts, and downstream integrations that need to resolve manager hierarchies. Because it is an APPS-owned BIS view, it is typically consumed through a synonym and is subject to the standard APPS security and grants framework.

Underlying Base Objects

The view references the base synonym APPS.PA_RESOURCES_DENORM. PA_RESOURCES_DENORM is a denormalized resource-management object that consolidates resource identity and manager-assignment attributes into a single flattened structure, which is why the view can return manager identifiers and names without additional joins. The recorded dependency list confirms that PA_RESOURCES_DENORM is the sole referenced object; no other tables, views, or packages are documented as inputs to PA_REP_MANAGERS_V.

The dependency direction is one-way. PA_REP_MANAGERS_V is not referenced by any database object in the ETRM dependency list, so it functions as a terminal reporting object rather than a building block for further database logic. This means changes to the view definition are isolated from other database dependencies, and consumers should treat it strictly as a query surface.

Key Columns

  • STARTING_MANAGER_ID (NUMBER, 15) — Internal identifier of the starting resource manager. This is the column associated with the search term "starting_manager_id" and acts as the anchor point for the manager-relationship evaluation.
  • STARTING_MANAGER_NAME (VARCHAR2, 240) — The display name of the starting resource manager, provided for direct reporting without an additional lookup on the resource directory.
  • MANAGER_ID (NUMBER, 15) — Internal identifier of the resource manager being compared against the starting manager.
  • VIEW_RESOURCES (VARCHAR2, 14) — A derived classifier. When STARTING_MANAGER_ID equals MANAGER_ID, the view returns "DIRECT_REPORTS"; otherwise it returns "ALL_RESOURCES". This column allows a single query to distinguish a manager's own direct-reporting scope from the broader population of resources visible through the resource hierarchy.

Common Use Cases and Queries

The principal use case is determining, for a given starting manager, the set of resources attributable to that manager and whether the result represents only direct reports or all resources under the manager's purview. Reporting teams use this for resource-level access analyses, delegation checks, and manager hierarchy dashboards.

A basic retrieval follows the documented query text:

  • SELECT STARTING_MANAGER_ID, STARTING_MANAGER_NAME, MANAGER_ID, VIEW_RESOURCES FROM APPS.PA_REP_MANAGERS_V;

To isolate direct-reporting scope for a specific manager:

  • SELECT STARTING_MANAGER_NAME, MANAGER_ID FROM APPS.PA_REP_MANAGERS_V WHERE STARTING_MANAGER_ID = :start_manager AND VIEW_RESOURCES = 'DIRECT_REPORTS';

To retrieve the full resource view associated with a manager:

  • SELECT MANAGER_ID FROM APPS.PA_REP_MANAGERS_V WHERE STARTING_MANAGER_ID = :start_manager AND VIEW_RESOURCES = 'ALL_RESOURCES';

Because the view exposes only four columns and depends on a single denormalized source, it performs well for high-volume extracts. It should not be used for transactional updates; all access is read-only.

  • VIEW: APPS.PA_REP_MANAGERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_V,  object_name:PA_REP_MANAGERS_V,  status:VALID, 

  • VIEW: APPS.PA_REP_MANAGERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_V,  object_name:PA_REP_MANAGERS_V,  status:VALID, 

  • VIEW: APPS.PA_REP_ALL_MGR_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_MGR_V,  object_name:PA_REP_ALL_MGR_V,  status:VALID, 

  • VIEW: APPS.PA_REP_ALL_MGR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_MGR_V,  object_name:PA_REP_ALL_MGR_V,  status:VALID, 

  • VIEW: APPS.PA_REP_MANAGERS_DIST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_DIST_V,  object_name:PA_REP_MANAGERS_DIST_V,  status:VALID, 

  • VIEW: APPS.PA_REP_MANAGERS_DIST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_DIST_V,  object_name:PA_REP_MANAGERS_DIST_V,  status:VALID, 

  • VIEW: APPS.PA_REP_ALL_RES_MGR_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_RES_MGR_V,  object_name:PA_REP_ALL_RES_MGR_V,  status:VALID, 

  • VIEW: APPS.PA_REP_ALL_RES_MGR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_RES_MGR_V,  object_name:PA_REP_ALL_RES_MGR_V,  status:VALID, 

  • View: PA_REP_MANAGERS_DIST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_DIST_V,  object_name:PA_REP_MANAGERS_DIST_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_MANAGERS_DIST_V is a view that shows all distinct resource managers ,  implementation_dba_data: APPS.PA_REP_MANAGERS_DIST_V , 

  • View: PA_REP_MANAGERS_DIST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_DIST_V,  object_name:PA_REP_MANAGERS_DIST_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_MANAGERS_DIST_V is a view that shows all distinct resource managers ,  implementation_dba_data: APPS.PA_REP_MANAGERS_DIST_V , 

  • View: PA_REP_MANAGERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_V,  object_name:PA_REP_MANAGERS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists all managers in the system ,  implementation_dba_data: APPS.PA_REP_MANAGERS_V , 

  • View: PA_REP_MANAGERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_MANAGERS_V,  object_name:PA_REP_MANAGERS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists all managers in the system ,  implementation_dba_data: APPS.PA_REP_MANAGERS_V , 

  • View: PA_REP_ALL_RES_MGR_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_RES_MGR_V,  object_name:PA_REP_ALL_RES_MGR_V,  status:VALID,  product: PA - Projects ,  description: This view shows starting resource managers based on users security ,  implementation_dba_data: APPS.PA_REP_ALL_RES_MGR_V , 

  • View: PA_REP_ALL_RES_MGR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_RES_MGR_V,  object_name:PA_REP_ALL_RES_MGR_V,  status:VALID,  product: PA - Projects ,  description: This view shows starting resource managers based on users security ,  implementation_dba_data: APPS.PA_REP_ALL_RES_MGR_V , 

  • View: PA_REP_ALL_MGR_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_MGR_V,  object_name:PA_REP_ALL_MGR_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ALL_MGR_V is a view that list all direct and indirect managers in HR for a given application user has a Resource Authority ,  implementation_dba_data: APPS.PA_REP_ALL_MGR_V , 

  • View: PA_REP_ALL_MGR_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_MGR_V,  object_name:PA_REP_ALL_MGR_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ALL_MGR_V is a view that list all direct and indirect managers in HR for a given application user has a Resource Authority ,  implementation_dba_data: APPS.PA_REP_ALL_MGR_V , 

  • eTRM - PA Tables and Views 12.1.1

  • eTRM - PA Tables and Views 12.2.2