Search Results gl_xfr_ledgers

Overview

GL_XFR_LEDGERS is a General Ledger configuration table in the GL schema that stores the definition and behavioral attributes of ledgers within the Oracle E-Business Suite environment. In releases 12.1.1 and 12.2.2, the table serves as a foundational repository for ledger setup, capturing the accounting configuration, currency and calendar assignments, subledger accounting (SLA) options, budgetary control settings, translation and revaluation rules, and journal processing controls that govern how an individual ledger behaves across the EBS financials suite. With 110 documented columns, it is one of the richer configuration surfaces in the General Ledger module.

The table is classified through heuristic Data Vault modeling as standalone. This suggests it is best treated as an independent reference or configuration entity rather than as a classic hub, link, or satellite within a Data Vault design. Its primary key, GL_XFR_LEDGERS_PK, is defined on LEDGER_ID, and two unique indexes exist: GL_XFR_LEDGERS_U1 on NAME and GL_XFR_LEDGERS_U2 on LEDGER_ID, both of which are business-key candidates alongside the surrogate identifier.

Key Information Stored

The most significant columns include:

• LEDGER_ID — the surrogate primary key and the unique identifier for the ledger definition.
• NAME and SHORT_NAME — the business-key identifiers used throughout the application to reference the ledger.
• LEDGER_CATEGORY_CODE and ALC_LEDGER_TYPE_CODE — classify the ledger by category and accounting ledger type.
• CHART_OF_ACCOUNTS_ID — links the ledger to its chart of accounts structure.
• CURRENCY_CODE and PERIOD_SET_NAME/ACCOUNTED_PERIOD_TYPE — define the ledger currency and accounting calendar.
• TRANSACTION_CALENDAR_ID — a foreign key to GL_TRANSACTION_CALENDAR for daily conversion rate calendar assignment.
• SLA_ACCOUNTING_METHOD_CODE and SLA_SEQUENCING_FLAG — control subledger accounting method and sequencing behavior.
• ENABLE_BUDGETARY_CONTROL_FLAG and REQUIRE_BUDGET_JOURNALS_FLAG — budgetary control configuration.
• ENABLE_JE_APPROVAL_FLAG — journal approval enablement.
• TRANSLATE_QATD_FLAG, TRANSLATE_YATD_FLAG, and DAILY_TRANSLATION_RATE_TYPE — currency translation rules.
• LATEST_OPENED_PERIOD_NAME and LATEST_ENCUMBRANCE_YEAR — track the currently open accounting period and encumbrance year.
• CONSOLIDATION_LEDGER_FLAG — indicates whether the ledger is a consolidation ledger.

Common Use Cases and Queries

Typical uses include identifying the active ledger for a legal entity, enumerating ledgers by currency or calendar, validating SLA and budgetary control configuration, and auditing translation and revaluation settings prior to period close. Example patterns:

• Listing all ledgers and their currency and calendar: SELECT LEDGER_ID, NAME, CURRENCY_CODE, PERIOD_SET_NAME FROM GL.GL_XFR_LEDGERS ORDER BY NAME;
• Finding ledgers with journal approval enabled: SELECT LEDGER_ID, NAME FROM GL.GL_XFR_LEDGERS WHERE ENABLE_JE_APPROVAL_FLAG = 'Y';
• Joining to the transaction calendar to report calendar assignments: SELECT l.NAME, tc.CALENDAR_NAME FROM GL.GL_XFR_LEDGERS l JOIN GL.GL_TRANSACTION_CALENDAR tc ON l.TRANSACTION_CALENDAR_ID = tc.TRANSACTION_CALENDAR_ID;

Related Objects

The documented foreign keys and probable dependencies include:

• GL_MGT_SEG_UPGRADE_H — referenced through CHART_OF_ACCOUNTS_ID (management segment upgrade history).
• GL_TRANSACTION_CALENDAR — referenced through TRANSACTION_CALENDAR_ID.
• GL_LEDGERS and GL_LEDGER_RELATIONSHIPS — the operational ledger definition and ledger relationship structures that depend on the configuration held here.
• GL_LEDGER_CONFIG_DETAILS and GL_LEDGER_SET_ASSIGNMENTS — supporting configuration and ledger set mappings.
• FND_ID_FLEX_STRUCTURES — referenced indirectly via the chart of accounts structure.

Together, these objects form the ledger configuration substrate used across General Ledger, Subledger Accounting, and the broader financials modules.