Friday, September 12, 2014

How to fix error EC06:There is no conversion rate for this currency, conversion type, and conversion date in oracle GL

How to fix error EC06:There is no conversion rate for this currency, conversion type, and conversion date in oracle GL


Please verify below columns of such errored records from gl_interface

CURRENCY_CODE
USER_CURRENCY_CONVERSION_TYPE
CURRENCY_CONVERSION_DATE


Run below query to get details-

SELECT CURRENCY_CODE,
       USER_CURRENCY_CONVERSION_TYPE,
       CURRENCY_CONVERSION_DATE,GL.*
FROM GL.GL_INTERFACE GL
WHERE STATUS LIKE '%EC06%';


Once you have these details you have to verify for that currenct conversion rate is defined or not for conversion date.

SQL Table which holds daily exchange rate-
GL_DAILY_RATES

Run below query to get details-

SELECT  
FROM_CURRENCY, --currecy code of errored record
TO_CURRENCY,
CONVERSION_DATE, --CURRENCY_CONVERSION_DATE of errored record
CONVERSION_TYPE, --USER_CURRENCY_CONVERSION_TYPE of erroed record
CONVERSION_RATE,
GDR.*
FROM GL_DAILY_RATES GDR;


If you are not getting any record in this table for details of errored records. means that there is conversion rate not defined for given conversion date of that currency

Setup to define currency conversion rate for currency

Responsibility: General Ledger Super User
Login with this repsonsibility or any custom GL super user responsibility
Navigation:
Setup > Currencies > Rates > Types

First here verify that conversion type is defined. This is SER_CURRENCY_CONVERSION_TYPE of errored record.
If not defined then first please define conversion type

SQL Table:
GL_DAILY_CONVERSION_TYPES



Navigation:
Setup > Currencies > Rates > Daily
If conversion type is defined , then check conversion rate is defined.
This is related to CURRENCY_CODE,USER_CURRENCY_CONVERSION_TYPE,CURRENCY_CONVERSION_DATE of errored record
If not defined then defined conversion rate for that date for given currency code.

SQL Table:
GL_DAILY_RATES





















After defining types and rate, you can for importing those error rows of gl_interface, definately those will get imported without any problem.

3 comments: