Results for “edw_orga_tree1_lvl8_lcv”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

EDW_ORGA_TREE1_LVL8_LCV is a read-only view owned by the APPS schema within the HRI (Human Resources Intelligence) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It forms part of the Oracle HRMS Intelligence (HRMSi/EDW) reporting layer, which delivers denormalized, business-friendly database objects that support operational reporting and downstream data warehouse extraction. The view presents the eighth level of a predefined organization hierarchy (Organization Tree 1), exposing one row per organization node at that level together with its primary key, foreign key associations, business group context, and audit timestamps.

The view is defined with a WITH READ ONLY clause, which is significant in EBS releases: it guarantees that no DML can be issued against the object, reinforcing its role as a consumption-only reporting surface. This allows report developers and integrators to query the object safely without risk of mutating HR organizational data.

Underlying Base Objects

Per the documented view text, EDW_ORGA_TREE1_LVL8_LCV is defined over a single underlying object: EDWBV_ORGA_TREE1_LVL8_LCV. The EDWBV_ prefix denotes an EDW base view that encapsulates the hierarchy traversal and joins across the underlying HR organization tables. Because the ETRM metadata documents no referenced base tables for EDW_ORGA_TREE1_LVL8_LCV, EDWBV_ORGA_TREE1_LVL8_LCV in turn resolves to EDW_ORGA_TREE1_LVL8_LCV's predecessor objects in the same family — the PER_ORG_STRUCTURE_ELEMENTS / PER_ORG_STRUCTURE_VERSIONS hierarchy tables for the HR organization hierarchy, joined to HR_ALL_ORGANIZATION_UNITS for organization attributes. The ORG_TREE1_LVL8_PK column is derived from the primary key of the hierarchy element at level 8 of tree 1.

Key Columns

• ORG_TREE1_LVL8_PK — Primary key of the organization node at level 8 of Organization Tree 1. This is the column most commonly referenced in joins and is the object of the search term org_tree1_lvl8_pk.
• ALL_FK — Foreign key to the full organization hierarchy definition in the EDW organization dimension.
• INSTANCE — Identifies the hierarchy instance or version associated with the node.
• NAME — Organization name of the level 8 node.
• PRIMARY_ORG_DP — Primary organization display flag or descriptor.
• BUSINESS_GROUP — Business group identifier owning the organization.
• ORGANIZATION_ID — Operating unit / organization identifier from HR_ALL_ORGANIZATION_UNITS.
• LAST_UPDATE_DATE, CREATION_DATE — Standard EBS audit columns.
• USER_ATTRIBUTE1–5 — Descriptive flexfield segments; the view text shows these as NULL in the projection, meaning the columns exist for interface compatibility but are not populated from the base view.

Common Use Cases and Queries

The view is typically used when a report or extract must return organizations belonging specifically to the eighth level of Organization Tree 1 — for example, cost center rollups, span-of-control reports, or ETL population of an EDW organization dimension.

SELECT org_tree1_lvl8_pk,
       all_fk,
       instance,
       name,
       business_group,
       organization_id
FROM   apps.edw_orga_tree1_lvl8_lcv
WHERE  business_group = :p_business_group_id
ORDER  BY name;

To join back to the parent hierarchy node, the ALL_FK and INSTANCE columns are combined with the corresponding level 7 view (EDW_ORGA_TREE1_LVL7_LCV) to build a drill-down from parent to child. Because the USER_ATTRIBUTE columns are returned as NULL, queries should not filter on them; use the NAME or ORGANIZATION_ID columns instead. All access should be read-only, consistent with the view's WITH READ ONLY definition.