Daily Rates: APP-FND-01206: This Record Already Exists When Entering New Rate (文档 ID 1414117.1)

kikiwhq

于 2019-03-01 16:59:07 发布

阅读量1.3k

点赞数

分类专栏： FIN GL 文章标签： FIN GL

GL 同时被 2 个专栏收录

14 篇文章

订阅专栏

FIN

9 篇文章

订阅专栏

摘自：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=531328226859367&id=1414117.1&_afrWindowMode=0&_adf.ctrl-state=g7my1suo2_80

Daily Rates: APP-FND-01206: This Record Already Exists When Entering New Rate (文档 ID 1414117.1)

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

APPLIES TO:

Oracle General Ledger - Version 11.5.10.2 and later
Information in this document applies to any platform.
Form:GLXRTDLY.FMB - Daily Rates

SYMPTOMS

When entering a Daily Rate for a From/To currency, type and date that does not already exist, an error is received:
APP-FND-01206: This record already exists. You entered a duplicate value or sequence of values that must be unique for every record.

CAUSE

The inverse of the rate trying to be added already existed.
A query of gl_daily_rates showed that the inverse (CAD to USD) of this rate already existed in the table. So when the new rate for USD to CAD was entered, along with the inverse, the error was received.

Here is a query that can be run to find Daily Rates that do not have an Inverse defined.

SELECT *
FROM gl_daily_rates gdr
WHERE
NOT EXISTS
    (SELECT 1
     FROM gl_daily_rates gdri
     WHERE gdri.from_currency = gdr.to_currency
     AND gdri.to_currency = gdr.from_currency
     AND gdri.conversion_date = gdr.conversion_date
     AND gdri.conversion_type = gdr.conversion_type);

SOLUTION

To implement the solution:

1. Set the profile "Daily RatesWindow: Enforce Inverse Relationship During Entry" to No.

2. Go to the Daily Rates form and enter the row for the daily rate.
Do not enter an Inverse.
Save.

If you normally want to enter Daily Rates with the inverse also, then set the profile back to Yes when you are finished with this fix.