EAP: Voucher Build deadlock issue at Step AP_VB_STGVCH.STGDEL.Step02

(Doc ID 2396935.1)

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.

Symptoms

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 =
PS_VCHR_LINE_STG.VOUCHER_ID)

Changes

 

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