"Program - Daily Rates Import and Calculation" (GLDRICCP) not processing any records if any duplication exist in GL_DAILY_RATES_INTERFACE table
Last updated on AUGUST 19, 2016
Applies to:Oracle General Ledger - Version 22.214.171.124 and later
Information in this document applies to any platform.
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.
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