EAP: Withholding Voucher/Supplier Mismatch abends at Step WTHD_MISMTCH.MAIN.Step03 with VENDOR_SETID - Invalid Identifier (Doc ID 2011093.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 running the Withholding Voucher/Supplier Mismatch report, if a value is entered for the Supplier SetID, process abends at Step WTHD_MISMTCH.MAIN.Step03 with an error.

ERROR
Error Position: 71 Return: 904 - ORA-00904: "VENDOR_SETID": invalid identifier
Failed SQL stmt: DELETE FROM PS_MISMTCH_RPT WHERE 1 = 1 AND BUSINESS_UNIT ='US001' AND VENDOR_SETID = 'US001'

Process 19754 ABENDED at Step WTHD_MISMTCH.MAIN.Step03 (SQL) -- RC = 904 (108,524)

STEPS
1.  Run Report > Suppliers > 1099/Global Withholding > General Reports > Wthd Voucher/Supplier Mismatch
2.  Populate the Supplier SetID
3.  Above error occurs

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