EAR 9.1+: Payment Predictor Fails At Step AR_PREDICT2.ADJUST.ADJ_OVE2 (SQL) When Payment Has Item References With More Than One Line
Last updated on SEPTEMBER 16, 2016
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
Payment Predictor fails when there are item references with multiple lines.
Payment Predictor fails at PP1 step when a payment has an item reference with more than one line. For example, Payment XYZ comes in with item reference ABC123 with line 1 and line 2. The process fails on a SQL which does the min Item ID and since there are more than 2 rows for the same Item, the process fails with unique constraint error.
-- 11.17.26 Process 1059836 ABENDED at Step AR_PREDICT2.ADJUST.ADJ_OVE2 (Action SQL) -- RC = 805
-- 11.17.26 SQL Error: ORA-00001: unique constraint (SYSADM.PS_PP_ITEM2A_TAO5) violated
The issue can be reproduced at will with the following steps:
- Create a payment and add around 10 detail item references for the payment. Make sure items have multiple lines.
- Run Payment Predictor
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms