Data Conversion Currency Rates Failing During Load (Doc ID 2794668.1)

Last updated on JANUARY 10, 2024

Applies to:

Symptoms

Currency rates failing during load .

When loading 10K Currency Dates 9K has failed with error.
Exported the Failed data and tried to load the failed data without any manipulation, more 700 records have been inserted and the remain has failed.


ERROR
-----------------------
"A currency may not exist without active exchange rates. Add a consolidation and operational exchange rate with an effective date equal or prior to today's date for the currency"


Steps to reproduce:

1. 1. Load 10K Currency Dates in DC. 9K has failed with error.
   2. Exported the Failed data (9k), and load again
   3. 700 records have been inserted and the remain has failed, same error on both cases: "A currency may not exist without active exchange rates. Add a consolidation and operational exchange rate with an effective date equal or prior to todays date for the currency"

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.