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:

Symptoms

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.

Changes

 N/A

Cause

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