EGL: Allocation Process(FS_ALLC) Fails At Step FS_ALLC_OUTJ.uRtMult.ReCalc With Divide By Zero Error
(Doc ID 2053744.1)
Last updated on APRIL 16, 2021
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.1 & 9.2 version, Allocations
While running the process FS_ALLC, it fails with error:
-- 15:07:31.918 .................(FS_ALLC_OUTJ.uRtMult.ReCalc) (SQL)
UPDATE PS_JRNL_LN SET RATE_MULT = ROUND(((MONETARY_AMOUNT) / (
FOREIGN_AMOUNT)), 8) WHERE JOURNAL_ID = 'SAUDI00001' AND JOURNAL_DATE =
'2015-07-31' AND PROCESS_INSTANCE = 876999 AND UNPOST_SEQ = 0 AND
FOREIGN_AMOUNT <> 0 AND FOREIGN_CURRENCY <> CURRENCY_CD AND ((FOREIGN_AMOUNT
> 0 AND MONETARY_AMOUNT > 0) OR (FOREIGN_AMOUNT < 0 AND MONETARY_AMOUNT < 0))
AND ABS(((MONETARY_AMOUNT) / ( FOREIGN_AMOUNT))) < 10000000
/
-- Row(s) affected: 0
-- 15:07:32.823 Process 876999 ABENDED at Step FS_ALLC_OUTJ.uRtMult.ReCalc
(Action SQL) -- RC = 8601
ROLLBACK
/
-- 15:07:33.176 SQL Error: [Microsoft][SQL Server Native Client 10.0][SQL
Server]Divide by zero error encountered.
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been
terminated. (SQLSTATE 01000) 3621
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 |