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.
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.
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 |
Cause |
Solution |
References |