My Oracle Support Banner

EGL9.1: Cannot Upload New Effective Dated Row Using Component Interface MARKET_RATES and Action CREATE. (Doc ID 1386499.1)

Last updated on AUGUST 22, 2018

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
****Checked for Relevance on 19-JUN-2013****
****Checked for Relevance on 03-NOV-2014****

Symptoms


On : 9.1 version, Multi-currency

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

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

STEPS
-----------------------
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.

Cause

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
Symptoms
Cause
Solution
References


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