"Program - Daily Rates Import and Calculation" (GLDRICCP) not processing any records if any duplication exist in GL_DAILY_RATES_INTERFACE table (Doc ID 1928650.1)

Last updated on AUGUST 19, 2016

Applies to:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Issue can be reproduced at will with following steps.

1. Load Daily Rates data into GL_DAILY_RATES_INTERFACE table.

2. Load a duplicate record for one of the already existing records

3. Submit concurrent program "Program - Daily Rates Import and Calculation"

 

The issue can be verified by querying GL_DAILY_RATES_INTERFACE table, where in duplicate as well as the non-duplicate records end in error and are not processed.

 

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