EGL9.2: Allocation(FS_ALLC) 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 FEBRUARY 04, 2019
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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:
-- 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
-- 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.
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