GL daily conversion rates

AP invoice interface, askHareesh blog for Oracle Apps

GL daily conversion rates

This interface lets you load the rates automatically into General Ledger.

Pre-requisites:
  • Currencies
  • Conversion rate Types
Interface tables:
  • GL_DAILY_RATES_INTERFACE
Base tables:
  • GL_DAILY_RATES
  • GL_DAILY_CONVERSION_TYPES
Concurrent Program:
You do not need to run any import programs. The insert, update, or deletion of rates in GL_DAILY_RATES is done automatically by database triggers on the GL_DAILY_RATES_INTERFACE. All that is required is to develop program to populate the interface table with daily rates information.

Validations:
  • Check if FROM_CURRENCY and TO_CURRENCY are valid.
  • Check if USER_CONVERSION_TYPE is valid.
Important Columns:
Some important columns that need to be populated in the interface tables:
GL_DAILY_RATES_INTERFACE:
  • FROM_CURRENCY
  • TO_CURRENCY
  • FROM_CONVERSION_DATE
  • TO_CONVERSION_DATE
  • USER_CONVERSION_TYPE
  • CONVERSION_RATE
  • MODE_FLAG (D= Delete, I = Insert, U = Update)
  • INVERSE_CONVERSION_RATE
  • GL'S INTERFACE TABLES


*/