Search Results gl_cross_rate_rules_u1

Overview

GL.GL_CROSS_RATE_RULES is a General Ledger configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores cross rate rule definitions used by the Daily Rates and cross-rate calculation engine. Each row defines a cross rate rule that links a GL daily conversion type to a pivot currency. When Oracle General Ledger needs a rate between two currencies for which no direct rate exists in GL_DAILY_RATES, it can triangulate the rate through the pivot currency defined in this table. Only conversion types that appear in this table are eligible for cross-rate derivation, making the table a controlling configuration element rather than a transactional store.

The table is owned by the GL schema (FND Design Data: SQLGL.GL_CROSS_RATE_RULES) and resides in the APPS_TS_TX_DATA tablespace. From a heuristic Data Vault modeling perspective, the dependency structure suggests a satellite-leaning classification, since the table is keyed by a single business key (CONVERSION_TYPE) that originates from the parent conversion type definition, and carries descriptive attributes rather than identifying a new hub or an associative link. Oracle marks this object as Internal Use Only and does not support direct data access outside standard Oracle Applications programs, so any read or write should be performed with appropriate caution.

Key Information Stored

The table contains eight columns, of which the following are the most significant:

• CONVERSION_TYPE (VARCHAR2(30), mandatory) — the conversion type defining column. This is the primary key of GL_CROSS_RATE_RULES and the column carried by the unique index GL_CROSS_RATE_RULES_U1, making it the business-key candidate. It also acts as a foreign key to GL_DAILY_CONVERSION_TYPES.
• PIVOT_CURRENCY (VARCHAR2(15)) — the currency from which cross rate rules are constructed. This is the intermediate currency used when triangulating rates, and it references FND_CURRENCIES.
• DESCRIPTION (VARCHAR2(240)) — free-text description of the cross rate rule, useful for reporting and audit clarity.

The remaining columns are standard Who audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN. The documented primary key is GL_CROSS_RATE_RULES_PK on CONVERSION_TYPE; the unique index GL_CROSS_RATE_RULES_U1 on the same column defines the natural business key. No surrogate sequence-driven identifier is documented for this table.

Common Use Cases and Queries

Typical usage centers on verifying cross-rate configuration for a conversion type, auditing pivot currency assignments, and joining rule definitions back to their conversion type master record.

• Identify all cross rate rules and their pivot currencies:

  SELECT CONVERSION_TYPE, PIVOT_CURRENCY, DESCRIPTION
  FROM   GL.GL_CROSS_RATE_RULES
  ORDER BY CONVERSION_TYPE;

• Join to the conversion type definition to validate the rule against its parent record:

  SELECT gcr.CONVERSION_TYPE, gct.DESCRIPTION, gcr.PIVOT_CURRENCY
  FROM   GL.GL_CROSS_RATE_RULES gcr,
         GL.GL_DAILY_CONVERSION_TYPES gct
  WHERE  gcr.CONVERSION_TYPE = gct.CONVERSION_TYPE;

• Confirm the pivot currency exists in the currency repository:

  SELECT gcr.CONVERSION_TYPE, gcr.PIVOT_CURRENCY, fc.NAME
  FROM   GL.GL_CROSS_RATE_RULES gcr, FND_CURRENCIES fc
  WHERE  gcr.PIVOT_CURRENCY = fc.CURRENCY_CODE;

• Reporting use cases include period-end rate triangulation audits, data quality checks for orphaned or duplicate rules, and change tracking through the Who columns to determine who last modified a rule.

Related Objects

The following objects are most significant in relation to GL_CROSS_RATE_RULES based on the documented dependency data:

• GL.GL_CROSS_RATE_RULE_DTLS — child detail table referencing GL_CROSS_RATE_RULES.CONVERSION_TYPE; holds the target currencies for which cross rates are generated.
• GL.GL_DAILY_CONVERSION_TYPES — parent of the conversion type; joined on CONVERSION_TYPE.
• FND_CURRENCIES — repository of currencies; joined on PIVOT_CURRENCY (CURRENCY_CODE).
• GL.GL_DAILY_RATES — the daily rates table where derived cross rates are ultimately stored and consumed.
• GL.GL_CROSS_RATE_RULES# — the base/internal object maintained by Oracle for this table.