My Oracle Support Banner

EGL: Excel to Component Interface Does Not Validate Rate Type When Loading Market Rate (Doc ID 2083793.1)

Last updated on MARCH 16, 2023

Applies to:

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

Symptoms


When importing rate information using Excel to CI, if including a Rate type (RT_TYPE) that does not exist, system allows the Rate type entry to be loaded into PS_RT_RATE_TBL.
ExceltoCI should give an error message, the row should not 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 information

Changes

 

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