My Oracle Support Banner

EGL: FS_ALLCがゼロ除算エラーで異常終了する (Doc ID 2149468.1)

Last updated on FEBRUARY 04, 2019

適用範囲:

PeopleSoft Enterprise FIN General Ledger - バージョン 9.1 から 9.2 [リリース 9]
この文書の内容はすべてのプラットフォームに適用されます。

現象

バージョン: 9.1、9.2/配賦処理

FS_ALLCを実行時に以下のエラーが発生する。:

-- 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

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.