My Oracle Support Banner

EGL: Allocations Process Abends At FS_ALLC_OUTJ.uRtMult.ReCalc If Calculated RATE_MULT Number Has 9 Digits To The Left Of Decimal Point (Doc ID 1994358.1)

Last updated on DECEMBER 08, 2018

Applies to:

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

Symptoms

Issue:
------
When attempting to run allocation, the program crashes in FS_ALLC_OUTJ.uRtMult.ReCalc when trying to calculate the RATE_MULT column for a journal line. It is traced it down to a specific journal line being generated that has a large difference between the MONETARY_AMOUNT and the FOREIGN_AMOUNT, resulting in a RATE_MULT number that is 9 digits to the left of the decimal. The RATE_MULT field is only formatted as 7.8 so the program crashes with the following error:

Error:
------
-- 17.39.57 .................(FS_ALLC_OUTJ.uRtMult.ReCalc) (SQL)
UPDATE PS_JRNL_LN SET RATE_MULT ...
/
-- Row(s) affected: 0
-- 17.39.57 Process 1019175 ABENDED at Step FS_ALLC_OUTJ.uRtMult.ReCalc (Action SQL) -- RC = 8601
ROLLBACK
/
-- 17.39.57 SQL Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting numeric to data type numeric.
[Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated. (SQLSTATE 01000) 3621

Steps to Replicate:
---------------------

Setup and run allocation. Allocation should create a journal which has at least 1 line having huge difference in monetary and foreign amount.

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