EGL9.1: SQL Error Number ORA-01438: Value Larger Than S Occurred When Attempting To Run The Cross/Reciprocal Rate Calc Process (EO9030 SQR)
Last updated on JUNE 05, 2018
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.
On : 9.1 version, Multi-currency
When attempting to run the Cross/Reciprocal Rate Calc process (EO9030 SQR), the following error occurs.
SQL Error number ORA-01438: value larger than s occurred. Process request failed.
A fatal SQL error occurred while processing your request. Look up the error code in
your SQL error reference, fix the problem, and try again.
SQL Status = 1438, SQL Error = ORA-01438: value larger than specified precision allowed for this column
Error on line 224: (SQR 3301) Program stopped by user request.
SQR for PeopleSoft: Program Aborting.
The issue can be reproduced at will with the following steps:
- Market Rate Type = DAILY.
- Currency Quotation Method is setup between USD and BHD and also between USD and ZWD (Auto Reciprocate is enabled). Currency Quotation Method is missing between BHD and ZWD.
- Market rate between USD and ZWD for rate type DAILY is 9000000 and market rate between USD and BHD for rate type DAILY is 0.37697000. There is no market rate available between BHD and ZWD.
- Navigate to Set Up Financials/Supply Chain > Common Definitions > Market Rates > Cross/Reciprocal Rate Calc. Market rate Index = MODEL, Term = 0, From Common Currency = USD, Exchange Rate Type = DAILY. Generate Report, Generate Cross Rates and Generate Reciprocal Rate are checked. From Cur = % and To Cur = %. Run EO9030.SQR and process runs to Error.
The issue has the following business impact:
Due to this issue, users cannot run the Cross/Reciprocal Rate Calc process.
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