EGL: Maket Rate Load SQL Exec Error MARKET_RATE_LOAD Market_rate_load.onexecute

(Doc ID 1930911.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Market rate Load SQL exec MARKET_RATE_LOAD Market_rate_load.onexecute

ERROR
-----------------------
Process errored on Peoplecode onNOTIFY PCPC 8607 statement 75.

PSSUBHND_dflt.17905 (153) [2014-04-30T09:37:25.008 SubConProcess](0) SQL error. Function: SQLExec
 Error Position: 0
 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_RT_RATE_DEF_TBL"."RT_RATE_ADM_MAXVAR")
 Statement: INSERT INTO PS_RT_RATE_DEF_TBL (RT_RATE_INDEX, TERM, FROM_CUR, TO_CUR, MAX_VARIANCE, ERROR_TYPE, INT_BASIS) VALUES (:1, :2, :3, :4, 2.5, 'WAR', ' ')



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
The error happens in Integration Broker message <> when you run the market rate load from Main menu > Peopletools > Integration Broker > File Uitlities >Inbound File Processing


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