EAR 9.1+: Payment Predictor Fails At Step AR_PREDICT2.ADJUST.ADJ_OVE2 (SQL) When Payment Has Item References With More Than One Line (Doc ID 2005058.1)

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.

Symptoms

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.

ERROR
-----------------------

-- 11.17.26 Process 1059836 ABENDED at Step AR_PREDICT2.ADJUST.ADJ_OVE2 (Action SQL) -- RC = 805
ROLLBACK
/
-- 11.17.26 SQL Error: ORA-00001: unique constraint (SYSADM.PS_PP_ITEM2A_TAO5) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Create a payment and add around 10 detail item references for the payment. Make sure items have multiple lines.
  2. Run Payment Predictor

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