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

摘自：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   Symptoms   Cause   Solution   References   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.