EEX9.1/9.2: EX_TRANS_PRCS Fails At Step EX_CANCL_PMT.ENDRUN.UPDCANDT

(Doc ID 1623641.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

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

Symptoms

When two Expense reports are staged for payment on same date then it happens after being paid, a cancel for the payment occurs for each Expense report in different date then the cancel payment process (EX_TRAN_PRCS) fails.

Steps

a) Create and approve two expense reports (for different employees)
b) Stage the payment and run the Paycycle for both of them
c) Check the two Payments created.
d) In AP , cancel the two payments in two different dates.
e) Run the Cancel Payment process from Expenses.
f) Process will fail with this error message :

Error message :

EX_TRANS_PRCS Fails At Step EX_CANCL_PMT.ENDRUN.UPDCANDT

ORA-01427: single-row subquery returns more than one row Failed SQL stmt: UPDATE PS_EX_SHEET_PYMNT SET
accounting_dt = ( SELECT DISTINCT accounting_dt FROM P S_EX_SHEET_PYMNT WHERE
PROCESS_INSTANCE = 17631 AND pymnt_selct_status = 'X') WHERE PROCESS_INSTANCE
= 17631 AND pymnt_selct_status = 'N'

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