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 APRIL 16, 2021
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 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.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |