Error "SQL.Fetch: object isn't open on a select. (2,288)" when Saving and Submitting a Requisition and Using Automatic Sourcing
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:
Called from:SP.SP_INTEGRATION.SPRO_EPRO.OnExecute Name:UpdateStatus
Called from:FUNCLIB_PP.REQ_STATUS.FieldFormula Name:SetsProReqStatus
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