EAR 9.2 ABENDED at Step AR_PGG_SERV.ARPARPST.Step03 (SQL) -- RC = 805 When Direct Debit is Cancelled. (Doc ID 1902889.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ENVIRONMENT
-------------------------
9.2 image 4

Statement of Issue
-----------------------------------
EAR 9.2 ABENDED at Step AR_PGG_SERV.ARPARPST.Step03 (SQL) -- RC = 805 When Direct Debit is Cancelled.

Business Impact
---------------------------------------
Unable to continue Receivables Update

Error Message
-----------
-- 22.19.15 Process 20176 ABENDED at Step AR_PGG_SERV.ARPARPST.Step03 (Action SQL) -- RC = 805
ROLLBACK
/
-- 22.19.15 SQL Error: ORA-00001: unique constraint (EMDBO.PS_PG_ITMDST_TAO4) violated


Steps to Replicate
----------------------------
1) Navigate to the Cancel Direct Debits page then search for the DD ID to cancel.
2) Check the Cancel box then enter the Reason and Accounting Date then hit Save.
3) Run ARUPDATE

Cause

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