Search Results gl_ledger_relationships_pk

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:

• RELATIONSHIP_ID — surrogate primary key (GL_LEDGER_RELATIONSHIPS_PK). Generated value; the only column in unique index U1.
• SOURCE_LEDGER_ID, TARGET_LEDGER_ID, PRIMARY_LEDGER_ID, SLA_LEDGER_ID — four foreign keys to GL_LEDGERS that define the ledger graph: which ledger the relationship originates from, the destination ledger, the primary ledger context, and the SLA ledger used by Subledger Accounting.
• TARGET_CURRENCY_CODE
• TARGET_LEDGER_CATEGORY_CODE, TARGET_LEDGER_NAME, TARGET_LEDGER_SHORT_NAME — descriptive attributes of the target ledger, denormalized for reporting convenience.
• RELATIONSHIP_TYPE_CODE
• RELATIONSHIP_ENABLED_FLAG — controls whether the relationship is active for processing.
• ALC_INITIALIZING_RATE_TYPE, ALC_DEFAULT_CONV_RATE_TYPE, ALC_PERIOD_AVERAGE_RATE_TYPE, ALC_PERIOD_END_RATE_TYPE — rate types, with the initializing rate optionally referencing GL_DAILY_CONVERSION_TYPES.
• ALC_INIT_PERIOD, ALC_INIT_DATE, ALC_INITIALIZING_RATE_DATE, ALC_NO_RATE_ACTION_CODE, ALC_MAX_DAYS_ROLL_RATE — govern how and when automatic currency conversion is initialized.
• GL_JE_CONVERSION_SET_ID, SL_COA_MAPPING_ID — references to the journal conversion set and SLA chart-of-accounts mapping used when transforming balances.
• STATUS_CODE, HIST_CONV_STATUS_CODE, DISABLE_CONVERSION_DATE — lifecycle and conversion-state indicators.
• APPLICATION_ID, ORG_ID — multi-org and application context columns, both included in unique index U2.

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.