My Oracle Support Banner

AP: Payment Inquiry SQL Error (Doc ID 2360589.1)

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




To view full details, 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 a vibrant support community of peers and Oracle experts.