Search Results gl_ledger_le_bsv_specific_v




Overview
Explore in AI Chat

Overview

The GL_LEDGER_LE_BSV_SPECIFIC_V view, owned by the APPS schema and residing in the General Ledger (GL) module, provides a consolidated, reportable representation of the relationship between accounting ledgers and the legal entities and balancing segment values assigned to them. It is documented as a VALID view in Oracle EBS 12.1.1 and 12.2.2 and is referenced in the ETRM repository under the GL — General Ledger product group. The view is designed to expose ledger-level attributes alongside the legal entity and balancing segment value (BSV) that are specific to each ledger, thereby answering the common user search term "legal_entity_name" directly.

This view plays a critical role in reporting, integration, and ledger setup analysis. It allows users and developers to determine which legal entity name corresponds to a given balancing segment value within a specific ledger, a requirement frequently encountered in multi-organization and multi-entity accounting configurations.

Underlying Base Objects

The ETRM metadata documents the view as defined over three referenced base objects, exposed through public synonyms in the APPS schema:

  • GL_LEDGERS — the ledger definition table, supplying ledger identity, name, short name, and category.
  • GL_LEDGER_NORM_SEG_VALS — the normalized segment values table, filtered to balancing segment type ('B') and active statuses.
  • XLE_ENTITY_PROFILES — the legal entity profile table, supplying the legal entity identifier and name.

The view is constructed as a join between these tables. The join between GL_LEDGERS and GL_LEDGER_NORM_SEG_VALS is on LEDGER_ID, restricted to complete ledgers (NVL(LG.COMPLETE_FLAG,'Y') = 'Y'). The join to XLE_ENTITY_PROFILES is an outer join (LE.LEGAL_ENTITY_ID (+) = BSV.LEGAL_ENTITY_ID), ensuring that a ledger/BSV combination without an assigned legal entity still appears, with a NULL legal entity name.

Key Columns

  • LEDGER_ID — unique identifier of the ledger.
  • LEDGER_NAME / LEDGER_SHORT_NAME — descriptive names of the ledger.
  • LEGAL_ENTITY_ID — identifier of the legal entity assigned to the balancing segment value.
  • LEGAL_ENTITY_NAME — the descriptive name of the legal entity, sourced from XLE_ENTITY_PROFILES. This is the column most directly relevant to the user's search.
  • LEDGER_CATEGORY_CODE — the category of the ledger (e.g., PRIMARY, SECONDARY).
  • SEGMENT_VALUE — the balancing segment value (BSV) associated with the ledger.
  • START_DATE / END_DATE — the effective date range for the legal entity/BSV assignment.

Common Use Cases and Queries

A frequent requirement is to resolve the legal entity name for a specific ledger and balancing segment value, particularly when validating data or building custom reports:

  • Identifying which legal entity owns a given balancing segment value in a ledger.
  • Listing all ledgers and their associated legal entities for cross-validation during period close.
  • Supporting tax, intercompany, and statutory reporting that requires a legal entity context.

A sample query retrieving ledger and legal entity information is:

SELECT ledger_name, ledger_short_name, legal_entity_name, segment_value, start_date, end_date FROM apps.gl_ledger_le_bsv_specific_v WHERE ledger_id = :p_ledger_id;

Because the view exposes both the balancing segment value and the legal entity name, it serves as a reliable reference for configuration audits and integration mappings in Oracle EBS 12.1.1 and 12.2.2.