OBIA Overlapping Records In W_EXCH_RATE_G from SDE_ORA_EXCHANGERATEGENERAL_COMPRESS mapping causes duplicates

(Doc ID 2031739.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


The exchange rates being extracted from Oracle EBS 12.1.3, through the ODI ETL mapping SDE_ORA_EXCHANGERATEGENERAL_COMPRESS, are causing duplicate records to be created.

The issue is related to the snippet of the the EBS query that pulls the GL daily rates. The variable XRATE_UPD_NUM_DAY is currently set at 30.
  WHERE (1 = 1)

If the exchange rates for a given currency pair are the same for consecutive days, the query could cause the same exchange rate for a given exchange date to get created from multiple Start and End Dates.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms