AP: Payment Inquiry SQL Error
Last updated on FEBRUARY 13, 2018
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.1 and later
Information in this document applies to any platform.
When users search for payment on Payment Inquiry screen, or try to go to Payment through payment ID link on Voucher Document Status, they receive a SQL error. This appears to have started with the recent patches. The Sql is looking for OPRID in PS_SP_PYCYCL_NONVW, which is not a field in that record.
Error in Peoplecode ScrollSelect processing (2,213)
Main Menu > Accounts Payable > Review Accounts Payable Information >Payments > Payment Inquiry
- search for payment on any field, returns error
Main Menu > Accounts Payable > Review Accounts Payable Information >Vouchers> Document Status
- search for a voucher
- click payment ID for the voucher
- returns SQL error on redirect
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