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