My Oracle Support Banner

EAR9.1 Payment Predictor #DTL_TLR ABEND AT AR_PREDICT2.REAL_CUR.BAL_BASE (Doc ID 2019125.1)

Last updated on FEBRUARY 03, 2019

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 and later
Information in this document applies to any platform.


When attempting to Run Payment Predictor application engine,
the following error occurs:

Process 173639 ABENDED at Step AR_PREDICT2.REAL_CUR.BAL_BASE (Action SQL) -- RC = 1476
-- 16.00.25 SQL Error: ORA-01476: divisor is equal to zero

The issue can be reproduced at will with the following steps:
- Setup Payment Predictor to use #DTL_TLR
- Enter an EUR item on an USD business unit, having the exchange rate as X;
- Enter a Detail Reference EUR overpayment against the EUR item, in the same
USD business unit, having the exchange rate as Y;
- Run Payment Predictor;
- The process will abend at step AR_PREDICT2.REAL_CUR.BAL_BASE.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.