Results for “edw_orga_leg_entity_lcv”

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

Overview

EDW_ORGA_LEG_ENTITY_LCV is a collection view belonging to the HRI (Human Resources Intelligence) product family, which is flagged as obsolete in Oracle EBS 12.1.1 and 12.2.2. The view represents the HR Legal Entities level of the Organization dimension within the HRI dimensional model. Its purpose is to expose a denormalized, reporting-ready set of attributes describing legal entities, including the set of books to which each legal entity is associated, so that downstream extract, transform, and load (ETL) processes and analytical reporting layers can consume organizational hierarchy data in a consistent format.

Because the view is part of an obsolete module and is documented as "Not implemented in this database," it exists primarily as a metadata artifact. Implementations that still reference it in legacy HRI reporting or data warehouse staging will encounter the definition but should recognize that the underlying object may not be present in a current environment. The user's search term "set_of_books" maps directly to the SET_OF_BOOKS column, which links each legal entity to its accounting configuration — a key join point between HR organization data and financial reporting dimensions.

Underlying Base Objects

According to the documented metadata, EDW_ORGA_LEG_ENTITY_LCV is defined over a single referenced base object: EDWBV_ORGA_LEG_ENTITY_LCV. The "BV" naming convention indicates a base view within the HRI warehouse schema. The collection view is therefore a thin projection over that base view, extending it with placeholder NULL columns to conform to a fixed column signature expected by the Organization dimension collection.

The underlying view supplies the substantive attributes such as the legal entity primary key, business group foreign key, name, descriptive flexfield context, set of books, effective dating, and organization classification fields. No other base tables are documented as directly referenced. The dependency chain is therefore: EDW_ORGA_LEG_ENTITY_LCV → EDWBV_ORGA_LEG_ENTITY_LCV → (implied HR and financial source objects). Because the definition is documented as not implemented, DBAs should verify object existence in ALL_VIEWS before attempting to query it.

Key Columns

• LEGAL_ENTITY_PK — Surrogate primary key uniquely identifying the legal entity record within the collection.
• BUSINESS_GROUP_FK — Foreign key to the business group context, scoping the legal entity to a specific HR organization structure.
• NAME — The display name of the legal entity.
• LEGAL_ENTITY_DP — Descriptive flexfield context value for the legal entity.
• SET_OF_BOOKS — The set of books associated with the legal entity, enabling reconciliation between HR organizational data and financial accounting configurations.
• DATE_FROM / DATE_TO — Effective start and end dates defining the validity window of the legal entity record.
• INT_EXT_FLAG — Indicator distinguishing internal from external organizational entities.
• ORG_CODE / ORG_TYPE — Classification code and type of the organization.
• PRIMARY_CST_MTHD — Primary costing method associated with the entity.
• INSTANCE — Identifies the source instance or system from which the data was extracted.
• LEGAL_ENTITY_ID — The natural (source system) identifier for the legal entity.
• LEVEL_NAME — The Organization dimension level label, here corresponding to the legal entity level.
• LAST_UPDATE_DATE / CREATION_DATE — Standard audit timestamps for incremental extraction.
• USER_ATTRIBUTE1 through USER_ATTRIBUTE5 — Generic placeholder columns, populated as NULL in the collection view text, reserved for extension or mapping consistency.

Common Use Cases and Queries

Typical use cases include loading the Organization dimension in an HRI data warehouse, reconciling HR legal entities against their assigned sets of books, and filtering organizational hierarchies by effective date. A representative query retrieving current legal entities with their accounting context:

SELECT LEGAL_ENTITY_PK, NAME, SET_OF_BOOKS, ORG_CODE, ORG_TYPE, DATE_FROM, DATE_TO FROM EDW_ORGA_LEG_ENTITY_LCV WHERE SYSDATE BETWEEN DATE_FROM AND NVL(DATE_TO, SYSDATE);

To scope by set of books — the term the user searched for — a query such as the following supports financial reconciliation:

SELECT LEGAL_ENTITY_ID, NAME, SET_OF_BOOKS, BUSINESS_GROUP_FK FROM EDW_ORGA_LEG_ENTITY_LCV WHERE SET_OF_BOOKS = :p_set_of_books ORDER BY NAME;

Because the object belongs to an obsolete module and is documented as not implemented, these queries should be validated against the target environment before operational use, and migration to supported Organization dimension views is advisable in EBS 12.1.1 and 12.2.2.