Search Results resource_effective_start_date




Overview
Explore in AI Chat

Overview

PA_REP_ALL_MGR_V is an Oracle Projects (PA) view owned by the APPS schema and registered as VALID in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to list all direct and indirect managers in Oracle HR for a given application user who has Resource Authority. In other words, the view resolves the management hierarchy that a specific EBS user is permitted to see based on the Resource Authority granted through Oracle Projects security, and it flattens that hierarchy into a manager-to-manager relationship set.

The view functions as a security-filtered reporting and integration object. Rather than exposing the full HR management chain, it restricts results to those managers reachable by the current FND_GLOBAL.USER_ID through granted Resource Authority. Because it is a view rather than a table, it carries no storage of its own and always reflects the current state of the underlying denormalized resource and grant data at query time.

Underlying Base Objects

The documented ETRM metadata for 12.2.2 lists the following referenced base objects: FND_GLOBAL (package), FND_GRANTS (synonym), FND_OBJECTS (synonym), FND_PROFILE (package), FND_USER (synonym), PA_REP_RES_MGR_V (view), PA_RESOURCES_DENORM (synonym), PA_RESOURCE_UTILS (package), PA_SECURITY_PVT (package), and DUAL (synonym).

  • PA_RESOURCES_DENORM — the denormalized resource table supplying person, manager, and manager name attributes, with effective dating validated against SYSDATE.
  • PA_REP_RES_MGR_V — a reporting view of resource manager relationships used as one of the driving row sources.
  • FND_GRANTS, FND_OBJECTS, FND_USER — together they resolve the Resource Authority grant for the current user, matching grants of type INSTANCE on the ORGANIZATION object against the user's party key.
  • PA_SECURITY_PVT, PA_RESOURCE_UTILS — security packages used to obtain the Resource Authority menu identifier and related security logic.
  • FND_PROFILE — supplies the PA_SUPER_RESOURCE profile value, which governs whether the super-resource bypass applies.
  • FND_GLOBAL — provides the session context, notably FND_GLOBAL.USER_ID used to scope the grant lookup.

Key Columns

The documented view text exposes a small, focused column set:

  • MANAGER_ID — the identifier of the manager in the hierarchy reachable by the user. This column appears twice in the projection: once representing the manager from the reporting resource view and once from the denormalized resource side.
  • MANAGER_NAME — the display name of the manager.
  • Relationship indicator — a DECODE expression compares the two manager identifiers and returns 'DIRECT_REPORTS' when they match, or 'ALL_RESOURCES' otherwise. This distinguishes direct reporting lines from indirect or broader resource scope.

The effective-dating predicates (SYSDATE BETWEEN RESOURCE_EFFECTIVE_START_DATE AND RESOURCE_EFFECTIVE_END_DATE) ensure only currently active resource and manager records are returned.

Common Use Cases and Queries

Typical uses include validating which managers a user can act upon, populating manager selection lists in Projects security screens, and auditing Resource Authority grants. A representative query limits output to the current user session:

  • SELECT manager_id, manager_name FROM apps.pa_rep_all_mgr_v; — returns the manager set visible under the current session's Resource Authority.
  • Filtering on the relationship indicator to isolate direct reports versus the full resource scope.
  • Joining to PA_RESOURCES_DENORM or HR person tables to enrich results with additional manager attributes.

Because visibility depends on FND_GLOBAL.USER_ID, the same query can return different result sets for different sessions, which is expected behavior for a security-driven view.

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

  • 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_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_RES_MGR_V 12.1.1

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

  • View: PA_REP_RES_MGR_V 12.2.2

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

  • View: PA_RESOURCE_AVAILABILITY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RESOURCE_AVAILABILITY_V,  object_name:PA_RESOURCE_AVAILABILITY_V,  status:VALID,  product: PA - Projects ,  description: PA_RESOURCE_AVAILABILITY_V is a view that shows all resources with their resource manager AND availability. ,  implementation_dba_data: APPS.PA_RESOURCE_AVAILABILITY_V , 

  • View: PA_RESOURCE_AVAIL_STAFF_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RESOURCE_AVAIL_STAFF_V,  object_name:PA_RESOURCE_AVAIL_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RESOURCE_AVAIL_STAFF_V is a view that shows all resources with their resource manager AND availability. ,  implementation_dba_data: APPS.PA_RESOURCE_AVAIL_STAFF_V , 

  • View: PA_RESOURCE_AVAILABILITY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RESOURCE_AVAILABILITY_V,  object_name:PA_RESOURCE_AVAILABILITY_V,  status:VALID,  product: PA - Projects ,  description: PA_RESOURCE_AVAILABILITY_V is a view that shows all resources with their resource manager AND availability. ,  implementation_dba_data: APPS.PA_RESOURCE_AVAILABILITY_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_RESOURCE_AVAIL_STAFF_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RESOURCE_AVAIL_STAFF_V,  object_name:PA_RESOURCE_AVAIL_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RESOURCE_AVAIL_STAFF_V is a view that shows all resources with their resource manager AND availability. ,  implementation_dba_data: APPS.PA_RESOURCE_AVAIL_STAFF_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_RESOURCES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RESOURCES_V,  object_name:PA_REP_RESOURCES_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists resources ,  implementation_dba_data: APPS.PA_REP_RESOURCES_V , 

  • View: PA_CANDIDATE_LOG_AMG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CANDIDATE_LOG_AMG_V,  object_name:PA_CANDIDATE_LOG_AMG_V,  status:VALID,  product: PA - Projects ,  description: This view shows all candidate reviews. ,  implementation_dba_data: APPS.PA_CANDIDATE_LOG_AMG_V , 

  • View: PA_CANDIDATE_LOG_AMG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CANDIDATE_LOG_AMG_V,  object_name:PA_CANDIDATE_LOG_AMG_V,  status:VALID,  product: PA - Projects ,  description: This view shows all candidate reviews. ,  implementation_dba_data: APPS.PA_CANDIDATE_LOG_AMG_V , 

  • View: PA_REP_RESOURCES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RESOURCES_V,  object_name:PA_REP_RESOURCES_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RESOURCES_V is a secured view that lists resources ,  implementation_dba_data: APPS.PA_REP_RESOURCES_V , 

  • View: PA_RES_OVC_HOURS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_OVC_HOURS_V,  object_name:PA_RES_OVC_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_OVC_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_OVC_HOURS_V , 

  • View: PA_RES_OVC_HOURS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_OVC_HOURS_V,  object_name:PA_RES_OVC_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_OVC_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_OVC_HOURS_V , 

  • View: PA_TIMELINE_RESOURCE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_TIMELINE_RESOURCE_V,  object_name:PA_TIMELINE_RESOURCE_V,  status:VALID,  product: PA - Projects ,  description: View will be used to select resources (LOV) for rebuilding the timeline records using a concurrent program ,  implementation_dba_data: APPS.PA_TIMELINE_RESOURCE_V , 

  • View: PA_TIMELINE_RESOURCE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_TIMELINE_RESOURCE_V,  object_name:PA_TIMELINE_RESOURCE_V,  status:VALID,  product: PA - Projects ,  description: View will be used to select resources (LOV) for rebuilding the timeline records using a concurrent program ,  implementation_dba_data: APPS.PA_TIMELINE_RESOURCE_V , 

  • View: PA_RES_AVL_HOURS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_AVL_HOURS_V,  object_name:PA_RES_AVL_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_AVL_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_AVL_HOURS_V , 

  • View: PA_REP_ORG_RES_COMP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_RES_COMP_V,  object_name:PA_REP_ORG_RES_COMP_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by organizations ,  implementation_dba_data: APPS.PA_REP_ORG_RES_COMP_V , 

  • View: PA_RES_AVL_HOURS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_AVL_HOURS_V,  object_name:PA_RES_AVL_HOURS_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_AVL_HOURS_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_AVL_HOURS_V , 

  • View: PA_REP_ORG_RES_COMP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_RES_COMP_V,  object_name:PA_REP_ORG_RES_COMP_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by organizations ,  implementation_dba_data: APPS.PA_REP_ORG_RES_COMP_V , 

  • View: PA_REP_PROJ_RES_COMP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_RES_COMP_V,  object_name:PA_REP_PROJ_RES_COMP_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by projects ,  implementation_dba_data: APPS.PA_REP_PROJ_RES_COMP_V , 

  • View: PA_RES_OVC_HOURS_STAFF_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_OVC_HOURS_STAFF_V,  object_name:PA_RES_OVC_HOURS_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_OVC_HOURS_STAFF_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_OVC_HOURS_STAFF_V , 

  • View: PA_RES_AVL_HOURS_STAFF_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_AVL_HOURS_STAFF_V,  object_name:PA_RES_AVL_HOURS_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_AVL_HOURS_STAFF_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_AVL_HOURS_STAFF_V , 

  • View: PA_REP_PROJ_RES_COMP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_PROJ_RES_COMP_V,  object_name:PA_REP_PROJ_RES_COMP_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_RES_COMP_V is a view that lists all resource competence details by projects ,  implementation_dba_data: APPS.PA_REP_PROJ_RES_COMP_V , 

  • View: PA_REP_ORG_COM_RES_LST_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_COM_RES_LST_V,  object_name:PA_REP_ORG_COM_RES_LST_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_COM_RES_LST_V is a view that shows resource listing for organization and competence ,  implementation_dba_data: APPS.PA_REP_ORG_COM_RES_LST_V , 

  • View: PA_REP_ORG_COM_RES_LST_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_COM_RES_LST_V,  object_name:PA_REP_ORG_COM_RES_LST_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_COM_RES_LST_V is a view that shows resource listing for organization and competence ,  implementation_dba_data: APPS.PA_REP_ORG_COM_RES_LST_V , 

  • View: PA_RES_AVL_HOURS_STAFF_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_AVL_HOURS_STAFF_V,  object_name:PA_RES_AVL_HOURS_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_AVL_HOURS_STAFF_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_AVL_HOURS_STAFF_V , 

  • View: PA_RES_OVC_HOURS_STAFF_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RES_OVC_HOURS_STAFF_V,  object_name:PA_RES_OVC_HOURS_STAFF_V,  status:VALID,  product: PA - Projects ,  description: PA_RES_OVC_HOURS_STAFF_V is a view that shows available resource by weeks ,  implementation_dba_data: APPS.PA_RES_OVC_HOURS_STAFF_V , 

  • View: PA_C_RES_DENORM_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_C_RES_DENORM_V,  object_name:PA_C_RES_DENORM_V,  status:VALID,  product: PA - Projects ,  description: PA_C_RES_DENORM_V is a view that identifies all resources that are available for use at this time or in the future based on resources available in Projects ,  implementation_dba_data: APPS.PA_C_RES_DENORM_V , 

  • View: PA_REP_RES_COMP_DTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_COMP_DTS_V,  object_name:PA_REP_RES_COMP_DTS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_COMP_DTS_V is a view that lists all resources and their organization, competencies details and job details ,  implementation_dba_data: APPS.PA_REP_RES_COMP_DTS_V , 

  • View: PA_REP_RES_COMP_DTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_RES_COMP_DTS_V,  object_name:PA_REP_RES_COMP_DTS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_RES_COMP_DTS_V is a view that lists all resources and their organization, competencies details and job details ,  implementation_dba_data: APPS.PA_REP_RES_COMP_DTS_V , 

  • View: PA_REP_ORG_COMP_SUM_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_COMP_SUM_V,  object_name:PA_REP_ORG_COMP_SUM_V,  status:VALID,  product: PA - Projects ,  description: A view that shows organization competence summary ,  implementation_dba_data: APPS.PA_REP_ORG_COMP_SUM_V , 

  • View: PA_REP_ORG_COMP_SUM_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_COMP_SUM_V,  object_name:PA_REP_ORG_COMP_SUM_V,  status:VALID,  product: PA - Projects ,  description: A view that shows organization competence summary ,  implementation_dba_data: APPS.PA_REP_ORG_COMP_SUM_V , 

  • View: PA_RESOURCE_AUTHORITY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RESOURCE_AUTHORITY_V,  object_name:PA_RESOURCE_AUTHORITY_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_RESOURCE_AUTHORITY_V , 

  • View: PA_RESOURCE_AUTHORITY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_RESOURCE_AUTHORITY_V,  object_name:PA_RESOURCE_AUTHORITY_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_RESOURCE_AUTHORITY_V , 

  • View: PA_REP_ASMT_DTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ASMT_DTS_V,  object_name:PA_REP_ASMT_DTS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ASMT_DTS_V is a view to show the deails of the assignments for organizations and projects ,  implementation_dba_data: APPS.PA_REP_ASMT_DTS_V , 

  • View: PA_REP_ASMT_DTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ASMT_DTS_V,  object_name:PA_REP_ASMT_DTS_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ASMT_DTS_V is a view to show the deails of the assignments for organizations and projects ,  implementation_dba_data: APPS.PA_REP_ASMT_DTS_V , 

  • View: PA_PROJECT_ASSIGNMENTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJECT_ASSIGNMENTS_V,  object_name:PA_PROJECT_ASSIGNMENTS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROJECT_ASSIGNMENTS_V , 

  • View: PA_PROJECT_ASSIGNMENTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_PROJECT_ASSIGNMENTS_V,  object_name:PA_PROJECT_ASSIGNMENTS_V,  status:VALID,  product: PA - Projects ,  implementation_dba_data: APPS.PA_PROJECT_ASSIGNMENTS_V ,