1. In order to enable the use of Batch Number in the loader, the parameter ‘Batch Number’ under concurrent program name ‘Program - Daily Rates Import and Calculation’ must be Enabled and the Display must be selected (see below).
The batch number field is used as an input parameter for the concurrent request. It allows the user to process the records uploaded by the user who created the records. It prevents the concurrent request from picking up and processing the records uploaded by another user.
2. Oracle does not store GL Daily Rates error codes and description in any table, so it is difficult for the Wizard to bring the error definition back to the sheet. Due to this limitation, we have listed some common error codes and their corresponding definitions in the table below.
|
Code
|
Description
|
|
Nonexistent_Conversion_Type
|
Specified conversion type does not exist in table GL_DAILY_CONVERSION_TYPES.
|
|
Date_Range_Too_Large
|
The number of days between to_conversion_date and from_conversion_date is greater than 367 or one year
|
|
Negative_Conversion_Rate
|
Conversion rate in GL_DAILY_RATES_INTERFACE is negative
|
|
Negative_Inverse_Rate
|
Inverse conversion rate in GL_DAILY_RATES_INTERFACE is negative
|
|
Nonexistent_From_Currency
|
Specified from currency does not exist in table FND_CURRENCIES
|
|
Disabled_From_Currency
|
The currency is disabled in FND_CURRENCIES
|
|
Statistical_From_Currency
|
Statistical currency does not need conversion rate
|
|
Out_Of_Date_From_Currency
|
The active period of the from currency is not included the conversion rate period
|
|
Disabled_To_Currency
|
The currency is disabled or non-active in FND_CURRENCIES
|
|
EMU_From_Currency
|
You cannot define conversion rates for an EMU currency.
|
|
|
|
|
*Below codes are visible in concurrent request output window.
|
|
VF01
|
The Rate Type is invalid.
|
|
VF02
|
The date range between the From Date and To Date should not exceed 366 days.
|
|
VF03
|
The Conversion Rate must be a positive number.
|
|
VF04
|
The Inverse Conversion Rate must be a positive number.
|
|
VF05
|
The From Currency is invalid.
|
|
VF06
|
The From Currency is disabled.
|
|
VF07
|
The From Currency cannot be STAT.
|
|
VF08
|
The From Currency is out-of-date.
|
|
VF09
|
The From Currency cannot be an EMU currency.
|
|
VF10
|
The To Currency is invalid.
|
|
VF11
|
The To Currency is disabled.
|
|
VF12
|
The To Currency cannot be STAT.
|
|
VF13
|
The To Currency is out-of-date.
|
|
VF14
|
The To Currency cannot be an EMU currency.
|
3. Currently, when the user submits a concurrent request, the user is required to manually copy and paste the Batch Number from the sheet. This is a known Excel limitation that prevents the cell to be copied and the cell content to be pasted. Therefore, the user is required to copy the Batch Number from the formula bar.
4. The Concurrent Request can only be submitted manually using the loader. There is no option to submit the request automatically as this is a limitation with the platform the loader is built on.
