EGL9.1+: Allocations Process Abends At FS_ALLC_OUTJ.uRtMult.ReCalc When Trying To Calculate The RATE_MULT Column For A Journal Line. (Doc ID 1994358.1)

Last updated on MARCH 14, 2017

Applies to:

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

Symptoms

On : 9.2 version, Allocations

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
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup and run allocation. Allocation should create a journal which has huge difference in monetary and foreign amount.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Cannot use allocation process to allocate funds.

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