My Oracle Support Banner

EAR9.2: AR_PGG1 Process Failed With Unique Constraint (SYSADM.PS_PG_PENDST_TAO5) Violated At Step AR_PGG_SERV.PAY_CASH.SYSCASHP (Action SQL) -- RC = 805 In ARUPDATE For Item With 5000 AR Distribution Lines (Doc ID 2555022.1)

Last updated on NOVEMBER 08, 2019

Applies to:

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

Symptoms


When attempting to run arupdate in PUM 28, the following error occurs when item has more than 5000 AR distribution lines.

ERROR
-----------------------
AR_PGG1 process failed with unique constraint (SYSADM.PS_PG_PENDST_TAO5) violated during ARUPDATE run

Process 16358562 ABENDED at Step AR_PGG_SERV.PAY_CASH.SYSCASHP (Action SQL) -- RC = 805
ROLLBACK

10:16:04.279 SQL Error: ORA-00001: unique constraint (SYSADM.PS_PG_PENDST_TAO5) violated.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an item with more than 5000 AR distribution lines.
2. Run arupdate.


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.