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 APRIL 02, 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.