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

Last updated on SEPTEMBER 14, 2016

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms