EAP: Voucher Build performance issue at Step AP_VB_BLDCD.C3100.Step01

(Doc ID 1561206.1)

Last updated on MAY 24, 2017

Applies to:

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

Symptoms

Customer loads invoices into the QV tables.  Runs Voucher Build to process 'ERRORS/STAGED' Vouchers. 

Voucher Build is having a performance issue at Step AP_VB_BLDCD.C3100.Step01

-- 15.11.32 .......(AP_VB_BLDCD.C3100.Step01) (SQL)
INSERT INTO PS_VCHR_BLD_LTMP4 ( PROCESS_INSTANCE , BUSINESS_UNIT , VOUCHER_ID , VOUCHER_LINE_NUM , BUSINESS_UNIT_RECV , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , BUSINESS_UNIT_PO , PO_ID , LINE_NBR , SCHED_NBR , VCHR_BLD_PORCV_IND ) SELECT LINE.PROCESS_INSTANCE , LINE.BUSINESS_UNIT , LINE.VOUCHER_ID , LINE.VOUCHER_LINE_NUM , ' ' , ' ' , 0 , 0 , PSHP.BUSINESS_UNIT , PSHP.PO_ID , PSHP.LINE_NBR , PSHP.SCHED_NBR , 'P' FROM PS_VCHR_HDR_TMP4 HDR , PS_VCHR_LINE_TMP4 LINE , PS_PO_HDR PHDR , PS_VCHR_BLD_POS_VW PSHP WHERE HDR.PROCESS_INSTANCE = 9384831  AND
HDR.VCHR_BLD_CODE = ' '  AND HDR.PROCESS_INSTANCE = LINE.PROCESS_INSTANCE AND HDR.BUSINESS_UNIT = LINE.BUSINESS_UNIT AND HDR.VOUCHER_ID = LINE.VOUCHER_ID AND PHDR.BUSINESS_UNIT = PSHP.BUSINESS_UNIT AND PHDR.PO_ID = PSHP.PO_ID AND (( HDR.VENDOR_SETID = PHDR.VENDOR_SETID AND HDR.VENDOR_ID = PHDR.VENDOR_ID AND HDR.VENDOR_ID <> ' ') OR (HDR.VENDOR_ID = ' ')) AND LINE.RECEIVER_ID = ' ' AND LINE.VCHR_BLD_MATCH_FLG = 'N'  AND LINE.BUSINESS_UNIT_PO = PSHP.BUSINESS_UNIT AND LINE.SCHED_NBR = 0   AND (LINE.PO_ID = ' ' OR LINE.PO_ID = PSHP.PO_ID) AND (LINE.LINE_NBR = 0 OR LINE.LINE_NBR = PSHP.LINE_NBR)  AND LINE.ITM_SETID = PSHP.ITM_SETID AND LINE.INV_ITEM_ID = PSHP.INV_ITEM_ID AND LINE.QTY_VCHR = PSHP.QTY_PO   AND (LINE.UNIT_OF_MEASURE
= PSHP.UNIT_OF_MEASURE OR LINE.UNIT_OF_MEASURE = ' ') AND NOT EXISTS ( SELECT 'X' FROM PS_VCHR_BLD_LFNL4 LFNL WHERE PROCESS_INSTANCE = 9384831 AND PSHP.BUSINESS_UNIT = LFNL.BUSINESS_UNIT_PO AND PSHP.PO_ID = LFNL.PO_ID AND PSHP.LINE_NBR = LFNL.LINE_NBR AND PSHP.SCHED_NBR = LFNL.SCHED_NBR)
/
-- Row(s) affected: 0

-- 15.45.25

STEPS
In order to get that particular section of the Application Engine to execute:

1. Create a PO
2. Dispatch the PO
3. Create a Quick Invoice referencing the Purchase Order
   a. Delete the Distribution Lines
4. Create another Quick Invoice with no PO Reference and no Voucher Line information
5. Run Voucher Build for these two Vouchers
6. Above error will occur

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