My Oracle Support Banner

EAR 9.2: Payment Predictor Is Receiving Unique Constraint Error AR_PREDICT2.PGEN.GENITEM0 (Doc ID 2517543.1)

Last updated on MARCH 09, 2020

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 PI 25
PT: 8.56
Payment Predictor

The Payment Predictor process is generating a unique constraint error when a user checks the "Payment Predictor" checkbox, but leaves the "Reference" field blank on the Payments tab of the Regular Deposit page. It happens when each Entry Reason in the Automatic Entry Type page has a unique AR Distribution Code.


ERROR
-----------------------
Process ABENDED at Step AR_PREDICT2.PGEN.GENITEM0
Stmt #: 800 Error Position: 0 Return: 8 05 - ORA-00001: unique constraint (SYSADM.PS_PENDING_ITEM) violated

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter a payment/deposit
2. Check Payment Predictor box
3. Leave Reference field blank
4. Run Payment Predictor



Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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