My Oracle Support Banner

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 FEBRUARY 04, 2019

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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.