My Oracle Support Banner

EAR 9.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 OCTOBER 09, 2023

Applies to:

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


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

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

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

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.


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

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