AP_VCHRBLD - Deadlock Issue When Voucher Build Is Run In Parallel For Different Business Units

(Doc ID 2396935.1)

Last updated on MAY 09, 2018

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Two Voucher Build processes are run where each are processing one business unit and are run in parallel.

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