EGL9.1: SQL Error Number ORA-01438: Value Larger Than S Occurred When Attempting To Run The Cross/Reciprocal Rate Calc Process (EO9030 SQR) (Doc ID 1670662.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.

Symptoms

On : 9.1 version, Multi-currency

When attempting to run the Cross/Reciprocal Rate Calc process (EO9030 SQR), the following error occurs.

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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Market Rate Type = DAILY.
  2. 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.
  3. 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.
  4. 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.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the Cross/Reciprocal Rate Calc process.

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