Search Results org_tl

Overview

APPS.PER_ORG_MANAGER_V is a reporting and integration view in Oracle E-Business Suite 12.1.1 and 12.2.2 that exposes the manager or responsible person associated with an organization unit, together with the organization's name, business group, and two dated alias attributes. The view is a join-driven construct rather than a stored table, resolving organization records from HR_ALL_ORGANIZATION_UNITS and its translated name table against people records in PER_ALL_PEOPLE_F, linked through the HR_ORGANIZATION_INFORMATION flexfield context Organization Name Alias.

Because the linkage is maintained through organization information (DFF) rather than a dedicated manager column, the view provides a single, query-friendly surface for retrieving the person recorded as the organization's alias/manager, with effective-dating and HR security applied automatically. This makes it suitable for concurrent programs, BI Publisher data models, OAF pages, and inbound/outbound integrations that need to identify responsible parties per organization unit without hand-coding the alias DFF resolution logic. The user search term "org_info2" reflects this: the alias org_info2 appears in the view text as the alias for HR_ORGANIZATION_INFORMATION, the table that carries the manager person_id and the two dated attributes.

Underlying Base Objects

The view is defined over the following documented base objects:

• HR_ALL_ORGANIZATION_UNITS (synonym) — the primary organization unit record, supplying organization_id and business_group_id.
• HR_ALL_ORGANIZATION_UNITS_TL (synonym) — the translated organization name, joined on language = userenv('LANG').
• HR_ORGANIZATION_INFORMATION (synonym, aliased org_info2) — supplies the person link via org_information2 and the dated attributes org_information3 and org_information4, constrained to context 'Organization Name Alias'.
• PER_ALL_PEOPLE_F (synonym) — the effective-dated person record providing person_id and full_name; the outer join (person_id(+)) means organizations without a manager still appear.
• HR_ORG_INFO_TYPES_BY_CLASS (synonym) — used in the EXISTS subquery, confirming the organization's CLASS flexfield is set to 'Y' and that 'Organization Name Alias' is a valid information type for that classification.
• FND_SESSIONS (synonym) — joined on session_id = userenv('sessionid') to supply the effective date used to filter the person record.
• FND_DATE (package) — converts the canonical (stored) date format of the alias attributes into true DATE values via CANONICAL_TO_DATE.
• HR_GENERAL and HR_SECURITY (packages) — enforce business group isolation (get_xbg_profile, get_business_group_id) and record-level security (view_all, show_record).

Key Columns

• person_id — identifier of the manager/responsible person held in the alias DFF.
• full_name — formatted name of that person, from PER_ALL_PEOPLE_F.
• organization_id — the organization unit the manager is attached to.
• business_group_id — the business group of the organization, used with HR security.
• name — the translated organization name.
• fnd_date.canonical_to_date(org_info2.org_information3) — a DATE derived from the first alias date attribute (typically a start/effective date).
• fnd_date.canonical_to_date(org_info2.org_information4) — a DATE derived from the second alias date attribute (typically an end date).
• org_information_id — the surrogate key of the underlying organization information row, useful for joins or auditing.
• object_version_number — the optimistic locking version of the source DFF row.

Common Use Cases and Queries

Typical scenarios include listing managers per organization for HR reporting, driving approval or notification workflows to the correct responsible person, and validating organization-to-manager mappings during data conversion. Because HR security and business group predicates are built in, ad hoc queries return only rows the session is authorized to see.

Sample query returning managers for all visible organizations:

SELECT organization_id,
       name,
       person_id,
       full_name
  FROM apps.per_org_manager_v
 ORDER BY name;

Sample query using the search term org_info2 context to find managers with a dated alias window:

SELECT organization_id,
       name,
       full_name,
       fnd_date.canonical_to_date(org_information3) AS alias_start,
       fnd_date.canonical_to_date(org_information4) AS alias_end
  FROM apps.per_org_manager_v
 WHERE person_id IS NOT NULL;

For performance, filter by organization_id or business_group_id where possible; note that the view depends on session context (userenv('sessionid'), userenv('LANG')) and on HR security profile setup, so results are affected by the user's business group and security profile configuration.