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

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

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

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


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

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