OBIA 11.1.1.7.1 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 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

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.
  FROM APPS.GL_DAILY_RATES GL_DAILY_RATES
  WHERE (1 = 1)
  AND (GL_DAILY_RATES.CONVERSION_DATE > SYSDATE - #BIAPPS.XRATE_UPD_NUM_DAY

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.

Cause

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