Results for “gl_daily_rates_interface”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The GL_DAILY_RATES_INTERFACE table, owned by the GL schema, is the General Ledger interface staging table used by Oracle E-Business Suite to import daily currency conversion rates into the applications. It accepts externally sourced rate data — typically supplied by a feeder system, a spreadsheet, or a legacy conversion load — validates that data, and passes it to the standard concurrent program that ultimately populates GL_DAILY_RATES, the production rate repository consumed at journal entry, revaluation, and translation time. In both 12.1.1 and 12.2.2 the table is documented as VALID and remains the supported inbound path for rate loading; the 12.2.2 physical schema exposes 29 columns.

Under a heuristic Data Vault classification derived from its foreign-key structure, this table is best modeled as a link object rather than a hub or a satellite. Its identity is composed entirely of relationships — a from-currency, a to-currency, a conversion window, and a conversion type — rather than a single business entity key.

Key Information Stored

The GL_DAILY_RATES_INTERFACE_PK primary key is composite and non-surrogate, formed by FROM_CURRENCY, TO_CURRENCY, FROM_CONVERSION_DATE, TO_CONVERSION_DATE, and USER_CONVERSION_TYPE. This composite serves simultaneously as the primary key and as the natural business-key candidate; there is no generated sequence identifier, so re-loading an identical tuple is a duplicate-key condition rather than a distinct row. Of the 29 documented columns, the most consequential are:

• FROM_CURRENCY / TO_CURRENCY — the currency pair for which the rate applies, validated against FND_CURRENCIES.
• FROM_CONVERSION_DATE / TO_CONVERSION_DATE — the effective date range for the rate. This is the pair matched by the user's search term to_conversion_date, which marks the inclusive end of the rate window.
• USER_CONVERSION_TYPE — the conversion rate type (for example Spot, Corporate, or a user-defined type).
• CONVERSION_RATE / INVERSE_CONVERSION_RATE — the rate and its reciprocal; the load program derives the missing direction when one value is supplied.
• MODE_FLAG — controls insert versus update-versus-delete semantics for the incoming row.
• ERROR_CODE — populated by validation, identifying rows rejected during import.
• USER_ID — the loading user, validated against FND_USER.
• LAUNCH_RATE_CHANGE — flags whether downstream resources must be refreshed after the load.
• BATCH_NUMBER — groups rows belonging to one submission for control-total reporting and multi-batch recovery.
• USED_FOR_AB_TRANSLATION — marks rates eligible for average-balance translation.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield segment columns.

Common Use Cases and Queries

The dominant use case is staged rate loading. A feeder inserts rows, then the Daily Rates Import concurrent program is run; rows with errors are corrected and resubmitted, and successful rows are purged from the interface. Recurring queries include isolating rejected rows: SELECT FROM_CURRENCY, TO_CURRENCY, FROM_CONVERSION_DATE, TO_CONVERSION_DATE, ERROR_CODE FROM GL_DAILY_RATES_INTERFACE WHERE ERROR_CODE IS NOT NULL;. Date-window analysis, which is what the to_conversion_date search targets, typically filters on the upper bound: SELECT * FROM GL_DAILY_RATES_INTERFACE WHERE TO_CONVERSION_DATE BETWEEN :p_start AND :p_end AND USER_CONVERSION_TYPE = :p_type;. Control-total reconciliation groups by BATCH_NUMBER, and pre-load duplicate detection joins the interface to GL_DAILY_RATES on the five business key columns to prevent overlapping windows.

Related Objects

• GL_DAILY_RATES — the production destination table populated from the interface on successful import.
• FND_CURRENCIES — referenced by FROM_CURRENCY and TO_CURRENCY.
• FND_USER — referenced by USER_ID.
• GL_DAILY_CONVERSION_TYPES — defines the valid values for USER_CONVERSION_TYPE.
• Daily Rates Import concurrent program — the standard interface process that validates and transfers rows.
• GL_DAILY_RATES_V and related inquiry views — validate inbound rates against existing production entries.

All three documented foreign keys render the table a pure link between currency, user, and conversion-type reference data, with no dependent satellite columns owned outside the row itself.