Search Results gl_ledger_config_details




Overview
Explore in AI Chat

Overview

The GL_LEDGER_CONFIG_DETAILS table is a core repository for the structural relationships within the Oracle E-Business Suite General Ledger's accounting setup. It serves as the central table that defines and stores the associations between a primary ledger and its related accounting entities. In the context of Oracle EBS 12.1.1 and 12.2.2, this table is fundamental to the Accounting Setup Manager (ASM), which provides a unified interface for configuring financial reporting structures. Its primary role is to maintain the complete configuration details for a ledger, mapping it to its associated secondary ledgers, legal entities, and reporting currencies, thereby establishing the framework for transaction processing and financial consolidation.

Key Information Stored

The table's structure is designed to link a primary ledger to its related components. While the full column list is not detailed in the provided metadata, the foreign key relationship indicates the presence of a critical column, CONFIGURATION_ID. This key links each detail record to its parent definition in the GL_LEDGER_CONFIGURATIONS table. Based on its documented purpose, the table is expected to store columns that identify the primary ledger and the specific type and identifier of each associated entity. This typically includes fields for the ledger ID, the associated object type (e.g., secondary ledger, legal entity, reporting currency), the associated object's identifier, and the configuration sequence or status. It acts as the junction table that materializes the many-to-many relationships defined during the accounting setup.

Common Use Cases and Queries

This table is essential for reporting and validation on the accounting configuration. Common use cases include generating a summary report of all entities linked to a specific primary ledger, validating setup completeness before period close, and supporting data migration scripts. A fundamental query pattern involves joining GL_LEDGER_CONFIG_DETAILS with GL_LEDGERS to resolve ledger names.

  • List all configurations for a ledger: SELECT * FROM gl_ledger_config_details WHERE configuration_id = (SELECT configuration_id FROM gl_ledger_configurations WHERE ledger_id = <ledger_id>);
  • Find all secondary ledgers for a primary ledger: A query would join GL_LEDGER_CONFIG_DETAILS to GL_LEDGERS, filtering on the object type column for secondary ledgers.
  • Audit Setup: Queries against this table are used to ensure every primary ledger has at least one legal entity assigned and that reporting currencies are correctly defined.

Related Objects

The GL_LEDGER_CONFIG_DETAILS table has a direct and critical dependency on the GL_LEDGER_CONFIGURATIONS table, as defined by its foreign key on CONFIGURATION_ID. GL_LEDGER_CONFIGURATIONS acts as the header record for a ledger's overall setup. Furthermore, this detail table is intrinsically linked to core GL tables such as GL_LEDGERS (for ledger details), XLE_ENTITY_PROFILES (for legal entities), and GL_JE_HEADERS (which may be filtered by the legal entities defined here). It is also referenced by various Accounting Setup Manager forms and underlying APIs, making it a pivotal point for any customization or extension of the standard accounting configuration.