Search Results gl_ledger_le_bsv_gt




Overview
Explore in AI Chat

Overview

GL_LEDGER_LE_BSV_GT is a Global Temporary Table (indicated by the "_GT" suffix) owned by the GL (General Ledger) schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The object name reflects its purpose: it stores ledger, legal entity, and balancing segment value (BSV) relationships used during General Ledger configuration and upgrade processing. The table plays a supporting role in the multi-organization architecture, where ledgers are associated with specific legal entities and balancing segment values to enforce accounting rules, security, and intercompany balancing.

Under the heuristic Data Vault classification mined from the foreign key structure, this object is classified as standalone. This modeling suggestion indicates that the table does not act as a strict hub or link within a Data Vault model, but rather as a transient staging or intermediate structure. Its Global Temporary Table nature reinforces this interpretation: rows are typically session-scoped and populated programmatically during upgrade or setup routines rather than persisted as master data.

Key Information Stored

The table contains 14 documented columns, the most significant of which include:

No surrogate primary key or unique index is documented in the ETRM metadata, consistent with the table's temporary, session-scoped nature. The business-key candidate is the combination of LEDGER_ID, LEGAL_ENTITY_ID, and BAL_SEG_VALUE, subject to the date range.

Common Use Cases and Queries

Typical use cases include validating ledger-to-legal-entity assignments during implementation, supporting the Ledger/Legal Entity/Balancing Segment Value setup flow in General Ledger, and driving upgrade scripts that convert legacy configuration into 12.2.2 multi-organization structures. A representative query pattern for reporting active relationships might resemble:

  • SELECT ledger_name, legal_entity_name, bal_seg_value FROM gl_ledger_le_bsv_gt WHERE relationship_enabled_flag = 'Y' AND SYSDATE BETWEEN start_date AND NVL(end_date, SYSDATE);
  • Joining to GL_LEDGERS on LEDGER_ID to enrich with ledger currency and period information.
  • Joining to FV_LEGAL_ENTITIES on LEGAL_ENTITY_ID to obtain legal entity registration details.

Because the table is a GTT, queries normally execute within the same session that populates it, typically a concurrent program or setup form.

Related Objects

  • GL_MGT_SEG_UPGRADE_H – Referenced via CHART_OF_ACCOUNTS_ID; used in management segment upgrade processing.
  • FV_LEGAL_ENTITIES – Referenced via LEGAL_ENTITY_ID; provides legal entity master data.
  • GL_LEDGERS – Logical parent for LEDGER_ID; source of ledger attributes.
  • GL_LEDGER_RELATIONSHIPS – Persists similar ledger-legal entity relationships for ongoing use.
  • GL_BALANCING_SEGMENT_VALUES – Maps balancing segment values used in the BAL_SEG columns.
  • GL_CODE_COMBINATIONS – Consumes BSV definitions for account validation.
  • XLA_LEDGER_RELATIONSHIPS – Subledger accounting references ledger/legal entity links.