Daily Rates Import Output File Doesn't Show Information For Latest Run (Doc ID 1420198.1)

Last updated on AUGUST 25, 2016

Applies to:

Oracle Fusion General Ledger - Version 11.1.8.0.0 and later
Oracle Fusion General Ledger Cloud Service - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

While importing the daily rates using the "Import and Calculate Daily Rates" ESS program the output file for the process shows rows with error, for instance error code VF02 (The date range between Date and the To Date cannot exceed 366 days), even though the daily rate rows were loaded successfully by the batch process.
The error shown in the output file is for a previous unsuccessful run of the program.
An example of what is displayed in the output file is:

 Daily Rates Import Exception Report                   Page 1
=========== GL_DAILY_RATES_INTERFACE Table Invalid Rows ==========

Rate Type From Date To Date From Currency To Currency Rate Inverse Rate Error Code
------------------------------ -------------- -------------- --------------- ---------------
Corporate 1951-01-01 4712-12-31 GBP USD 1.5 .666667 VF02

The expected result is the output file to indicate successful upload of rows.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms