Search Results xle_fp_ledger_v




Overview
Explore in AI Chat

Overview

XLE_FP_LEDGER_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Legal Entity Configurator (XLE) product. Its purpose is to expose the relationship between a General Ledger ledger and the legal entity that owns or is associated with that ledger, restricted to the balancing segment. In Oracle EBS 12.1.1 and 12.2.2, the Legal Entity Configurator is the repository for legal entity definitions and their assignments to ledgers, and downstream processes such as subledger accounting, intercompany balancing, and tax determination frequently need to resolve a ledger to its legal entity context. Rather than requiring callers to join GL_LEDGERS, GL_LEDGER_CONFIGURATIONS, GL_LEDGER_NORM_SEG_VALS, XLE_ENTITY_PROFILES, and HZ_GEOGRAPHIES manually, XLE_FP_LEDGER_V encapsulates that join into a single reusable object. The view is documented as VALID and is referenced in ETRM metadata for both 12.1.1 and 12.2.2. The user search term "gl_ledger_norm_seg_vals" reflects the fact that this base table is central to the view's definition, since it supplies the balancing segment value that ties a ledger to its legal entity.

Underlying Base Objects

The view is defined over five referenced base objects, all exposed through APPS synonyms:

  • GL_LEDGERS — the ledger master, supplying LEDGER_ID, NAME, SHORT_NAME, LEDGER_CATEGORY_CODE, and CONFIGURATION_ID.
  • GL_LEDGER_CONFIGURATIONS — the ledger configuration header, used to filter out ledgers whose configuration is still IN_PROGRESS.
  • GL_LEDGER_NORM_SEG_VALS — the normalized segment value assignments for a ledger; the view restricts this to SEGMENT_TYPE_CODE = 'B' (balancing segment) and excludes rows whose STATUS_CODE is 'D'.
  • XLE_ENTITY_PROFILES — the legal entity definition, supplying the legal entity name, identifier, and effective dates.
  • HZ_GEOGRAPHIES — the geography repository, restricted to GEOGRAPHY_TYPE = 'COUNTRY', providing the legal entity's country code.

The join logic resolves the legal entity either through the balancing segment value's LEGAL_ENTITY_ID or, when that is null, directly from XLE_ENTITY_PROFILES via NVL. The configuration join ensures only completed ledger configurations are returned, and the geography join enforces a valid country-level geography for the legal entity.

Key Columns

Common Use Cases and Queries

The view is typically used to report the ledger-to-legal-entity mapping for a given balancing segment, to validate configuration before period close, or to feed downstream integrations that need country and entity identifiers. A representative query retrieves the active ledger and entity information for a balancing segment value:

  • SELECT ledger_name, ledger_short_name, legal_entity_name, legal_entity_country, segment_value FROM apps.xle_fp_ledger_v WHERE segment_value = :balancing_segment;
  • SELECT ledger_id, legal_entity_id, ledger_category_code FROM apps.xle_fp_ledger_v WHERE ledger_category_code = 'PRIMARY';
  • SELECT legal_entity_name, le_effective_from, le_effective_to FROM apps.xle_fp_ledger_v WHERE SYSDATE BETWEEN le_effective_from AND NVL(le_effective_to, SYSDATE);

Because the view already filters for completed configurations, active balancing segments, and valid country geographies, queries against it return only usable ledger-entity combinations, making it suitable for operational reporting and integration lookups in both 12.1.1 and 12.2.2 environments.