My Oracle Support Banner

EAP-Voucher Build - Abends At Step AP_VCHRBLD.VCHIDGT2.Step02 (Action Do Select) (Doc ID 2409285.1)

Last updated on JUNE 08, 2018

Applies to:

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

Symptoms

For option 'Voucher Build Interfaces', 'All Interfaces" is selected. The
process ends with "No Success"

-- 03.15.29 ......(AP_VCHRBLD.VCHIDGT2.Step02) (Do Select)
%Select( business_unit, voucher_id, VCHR_BLD_KEY_C1, VCHR_BLD_KEY_C2,
TRANS_DATE, VCHR_BLD_KEY_N1, VCHR_BLD_KEY_N2, business_unit_po, po_id,
business_unit_recv, receiver_id, voucher_id_related, ectransid,
rtv_id,packslip_no, invoice_id, cntrct_setid,release_type, vchr_src,
nf_brl_line_num) SELECT BUSINESS_UNIT , ' ' , VCHR_BLD_KEY_C1 ,
VCHR_BLD_KEY_C2 , TO_CHAR(SYSDATE,'YYYY-MM-DD') , VCHR_BLD_KEY_N1 ,
VCHR_BLD_KEY_N2 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' ,
' ' , VCHR_SRC FROM PS_VCHR_HDR_STG WHERE BUSINESS_UNIT = 'BRA02' AND
PROCESS_INSTANCE = 2733577 AND VOUCHER_ID IN ('NEXT',' ') AND VCHR_SRC <>
'AMLS' AND NOT EXISTS ( SELECT 'X' FROM PS_VCHR_BLD_HVID4 WHERE
PROCESS_INSTANCE = PS_VCHR_HDR_STG.PROCESS_INSTANCE AND BUSINESS_UNIT =
PS_VCHR_HDR_STG.BUSINESS_UNIT AND VCHR_BLD_KEY_C1 =
PS_VCHR_HDR_STG.VCHR_BLD_KEY_C1 AND VCHR_BLD_KEY_C2 =
PS_VCHR_HDR_STG.VCHR_BLD_KEY_C2 AND VCHR_BLD_KEY_N1 =
PS_VCHR_HDR_STG.VCHR_BLD_KEY_N1 AND VCHR_BLD_KEY_N2 =
PS_VCHR_HDR_STG.VCHR_BLD_KEY_N2) AND NOT EXISTS ( SELECT 'X' FROM
PS_VCHR_BLD_MXID4 MXID WHERE MXID.PROCESS_INSTANCE = 2733577 AND
MXID.BUSINESS_UNIT = PS_VCHR_HDR_STG.BUSINESS_UNIT) ORDER BY BUSINESS_UNIT,
VCHR_BLD_KEY_C1, VCHR_BLD_KEY_C2, VCHR_BLD_KEY_N1, VCHR_BLD_KEY_N2
/
-- 03.15.30 Process 2733577 ABENDED at Step AP_VCHRBLD.VCHIDGT2.Step02
(Action Do Select) -- RC = ?
ROLLBACK
/
-- 03.15.30 SQL Error: Invalid SELECT item number

REPLICATION STEPS
=================
Accounts Payable > Batch Processes > Vouchers > Voucher Build
For option 'Voucher Build Interfaces', select 'All Interfaces"



Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.