EAP: Voucher Build deadlock issue at Step AP_VB_STGVCH.STGDEL.Step02
Last updated on JUNE 28, 2018
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Two Voucher Build processes are running in parallel, where each is processing different Business Units.
As a result, there is a deadlock at Step AP_VB_STGVCH.STGDEL.Step02.
The SQL does not include a PROCESS_INSTANCE value so the two Voucher Build processes will attempt to delete all rows which have Voucher header rows, regardless of which of the parallel processes delete the VCHR_HDR_STG rows.
-- 13:56:25.127 .....(AP_VB_STGVCH.STGDEL.Step02) (SQL)
DELETE FROM PS_VCHR_LINE_STG WHERE NOT EXISTS ( SELECT 'X' FROM
PS_VCHR_HDR_STG HDR WHERE HDR.BUSINESS_UNIT = PS_VCHR_LINE_STG.BUSINESS_UNIT
AND HDR.VCHR_BLD_KEY_C1 = PS_VCHR_LINE_STG.VCHR_BLD_KEY_C1 AND
HDR.VCHR_BLD_KEY_C2 = PS_VCHR_LINE_STG.VCHR_BLD_KEY_C2 AND
HDR.VCHR_BLD_KEY_N1 = PS_VCHR_LINE_STG.VCHR_BLD_KEY_N1 AND
HDR.VCHR_BLD_KEY_N2 = PS_VCHR_LINE_STG.VCHR_BLD_KEY_N2 AND HDR.VOUCHER_ID =
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