EEX9.1/9.2: EX_TRANS_PRCS Fails At Step EX_CANCL_PMT.ENDRUN.UPDCANDT
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.
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms