EAP: Voucher Mass Maintenance abends at Step APVCHMASSMNT.LoadInit.Step01 (SQL) -- RC = 918 when deleting Voucher (Doc ID 1677789.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

When attempting to delete Vouchers using Mass Maintenance, an error occurs.

ERROR
File: e:\pt85310c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1623 Error Position: 191 Return: 918 - ORA-00918: column ambiguously defined
Failed SQL stmt: INSERT INTO PS_VCL_VCH_TAO4 (PROCESS_INSTANCE, BUSINESS_UNIT, VOUCHER_ID, BUSINESS_UNIT_GL, ACCOUNTING_DT, ERROR_FLAG) SELECT 20616 , TMP.BUSINESS_UNIT, TMP.VOUCHER_ID, TMP.BUSINESS_UNIT_GL, ACCOUNTING_DT, ERROR_FLAG FROM PS_VCHR_MMT_TMP2 TMP, PS_VOUCHER VCHR WHERE RUN_CNTL_ID = 'RTM0000106' AND TMP.BUSINESS_UNIT = VCHR.BUSINESS_UNIT AND TMP.VOUCHER_ID = VCHR.VOUCHER_ID AND VCHR.IN_PROCESS_FLG = 'N'

Process 20616 ABENDED at Step APVCHMASSMNT.LoadInit.Step01 (SQL) -- RC = 918 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 20.31.55 2014-03-13

STEPS
1.  Create 3 different Vouchers
2.  Save the Vouchers
3.  Search for the the Vouchers through Voucher Mass Maintenance
4.  Filter Criteria = Vouchers to be Deleted
5.  Select the Vouchers to be deleted
6.  Click the Delete button
7.  Action = Mass Maintenance
8.  Click Run
9.  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