GLDRICCP: 'Daily Rates Import and Calculation' Program Is Not Updating GL_DAILY_RATES_INTERFACE.MODE_FLAG /ERROR_CODE Fields After Error: 'Duplicate Row or Overlapping Date Range found' Occurs (Doc ID 2941947.1)

Last updated on APRIL 19, 2023

Applies to:

Symptoms

GLDRICCP: "Program - Daily Rates Import and Calculation" is throwing an error as- Error: Duplicate Row or Overlapping Date Range found.
However, the MODE_FLAG and ERROR_CODE columns are not updating properly in GL_DAILY_RATES_INTERFACE table.

Steps to reproduce the issue

Step#1

Enter following data into the GL_DAILY_RATES_INTERFACE table:

-----------------------------------------------------------
Sample Entry 1
-----------------------------------------------------------
FROM_CURRENCY: ABC
TO_CURRENCY: XYZ
FROM_DATE: 7/1/2023
TO_DATE: 7/1/2023
RATE: 2

-----------------------------------------------------------
Sample Entry 2
-----------------------------------------------------------
FROM_CURRENCY: ABC
TO_CURRENCY: XYZ
FROM_DATE: 7/1/2023
TO_DATE: 7/1/2023
RATE: 2

Step#2

Responsibility: General Ledger
Run Concurrent Program from the Submit Request form: Program - Daily Rates Import and Calculation (GLDRICCP) 

Step#3

Review GLDRICCP program log as: 

Review database table GL_DAILY_RATES_INTERFACE:

Fields MODE_FLAG  and ERROR_CODE is not updated with correct data. 

Cause

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