Search Results starting_manager_name




Overview
Explore in AI Chat

Overview

APPS.PA_REP_MANAGERS_DIST_V is a database view owned by the APPS schema in Oracle E-Business Suite, documented as VALID in both release 12.1.1 and 12.2.2. The FND Design Data reference is PA.PA_REP_MANAGERS_DIST_V, confirming that the object is delivered as part of the Oracle Projects (PA) application family and registered within the application's design metadata repository.

The view is classified as a Web view, meaning it was designed to simplify access from Oracle Self-Service Web Applications. In this role it acts as a lightweight, read-only projection that exposes a specific, narrowly scoped set of resource manager data to web-tier consumers without requiring those consumers to navigate the more complex denormalized structures beneath it. Functionally, the view lists all resource managers, presenting the internal identifier and the full name of each manager record. This makes it a convenient building block for list-of-values (LOV) definitions, self-service selection pages, and reporting queries that need to resolve a manager to a human-readable name.

The object is commonly encountered when developers or administrators search for the STARTING_MANAGER_NAME column, which is one of the two columns the view exposes. Because the view is a Web view rather than a full business view, its scope is restricted; it does not carry organization, date-effective, or assignment-level attributes beyond what the underlying denormalized resource table provides.

Underlying Base Objects

According to the documented dependency information, APPS.PA_REP_MANAGERS_DIST_V references a single base object: APPS.PA_RESOURCES_DENORM, which is exposed through a synonym. PA_RESOURCES_DENORM is the denormalized resource table maintained by Oracle Projects, consolidating resource attributes that would otherwise require joins across the resource, person, and assignment structures. By reading directly from this denormalized table, the view avoids multi-table joins and delivers a fast, simple result set suitable for web application consumption.

The dependency listing indicates that PA_REP_MANAGERS_DIST_V is not referenced by any other database object. It therefore functions as a top-level, leaf-level access path: nothing in the database layer depends upon it, so changes to the view definition carry no cascading impact on other delivered objects. Developers who build custom objects over it should be aware that support boundaries apply, since custom dependencies on a delivered Web view are not covered by Oracle's standard dependency chain.

Key Columns

The view exposes two columns, both of which are central to its purpose:

  • STARTING_MANAGER_ID — NUMBER(15). The internal identifier of the resource manager. This value corresponds to the resource identifier held in the underlying denormalized resource table and serves as the join key when the view is combined with other resource-based queries.
  • STARTING_MANAGER_NAME — VARCHAR2(240). The full name of the resource manager, presented in display-ready form. This is the column most frequently targeted by searches and by LOV definitions, since it supplies the human-readable label that accompanies the numeric identifier.

Neither column is documented as mandatory at the view level. The pairing of a numeric identifier with a descriptive name reflects the standard EBS pattern for populating selection lists and for resolving foreign-key style references into meaningful text.

Common Use Cases and Queries

The principal use cases for this view are populating manager selection lists in Oracle Self-Service Web Applications, supporting ad hoc reporting that requires manager names alongside their identifiers, and providing a simple source for validating that a given manager identifier exists.

A basic query retrieving all manager records follows the documented query text:

  • SELECT STARTING_MANAGER_ID, STARTING_MANAGER_NAME FROM APPS.PA_REP_MANAGERS_DIST_V;

To locate a specific manager by name, a filtered query is typically used:

  • SELECT STARTING_MANAGER_ID, STARTING_MANAGER_NAME FROM APPS.PA_REP_MANAGERS_DIST_V WHERE STARTING_MANAGER_NAME LIKE :p_name;

For LOV-style ordering, the name column is generally sorted ascending:

  • SELECT STARTING_MANAGER_ID, STARTING_MANAGER_NAME FROM APPS.PA_REP_MANAGERS_DIST_V ORDER BY STARTING_MANAGER_NAME;

Because the view is a thin projection over PA_RESOURCES_DENORM and is not referenced by any other object, it is safe to query directly in custom reports. However, callers should rely on the documented columns only, since the view contract is limited to STARTING_MANAGER_ID and STARTING_MANAGER_NAME, and no date-effective or organizational filtering is applied by the view itself.

  • 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_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_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_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_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: 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: 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.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 , 

  • 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 , 

  • eTRM - PA Tables and Views 12.1.1

  • eTRM - PA Tables and Views 12.2.2