Error "SQL.Fetch: object isn't open on a select. (2,288)" when Saving and Submitting a Requisition and Using Automatic Sourcing

(Doc ID 1961641.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

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


The below error is issued when saving and submitting a Requisition (navigation: Services Procurement, Create Requisition) and using Automatic Sourcing:

SQL.Fetch: object isn't open on a select. (2,288) FUNCLIB_SPF.SP_REQ_STATUS.FieldFormula  Name:SproEproReqStatus
Called from:SP.SP_INTEGRATION.SPRO_EPRO.OnExecute  Name:UpdateStatus
Called from:FUNCLIB_PP.REQ_STATUS.FieldFormula  Name:SetsProReqStatus
Called from:PV_REQ_WRK.PV_SAVE_AND_SUBMIT.SavePostChange

The issue is not Workflow related as the issue also occurs when no approval is required for the Requisition.


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