My Oracle Support Banner

FUNCLIB_PV.PV_GET_REQ_MNGR.FieldFormula - Function SetRequisitionStatus does not return a result Error When Searching for Requisitions in Request State Complete or Blank (Doc ID 2673172.1)

Last updated on FEBRUARY 27, 2023

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When searching on Requisitions in My Requisitions Fluid Tile (Request State = Complete or Blank), the following error occurs:

Steps to Reproduce the Issue:

  1. Create a Requisition with more than one line in eProcurement and source it to a Purchase Order (PO).
  2. Edit the Requisition and cancel one line.
  3. Close the PO and Requisition.
  4. In My Requisitions Tile do a search for Requisitions by filtering on Request State=Complete or Blank. The above error occurs.

The error does not occur when Search Engine / Elastic Search is enabled in ePro Installation Options.




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.