Search Results gl_ledger_relationships




Overview
Explore in AI Chat

Overview

GL_LEDGER_RELATIONSHIPS is a General Ledger configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the defined relationships between ledgers within a ledger set or accounting configuration. It is the repository for the ledger-to-ledger mappings that drive cross-ledger processing, including secondary ledger assignment, reporting ledger derivation, and the currency conversion rules that govern how balances flow from a source ledger to a target ledger. Records in this table determine the behavior of features such as Automatic Ledger Currency (ALC), journal conversion, and subledger accounting (SLA) integration across multiple ledgers.

From a data-modeling perspective, the mined foreign-key structure suggests classifying this object heuristically as a link table. It resolves many-to-many semantics between GL_LEDGERS rows (source, target, primary, and SLA) while carrying an extensive set of descriptive attributes — rate types, conversion options, initialization periods, and status codes — that give it satellite-like characteristics. The combination of surrogate primary key plus a wide business-key unique index places it firmly as a configuration link in the Data Vault sense.

Key Information Stored

The tablespace holds 36 documented columns. The most operationally significant are:

Unique index U2 (SOURCE_LEDGER_ID, TARGET_LEDGER_CATEGORY_CODE, RELATIONSHIP_TYPE_CODE, TARGET_LEDGER_ID, TARGET_CURRENCY_CODE, PRIMARY_LEDGER_ID, APPLICATION_ID, ORG_ID) is the business-key candidate that prevents duplicate relationship definitions.

Common Use Cases and Queries

Typical reporting and diagnostic scenarios include verifying which target ledgers are enabled for a given source ledger, auditing ALC conversion configuration, and confirming the SLA ledger mapped to a primary ledger.

  • List all active relationships for a ledger:
    SELECT r.relationship_id, l.name source_ledger, r.target_ledger_name, r.relationship_type_code FROM gl_ledger_relationships r, gl_ledgers l WHERE r.source_ledger_id = l.ledger_id AND r.relationship_enabled_flag = 'Y';
  • Audit currency conversion rules: query ALC_INITIALIZING_RATE_TYPE, ALC_DEFAULT_CONV_RATE_TYPE, and ALC_NO_RATE_ACTION_CODE joined to GL_DAILY_CONVERSION_TYPES.
  • Identify SLA ledger mappings by filtering on SLA_LEDGER_ID joined to GL_LEDGERS.
  • Reconcile secondary ledger definitions against the ledger set configuration used in GL consolidation.

Because the table is configuration data, direct DML is not recommended; changes should be made through the Define Ledger/Relationship concurrent programs or the corresponding Oracle Forms.

Related Objects

  • GL_LEDGERS — parent of SOURCE_LEDGER_ID, TARGET_LEDGER_ID, PRIMARY_LEDGER_ID, and SLA_LEDGER_ID.
  • FND_CURRENCIES — referenced by TARGET_CURRENCY_CODE.
  • GL_DAILY_CONVERSION_TYPES — referenced by ALC_INITIALIZING_RATE_TYPE.
  • GL_LEDGER_SETS / GL_LEDGER_SET_NORM_ASSIGN — define the ledger set context in which relationships are evaluated.
  • GL_JE_CONVERSION_SETS — referenced by GL_JE_CONVERSION_SET_ID.
  • SLA chart-of-accounts mapping tables — referenced by SL_COA_MAPPING_ID.
  • GL_LEDGER_RELATIONSHIPS_PK / _U1 / _U2 — indexes enforcing uniqueness and supporting joins.