EAP: Withholding Voucher/Supplier Mismatch abends at Step WTHD_MISMTCH.MAIN.Step03 with VENDOR_SETID - Invalid Identifier
Last updated on FEBRUARY 23, 2018
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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 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)
1. Run Report > Suppliers > 1099/Global Withholding > General Reports > Wthd Voucher/Supplier Mismatch
2. Populate the Supplier SetID
3. Above error occurs
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