EGL: Excel to Component Interface Does Not Validate Rate Type When Loading Market Rate.

(Doc ID 2083793.1)

Last updated on JULY 12, 2017

Applies to:

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


On : 9.2 version, Functionality

MARKET Rates Component interface Rate Type invalid

When the customer imports information using Excel to CI, they are including a Rate type (RT_TYPE) that does not exist. The entry allows the Rate type to be loaded into PS_RT_RATE_TBL.

When the customer imports new rates using Excel to CI they are including a Rate type (RT_TYPE) that does not exist. Next the ExceltoCI should give an error message, the row cannot be loaded because the Rate type is not valid.

The issue can be reproduced at will with the following steps:
1) Load the MARKET RATES component interface to ExceltoCI2007.
2) Fill in the data input Template including and action type as create
3) Put a RT_TYPE that does not exist
4) Load new Rate info

The issue has the following business impact:
Users are Creating bad/False Rate Types during the Excel to IC Market rate Upload


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