EAR 9.2:ARUPDATE Abends at Step AR_PGG_SERV.ARPARPST.STEP03
Last updated on SEPTEMBER 13, 2016
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On 9.2 version, when attempting to run ARUPDATE, the following error occurs.
-- 15:29:46.987 Process ABENDED at Step AR_PGG_SERV.ARPARPST.Step03 (Action SQL) -- RC = 805
-- 15:29:47.010 SQL Error: ORA-00001: unique constraint (SYSADM.PS_PG_ITMDST_TAO4) violated
The issue can be reproduced at will with the following steps:
- Navigate to the Cancel Direct Debits page then search for the DD ID (Direct Debit ID) to cancel.
- Check the Cancel box then enter the Reason and Accounting Date then hit Save.
- Run ARUPDATE
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