Please validate the data and populate in to GL_DAILY_RATES_INTERFACE table.
After inserting the validate records, Please run the standard program.
Program - Daily Rates Import and Calculation
INSERT INTO GL_DAILY_RATES_INTERFACE
(
FROM_CURRENCY
,TO_CURRENCY
,FROM_CONVERSION_DATE
,TO_CONVERSION_DATE
,USER_CONVERSION_TYPE
,CONVERSION_RATE
,MODE_FLAG
,USER_ID
)
VALUES
(CREC.FROM_CURRENCY
,CREC.TO_CURRENCY
,CREC.FROM_CONVERSION_DATE
,CREC.TO_CONVERSION_DATE
,L_USER_CONVERSION_TYPE
,CREC.CONVERSION_RATE
,'I'
,FND_PROFILE.VALUE('USER_ID')
);
After inserting the validate records, Please run the standard program.
Program - Daily Rates Import and Calculation
INSERT INTO GL_DAILY_RATES_INTERFACE
(
FROM_CURRENCY
,TO_CURRENCY
,FROM_CONVERSION_DATE
,TO_CONVERSION_DATE
,USER_CONVERSION_TYPE
,CONVERSION_RATE
,MODE_FLAG
,USER_ID
)
VALUES
(CREC.FROM_CURRENCY
,CREC.TO_CURRENCY
,CREC.FROM_CONVERSION_DATE
,CREC.TO_CONVERSION_DATE
,L_USER_CONVERSION_TYPE
,CREC.CONVERSION_RATE
,'I'
,FND_PROFILE.VALUE('USER_ID')
);