Search Results le_effective_from




Overview
Explore in AI Chat

Overview

APPS.XLE_FP_LEDGER_V is a reporting view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments that joins ledger configuration data with the legal entity profile information that governs a given ledger's balancing segment value. The view presents, for each ledger, its ledger identifier, name, short name, category, and the balancing segment value used by that ledger, alongside the legal entity responsible for that balancing segment and the country in which that legal entity is registered.

The view belongs to the Subledger Accounting / E-Business Tax (XLE) family of objects. Its name prefix XLE_FP (Legal Entity, Financials Profile) indicates that it is intended to expose the relationship between a ledger and its associated legal entity. This makes it a convenient denormalized source for reports, extracts, and integrations that need to determine which legal entity owns a ledger or a specific balancing segment value without having to re-create the multi-table join themselves.

Underlying Base Objects

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

The join between the balancing segment value and the legal entity is deliberately forgiving: the view uses NVL(bsv.LEGAL_ENTITY_ID, xlep.LEGAL_ENTITY_ID) so that a legal entity assigned directly on the segment value takes precedence, while the legal entity assigned at the ledger level is used as a fallback.

Key Columns

Common Use Cases and Queries

Typical uses include determining the legal entity and country for a ledger, validating effective dating of legal entity assignments, and driving tax or subledger reporting that must be grouped by legal entity.

To list the legal entity and its effective dates for a specific ledger:

  • SELECT ledger_id, ledger_name, legal_entity_name, legal_entity_country, le_effective_from, le_effective_to FROM apps.xle_fp_ledger_v WHERE ledger_id = :p_ledger_id;

To find legal entities effective as of a given date:

  • SELECT ledger_name, segment_value, legal_entity_name, le_effective_from FROM apps.xle_fp_ledger_v WHERE :p_date BETWEEN le_effective_from AND NVL(le_effective_to, :p_date);

Because the view already filters incomplete ledger configurations and deleted segment values, it is generally safe to query directly, though additional filtering on ledger category or country is common in multi-entity reporting.