Friday 26 July 2013

Error: Duplicate Row or Overlapping Date Range found.

When loading rates using Program - Daily Rates Import and Calculation, it is failing with the
following error.
Error: Duplicate Row or Overlapping Date Range found.


Alternately following script run as APPS should work as well. This trigger is only used for synchronizing exchange rate data with OPM tables. Thus setting trigger status as 'DISABLED' should not cause any issue for customers not using OPM.


ALTER TRIGGER GMF_GL_DAILY_RATES_BIUR_TG DISABLE;

1 comment:

  1. TRUNCATE THE INTERFACE TABLE AND THAT SHOULD WORK

    ReplyDelete