AP: Payment Inquiry SQL Error
(Doc ID 2360589.1)
Last updated on FEBRUARY 01, 2019
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document