EGL: FS_ALLC Fails With Divide By Zero Error (Doc ID 2053744.1)

Last updated on SEPTEMBER 14, 2016

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

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