Search Results per_org_manager_v




Overview
Explore in AI Chat

View: PER_ORG_MANAGER_V in Oracle EBS 12.1.1 / 12.2.2

Overview

PER_ORG_MANAGER_V is a seeded Oracle E-Business Suite database view owned by the APPS schema within the PER — Human Resources product family. It presents organization-level manager assignments, resolving each organization to the person currently associated with it through the "Organization Name Alias" information type, while simultaneously exposing the identifier of the underlying HR_ORGANIZATION_INFORMATION row. The view is defined as a join across organization definition tables, organization information (descriptive flexfield) tables, and the person table, filtered by a class-based existence check and constrained by Oracle HRMS row-level security.

The view is principally used in HRMS reporting, extensions, and integration interfaces where a flattened list of organizations, their managers, and the effective dating of that manager relationship is required. Because it encapsulates HR security logic and session-based effective dating, it is generally preferable to querying the base tables directly.

Underlying Base Objects

The documented base objects referenced by PER_ORG_MANAGER_V are:

Key Columns

  • PERSON_ID — the person identifier of the manager associated with the organization alias.
  • FULL_NAME — the formatted full name of that person.
  • ORGANIZATION_ID — the organization to which the manager record belongs.
  • BUSINESS_GROUP_ID — the business group that owns the organization, relevant for multi-business-group (XBG) environments.
  • COST_CENTER — derived from FND_DATE.CANONICAL_TO_DATE(ORG_INFO2.ORG_INFORMATION3), representing the start date of the manager assignment.
  • START_DATE — derived from FND_DATE.CANONICAL_TO_DATE(ORG_INFO2.ORG_INFORMATION4), representing the end date.
  • END_DATE — the organization name from ORG_TL.NAME.
  • ORG_INFO — exposed as ORG_INFO2.ORG_INFORMATION_ID, the primary identifier of the underlying organization information row. This is the column most frequently searched as org_information_id, since it links the view back to the specific descriptive flexfield record.
  • OBJECT_VERSION_NUMBER — carried from ORG_INFO2 from the source query, supporting concurrency control.

Common Use Cases and Queries

Typical applications include manager listings per organization, HRMS extracts, and reconciliation of organization alias setup. A straightforward query retrieving managers for a given organization:

  • SELECT organization_id, business_group_id, person_id, full_name, org_info FROM apps.per_org_manager_v WHERE organization_id = :p_org_id;

To locate the descriptive flexfield row behind a specific alias, filtering on the exposed identifier:

  • SELECT organization_id, person_id, full_name FROM apps.per_org_manager_v WHERE org_info = :p_org_information_id;

For integration extracts spanning business groups, filtering by business_group_id is standard. Because the view embeds HR_SECURITY and FND_SESSIONS, results are automatically restricted to the querying session's effective date and security profile, making it safe for use in concurrent programs and self-service pages without additional security predicates. Note that the date-derived columns (COST_CENTER, START_DATE, END_DATE) reflect the underlying flexfield segment storage rather than true column semantics, and should be interpreted against the descriptive flexfield definition for the "ORGANIZATION NAME ALIAS" context.