[Home] [Help] [Dependency Information]

TABLE: GL.GL_DAILY_RATES_INTERFACE

Object Details

Object Name:	GL_DAILY_RATES_INTERFACE
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_DAILY_RATES_INTERFACE
Subobject Name:
Status:	VALID

GL_DAILY_RATES_INTERFACE is used to create, update, and delete daily conversion rates. You can use this table to load rates into the GL_DAILY_RATES table.
To use this table to insert/update rates into GL_DAILY_RATES, insert rows into it with a FROM_CURRENCY, a TO_CURRENCY, a FROM_CONVERSION_DATE, a TO_CONVERSION_DATE, a USER_CONVERSION_TYPE, a CONVERSION_RATE, a MODE of 'I', and optionally, an INVERSE_CONVERSION_RATE. Oracle General Ledger will automatically create rows in GL_DAILY_RATES for each date between the FROM_CONVERSION_DATE and the TO_CONVERSION_DATE, using the specified FROM_CURRENCY, TO_CURRENCY, USER_CONVERSION_TYPE, and CONVERSION_RATE.
It will also automatically insert the inverse rows, switching the FROM_CURRENCY and TO_CURRENCY and using the INVERSE_CONVERSION_RATE, if provided, or otherwise, taking the inverse of the CONVERSION_RATE provided. If these rows already exist, it will update these rows with the new rates instead.
For example, if you specified a FROM_CURRENCY of USD, a TO_CURRENCY of CND, a FROM_CONVERSION_DATE of January 1, 1997, a TO_CONVERSION_DATE of January 3, 1997, a USER_CONVERSION_TYPE of Spot, a CONVERSION_RATE of 1.377, an INVERSION_CONVERSION_RATE of NULL, and a MODE of 'I', Oracle General Ledger will automatically create three rows in GL_DAILY_RATES with a FROM_CURRENCY of USD, a TO_CURRENCY of CND, a CONVERSION_TYPE of Spot, a CONVERSION_RATE of 1.377, and with CONVERSION_DATEs of January 1, 1997, January 2, 1997, and January 3, 1997. It would also automatically create the three inverse rows in GL_DAILY_RATES with a FROM_CURRENCY of CND, a TO_CURRENCY of USD, a CONVERSION_TYPE of Spot, a CONVERSION_RATE of 0.7262, and with CONVERSION_DATEs of January 1, 1997, January 2, 1997, and January 3, 1997.
To use this table to delete rows from GL_DAILY_RATES, insert rows into it with a FROM_CURRENCY, a TO_CURRENCY, a FROM_CONVERSION_DATE, a TO_CONVERSION_DATE, a USER_CONVERSION_TYPE, a dummy CONVERSION_RATE, and a MODE of 'D'. Any rates in GL_DAILY_RATES with a date between the FROM_CONVERSION_DATE and TO_CONVERSION_DATE and with that FROM_CURRENCY, TO_CURRENCY, and USER_CONVERSION_TYPE will be deleted automatically. The corresponding inverse rows will also be deleted.
The insert/update/delete is all done automatically by database triggers on GL_DAILY_RATES_INTERFACE. No import programs need to be run.
Note that when inserting into this table, you must specify the USER_CONVERSION_TYPE, not the CONVERSION_TYPE. Oracle General Ledger will automatically convert the USER_CONVERSION_TYPE to the CONVERSION_TYPE when it maintains GL_DAILY_RATES.
Scope: public
Product: GL
Lifecycle: active
Display Name: GL Daily Rate Interface
Category: BUSINESS_ENTITY GL_DAILY_RATE

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT FROM_CURRENCY
,      TO_CURRENCY
,      FROM_CONVERSION_DATE
,      TO_CONVERSION_DATE
,      USER_CONVERSION_TYPE
,      CONVERSION_RATE
,      MODE_FLAG
,      INVERSE_CONVERSION_RATE
,      USER_ID
,      LAUNCH_RATE_CHANGE
,      ERROR_CODE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      USED_FOR_AB_TRANSLATION
,      BATCH_NUMBER
FROM GL.GL_DAILY_RATES_INTERFACE;

Dependencies

[top of page]

GL.GL_DAILY_RATES_INTERFACE does not reference any database object

GL.GL_DAILY_RATES_INTERFACE is referenced by following:

GL

GL_DAILY_RATES_INTERFACE#