Search Results gl_cross_rate_rules_dtls_u1

Overview

GL.GL_CROSS_RATE_RULE_DTLS is a General Ledger configuration table in Oracle E-Business Suite that defines the individual currency-pair entries belonging to a cross rate rule. Cross rate rules allow Oracle EBS to automatically derive exchange rates for currency combinations for which no direct rate has been entered, by calculating them through a common pivot currency. Each row in this table represents one permitted from-currency / to-currency combination under a named cross rate rule.

The object resides in the GL schema (FND Design Data: SQLGL.GL_CROSS_RATE_RULE_DTLS), is registered as VALID, and is stored in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10. The documented Data Vault classification for this object is a link. In dimensional modeling terms, this is consistent with its structure: the table holds the association between a cross rate rule header and the currency pairs governed by that rule, rather than acting as a standalone master (hub) or a purely descriptive history (satellite).

Key Information Stored

The table contains nine documented columns. The most significant are as follows:

• CONVERSION_TYPE (VARCHAR2 30, mandatory) — the conversion type defining column. It identifies the Oracle GL conversion type under which the cross rate rule operates and is the header join key.
• FROM_CURRENCY (VARCHAR2 15) — the source currency of the cross rate combination.
• TO_CURRENCY (VARCHAR2 15) — the target currency of the cross rate combination.
• ENABLED_FLAG (VARCHAR2) — documented as reserved for future use, indicating whether a cross rate should be generated for the combination.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide the standard audit trail required for Oracle Applications concurrent processing and diagnostics.

The documented primary key is GL_CROSS_RATE_RULES_DTLS_PK, defined over (CONVERSION_TYPE, FROM_CURRENCY, TO_CURRENCY). A second unique index, GL_CROSS_RATE_RULES_DTLS_U1, is defined over the identical column list and stored in APPS_TS_TX_IDX. Because the primary key columns are natural business identifiers rather than a system-generated surrogate, the unique index and the primary key are functionally redundant; the U1 index is the business-key candidate that guarantees no duplicate currency pair exists within a single conversion type.

Common Use Cases and Queries

Typical usage centers on verifying which currency pairs are configured for automatic cross rate derivation, diagnosing missing-rate errors during journal import or revaluation, and auditing configuration changes. A representative query joins the detail rows to the rule header:

• List all currency pairs for a conversion type:

SELECT d.conversion_type, d.from_currency, d.to_currency, d.enabled_flag
FROM gl.gl_cross_rate_rule_dtls d
WHERE d.conversion_type = :conversion_type;

• Validate that a specific pair exists before a conversion is expected to succeed:

SELECT COUNT(*)
FROM gl.gl_cross_rate_rule_dtls
WHERE conversion_type = :ctype
AND from_currency = :from_ccy
AND to_currency = :to_ccy;

• Audit recent configuration changes using the Who columns:

SELECT conversion_type, from_currency, to_currency, last_update_date, last_updated_by
FROM gl.gl_cross_rate_rule_dtls
WHERE last_update_date > SYSDATE - 30;

These patterns support month-end close troubleshooting, where an unconfigured pair produces a missing cross rate and blocks revaluation or translation.

Related Objects

Documented dependencies and foreign keys identify the following significant related objects:

• GL.GL_CROSS_RATE_RULES — the rule header. Joined on CONVERSION_TYPE to obtain the rule name and pivot currency.
• FND_CURRENCIES — referenced twice, by FROM_CURRENCY and TO_CURRENCY, to resolve currency names and precision attributes.
• GL_CROSS_RATE_RULE_DTLS# — the internal dependent object generated for this table.

The table does not reference any other database object beyond those listed, and Oracle documentation restricts application data access to standard Oracle Applications programs.