DUPLICATE_VALUE error:

This error happens mostly when you have selected the option of “Advanced”.  The system is trying to update only the Dated Conversion Rate table, and not the Conversion Rate table.

If you are going to use Dated Exchange Rates, our recommendation is to select “Both”.  By doing this, our system will update both Salesforce tables and the previous issue will not appear.