Results for “from_ledger_name”

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

Overview

GL_CONSOLIDATION_NAMES_V is a General Ledger reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents consolidation definitions from GL_CONSOLIDATION joined to the source and target ledgers, along with the chart of accounts mapping that governs the transfer of balances. The view exposes both the internal ledger identifiers and their resolved display names, so it functions as a denormalized, user-friendly access point for consolidation metadata without requiring the caller to perform the joins manually.

The name reflects its primary purpose: resolving consolidation identifiers into descriptive names. Consolidation in General Ledger is the process by which balances from one or more source ledgers are transferred into a single target ledger, typically for enterprise-wide reporting or for aggregating statutory ledgers. Because the view carries both FROM_ and TO_ prefixed ledger attributes, it supports reports that must show which ledger consolidates into which, and under what method and usage code.

For users searching on "consolidation_ledger_flag", the view is directly relevant. It surfaces the CONSOLIDATION_LEDGER_FLAG from GL_LEDGERS twice — once as FROM_CONSOLIDATION_LEDGER_FLAG and once as TO_CONSOLIDATION_LEDGER_FLAG. This flag indicates whether a ledger is designated specifically as a consolidation ledger, distinguishing ledgers whose sole purpose is to receive consolidated balances from those used for primary transaction processing.

Underlying Base Objects

The view is defined over three synonyms and three packages. The synonyms are GL_CONSOLIDATION, GL_LEDGERS, and GL_COA_MAPPINGS. GL_CONSOLIDATION supplies the consolidation definition, including its name, description, method, usage code, currency codes, and the run-time behavior flags. GL_LEDGERS is referenced twice, aliased LEDGER1 for the source (FROM_LEDGER_ID) and LEDGER2 for the target (TO_LEDGER_ID), providing names, short names, average balance flags, and the consolidation ledger flags. GL_COA_MAPPINGS supplies the mapping definition between the two ledgers, contributing the active start and end dates.

The package references are GL_FC_XLATE_PKG, FND_GLOBAL, and FND_DATA_SECURITY. GL_FC_XLATE_PKG provides the GET_LEDGER_SHORT_NAME and GET_LEDGER_NAME functions used to resolve ledger display names against the relevant currency context. FND_GLOBAL supplies the current user name, and FND_DATA_SECURITY provides CHECK_FUNCTION, which enforces the consolidation security model. Joins are equi-joins on FROM_LEDGER_ID, TO_LEDGER_ID, and COA_MAPPING_ID.

Key Columns

• CONSOLIDATION_ID, NAME, DESCRIPTION — identity and descriptive attributes of the consolidation definition.
• METHOD and USAGE_CODE — the consolidation method and the usage classification of the definition.
• FROM_LEDGER_ID / FROM_LEDGER_NAME / FROM_SHORT_NAME — the source ledger and its resolved display names.
• TO_LEDGER_ID / TO_LEDGER_NAME / TO_SHORT_NAME — the target ledger, typically the consolidation ledger itself.
• FROM_CONSOLIDATION_LEDGER_FLAG and TO_CONSOLIDATION_LEDGER_FLAG — the CONSOLIDATION_LEDGER_FLAG from GL_LEDGERS for each side, identifying ledgers designated for consolidation.
• FROM_ENABLE_AB_FLAG and TO_ENABLE_AB_FLAG — average balance enablement for each ledger.
• START_DATE_ACTIVE and END_DATE_ACTIVE — active date range of the underlying chart of accounts mapping.
• FROM_CURRENCY_CODE — the currency context applied to the source ledger name resolution.
• RUN_JOURNAL_IMPORT, SUMMARIZE_LINES, AUDIT_MODE, RUN_POSTING_FLAG — run-time behavior flags, each defaulted via NVL where a null would otherwise occur.
• USE_PRIVILEGE — computed through FND_DATA_SECURITY.CHECK_FUNCTION, returning 'Y' or 'N' based on the user's access to the consolidation definition.

Common Use Cases and Queries

Typical uses include consolidation setup reports, security-filtered lists of available consolidations, and integration queries that must resolve ledger identifiers into names. Because USE_PRIVILEGE already applies data security, the view is well suited to forms and concurrent program parameters that must restrict a user's selection to authorized consolidations.

• List all consolidations with their source and target ledger names.
• Identify consolidation ledgers by filtering on the consolidation ledger flags.
• Restrict output to definitions the current user is permitted to use.

A representative query follows:

SELECT consolidation_id, name, from_ledger_name, to_ledger_name, method, usage_code FROM gl_consolidation_names_v WHERE use_privilege = 'Y' AND to_consolidation_ledger_flag = 'Y' ORDER BY name;

The USE_PRIVILEGE predicate constrains results to definitions the user may access, while the consolidation ledger flag predicate isolates consolidations whose target ledger is designated as a consolidation ledger.