My Oracle Support Banner

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

Last updated on MAY 16, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.

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. 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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