Category Search PeopleCode Error Position 1292 Return:936 -ORA-00936-Missing Expression In View Events And Search Bids

(Doc ID 2281365.1)

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

  1. Click on “Advanced Search Criteria” hyperlink.
  2. Enter a value from category prompt and click on Search.
  3. Click on “Add Additional Category” push button and keep the field blank.
  4. 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