Search Results loss_type

Overview

APPS.HRIBV_ASGMVORGHRCHY is a Business Intelligence (BIS) reporting view within Oracle E-Business Suite Human Resources. It exposes assignment movement events that occur within an organization hierarchy — that is, transfers, moves, or status changes of an assignment between organizations that are members of the same organization structure. The view is part of the HRI (Human Resources Intelligence) family of views used by Oracle HRMS Analytics and Oracle Business Intelligence Applications (OBIA) to feed HR data warehouses and workforce movement dashboards.

In the searched context of the column org_structure_version_id, this view is relevant because it joins the summary table HRI_ORG_HRCHY_SUMMARY to PER_ORG_STRUCTURE_VERSIONS on this key. The identifier represents the specific version of an organization hierarchy (for example, the versioned snapshot of a management or reporting structure) at the time of the movement, allowing point-in-time analysis of organizational changes. This makes the view suitable for historical reporting where the hierarchy state at a given date must be preserved.

Underlying Base Objects

The view is defined over the following documented objects: HRI_ORG_HRCHY_SUMMARY (synonym), HR_ALL_ORGANIZATION_UNITS_TL (synonym), HR_BIS (package), HR_GENERAL (package), HR_SECURITY (package), PER_ALL_PEOPLE_F (synonym), PER_ASSIGNMENTS_F (view), PER_ORGANIZATION_STRUCTURES (synonym), and PER_ORG_STRUCTURE_VERSIONS (synonym).

The primary driver is HRI_ORG_HRCHY_SUMMARY (aliased oss1), which supplies org_structure_version_id, parent_org_id, and sub_organization_id. The join to PER_ORG_STRUCTURE_VERSIONS (osv1) on oss1.org_structure_version_id = osv1.org_structure_version_id provides version numbers and effective date ranges. The self-join of PER_ASSIGNMENTS_F (asg1 = current assignment, asg2 = prior/other assignment) on assignment_id captures before-and-after states. Organization names for the hierarchy, top organization, from-organization, and to-organization are resolved via three instances of HR_ALL_ORGANIZATION_UNITS_TL. Lookups for move type, gain type, and loss type are decoded through the HR_BIS package, while HR_GENERAL supplies the end-of-time default via hr_general.end_of_time.

Key Columns

• org_structure_version_id — Versioned hierarchy identifier from HRI_ORG_HRCHY_SUMMARY; the join key to hierarchy version data.
• organization_structure_id — Parent organization structure definition.
• org_hierarchy_version and organization_hrchy_name — Version number and name of the hierarchy.
• organisation_name, other_organization_name, Top_Organization_name — Organization names from the TL table joins.
• from_organization_name / to_organization_name — Movement direction captured from the assignment self-join.
• assignment_number, Employee_name, person_id, business_group_id — Assignment and person identifiers.
• change_date, hierarchy_version_date_from, hierarchy_version_date_to_nn — Effective dating columns; NVL(osv1.date_to, hr_general.end_of_time) ensures an open-ended version resolves to end-of-time.
• move_type_code, gain_type_code, loss_type_code — Constant-coded literals (ORGHRCHY_WITHIN, NA_EDW) indicating the movement classification.

Common Use Cases and Queries

The view is used to report assignment movements within a hierarchy, particularly for point-in-time org-structure analysis. A typical query retrieving movements tied to a hierarchy version is:

SELECT org_structure_version_id,
       organization_hrchy_name,
       org_hierarchy_version,
       from_organization_name,
       to_organization_name,
       Employee_name,
       change_date
FROM   apps.hribv_asgmvorg hrchy
WHERE  org_structure_version_id = :p_version_id
ORDER BY change_date;

Because from_organization_name and to_organization_name are both exposed, the view supports movement-flow reporting between organizations inside the same structure. The effective-dated hierarchy version columns also make it suitable for as-of-date reporting against historical hierarchy states, which is essential in HRMS Analytics and OBIA workforce movement subject areas.