EEX9.1+: EX_TRAN_PRCS Process ABENDED At Step EX_STAGE_PMT.PAYMENTS.EMPADVNC (Doc ID 2041579.1)

Last updated on NOVEMBER 23, 2015

Applies to:

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

Symptoms

EX_TRAN_PRCS process ABENDED at Step EX_STAGE_PMT.PAYMENTS.EMPADVNC

Steps:
--------
The issue can be reproduced at will with the following steps:
1. Log in as a user.
2. Submit a cash Advance and get it approved.
3. Run the Stage Payment and Post Liabilities process.
4. Pay the cash Advance using Paycycle.
5. Run Post payment process.
6. Cancel the Payment with Void/Re-issue option
7. Run Cancel Payment process.
8. Set the Hold Payment option in Employee-Profile-Bank details page.
9. Run the stage Payment process
  - This will bring the Cash Advance status from "Staged" to "Approved for Payment"
10. Remove Hold Payment option in Employee-Profile-Bank details page.
11. Run the Stage Payment process


ERROR
-----------------------
Process 4295085 ABENDED at Step EX_STAGE_PMT.PAYMENTS.EMPADVNC (Action SQL) -- RC = 805
ROLLBACK
/
SQL Error: ORA-00001: unique constraint (SYSADM.PS_EX_ADVNCE_PYMNT) violated


Please see the Replication Steps document for more details related to complete configuration and the replication steps necessary to reproduce the issue.

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