My Oracle Support Banner

EGL9.1: Cannot Upload New Effective Dated Row Using Component Interface MARKET_RATES and Action CREATE. Gtting 'Row already exists with the specified keys' Error (Doc ID 1386499.1)

Last updated on DECEMBER 20, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.


When attempting to upload new effective dated row using Component Interface MARKET_RATES the following error occurs.

#1 - Row already exists with the specified keys. {MARKET_RATES} (91,49)
#2 - Failed to create the Component Interface.

The issue can be reproduced at will with the following steps:
1. Make sure permission is given (Full Access) in PeopleTools > Security > Permission & Roles > Permission Lists for Component Interface MARKET_RATES.
2. Open ExcelToCI, define Connect Information, make sure Action = CREATE and select Input Cells.
3. Enter values for Market Rate Index, Term, From Currency Code, To Currency Code, Rate Type, Effective Date, Market Rate and Submit Data.
4. Error Row already exists with the specified keys. {MARKET_RATES} (91,49) will pop up
5. Run query on PS_RT_RATE_TBL and effective dated row does not exist yet so user should be able to insert new market rate.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.