Results for “edw_orga_tree1_lvl7_lcv”

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

Overview

The EDW_ORGA_TREE1_LVL7_LCV view is a read-only database object owned by the APPS schema within Oracle E-Business Suite. It belongs to the HRI (Human Resources Intelligence) product family, the Oracle EBS module that supplies business intelligence content for the HRMS (Human Resources Management System) reporting stack. The view represents level 7 of the Organization Tree 1 hierarchy, one tier within a multi-level flattened organizational hierarchy that is used to expose parent-child relationships between organizations in a form suitable for analytic and reporting consumption.

In the Oracle EBS reporting and integration context, level-coded views of this kind function as convenience access points: rather than requiring report developers to reconstruct the recursive hierarchy at query time, they expose a single level of the tree as flat relational rows. The _LCV suffix conventionally identifies these as read-only lightweight views, and the DDL confirms this, ending in WITH READ ONLY. This makes the object suitable for direct query by external reporting tools, data warehouse extraction routines, Discoverer workbooks, and other downstream ETL processes without risk of accidental DML. The object reports a status of VALID, indicating it is present and compiled in the APPS schema at the documented release levels (12.1.1 and 12.2.2).

Underlying Base Objects

The view text documented in the ETRM metadata shows that EDW_ORGA_TREE1_LVL7_LCV is not defined directly over physical base tables. Instead, it selects from a single underlying view, EDWBV_ORGA_TREE1_LVL7_LCV, which carries the EDWBV_ prefix typical of the Oracle HRMS Intelligence business views layer. The documented view text is:

• SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ ORG_TREE1_LVL7_PK, ORG_TREE1_LVL8_FK, INSTANCE, NAME, PRIMARY_ORG_DP, BUSINESS_GROUP, ORGANIZATION_ID, LAST_UPDATE_DATE, CREATION_DATE, NULL, NULL, NULL, NULL, NULL FROM EDWBV_ORGA_TREE1_LVL7_LCV WITH READ ONLY

Two structural details are significant. First, the header comment references HRIVIEW.LDT, confirming the view is generated or maintained by the HR Intelligence view definition tooling shipped with the product. Second, the view does not pass through the underlying business view's user attribute columns; instead it projects five literal NULL values in their place. This is a deliberate publication contract: the view reserves the five USER_ATTRIBUTE columns for possible future use by the reporting layer while guaranteeing they are currently unpopulated. The ETRM metadata does not document any referenced physical base tables beneath EDWBV_ORGA_TREE1_LVL7_LCV; those definitions reside in the HR Intelligence business view layer and are not part of this object's documented footprint.

Key Columns

The view exposes nine populated columns drawn from the underlying business view, plus five reserved NULL placeholders:

• ORG_TREE1_LVL7_PK — Primary key identifying the level 7 node within Organization Tree 1.
• ORG_TREE1_LVL8_FK — Foreign key linking the level 7 node to its child node(s) at level 8, enabling downward traversal of the hierarchy.
• INSTANCE — Instance discriminator, typically used to separate data across business groups or reporting instances.
• NAME — The organization or node name as it appears within the hierarchy.
• PRIMARY_ORG_DP — Descriptive flexfield or primary organization designator for the organization record.
• BUSINESS_GROUP — The business group (operating unit) to which the organization belongs; a core partitioning key in HRMS.
• ORGANIZATION_ID — The Oracle HRMS organization identifier, the primary join key to HR_ALL_ORGANIZATION_UNITS and related tables.
• LAST_UPDATE_DATE, CREATION_DATE — Standard Oracle audit columns supporting incremental extraction and change tracking.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE5 — Reserved placeholders, returned as NULL by this view.

Common Use Cases and Queries

This view is most commonly used when a report or extract requires the seventh level of Organization Tree 1 in isolation, for example to build organizational roll-ups, headcount summaries by management layer, or to drive hierarchy-based security filters. Because it is read-only and exposes the audit columns, it is well suited to incremental ETL jobs that pull changed rows since the last extraction.

• Listing level 7 organizations within a business group:

  SELECT ORGANIZATION_ID, NAME, BUSINESS_GROUP FROM APPS.EDW_ORGA_TREE1_LVL7_LCV WHERE BUSINESS_GROUP = :p_bg ORDER BY NAME;

• Traversing downward to level 8 children using the foreign key:

  SELECT l7.NAME parent_name, l8.NAME child_name FROM APPS.EDW_ORGA_TREE1_LVL7_LCV l7, APPS.EDW_ORGA_TREE1_LVL8_LCV l8 WHERE l7.ORG_TREE1_LVL8_FK = l8.ORG_TREE1_LVL8_PK;

• Incremental extraction of recently changed hierarchy rows:

  SELECT * FROM APPS.EDW_ORGA_TREE1_LVL7_LCV WHERE LAST_UPDATE_DATE >= :last_run_date;

Because the object is a read-only view over the HR Intelligence business view layer, query performance and data currency depend on the underlying EDWBV_ view and any concurrent programs that refresh the HR Intelligence collection. When joining to the broader hierarchy, use ORGANIZATION_ID to link to standard HRMS organization tables and the ORG_TREE1_LVL7_PK / ORG_TREE1_LVL8_FK pair to link adjacent levels within Tree 1.