Category Search PeopleCode Error Position 1292 Return:936 -ORA-00936-Missing Expression In View Events And Search Bids
Last updated on JULY 02, 2017
Applies to:PeopleSoft Enterprise SCM Strategic Sourcing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On : 9.2 version, Bid Responses in Supplier Portal
When attempting to click on Search button from View Events and Place Bids page, the following error occurs.
Error Position 1292 Return:936 -ORA-00936-Missing Expression
Steps To Replicate
Navigate to View Events and Search Bids in SUPPLIER portal. Main menu >> Manage events >> View events & place bids
- Click on “Advanced Search Criteria” hyperlink.
- Enter a value from category prompt and click on Search.
- Click on “Add Additional Category” push button and keep the field blank.
- Click on Search. There is a SQL error.
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