GL-Currencies-Rates-Daily:Error:APP-FND-01206: This record already exists－文档 ID 292731.1

转：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=531323713852169&id=292731.1&_afrWindowMode=0&_adf.ctrl-state=g7my1suo2_4

 

GLDRICCP When Uploading Daily Rates in the Enter Daily Rates Window get APP-FND-01206: This record already exists (文档 ID 292731.1)

转到底部

---

APPLIES TO: Oracle General Ledger - Version 11.5.9 to 12.1.3 [Release 11.5.9 to 12.1] Information in this document applies to any platform. Checked the Document relevance 22-Jul-2016  Executable:GLDRICCP - Program - Daily Rates Import and Calculation SYMPTOMS When Uploading Daily Rates in the Daily Rates Window, the following error occurs: Error ------- For release 11i : APP-FND-01206: This record already exists. You entered a duplicate value or sequence of values that must be unique for every record. For Release 12: Error: Duplicate Row or Overlapping Date Range found Steps to reproduce the issue: ------------------------------------- 1. Go to General Ledger Responsibility 2. Go to Setup-->Currencies-->Rates-->Daily and select enter by Date Range. 3. Enter some Conversion Rates CAUSE Records are stuck in the GL_DAILY_RATES_INTERFACE table SOLUTION Please log a service request with support for a datafix. Please provide the output of the following in excel format Select * from GL_DAILY_RATES_INTERFACE; Also upload a screenshot showing a sample of the data in the spreadsheet you are trying to upload.       REFERENCES NOTE:1414117.1 - Daily Rates: APP-FND-01206: This Record Already Exists When Entering New Rate