Error "SQL object is not open, or is a open on a select. (2,295)" in SCM_IN_FULFILL_COMMON.LockSQL.OnExecute when Running an Inventory Fulfillment Application Engine Process

(Doc ID 1303242.1)

Last updated on JANUARY 09, 2018

Applies to:

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


You are experiencing intermittent failures with Inventory Fulfillment Application Engine processes when the following PeopleCode is called: SCM_IN_FULFILL_COMMON.LockSQL:

SQL.Execute: SQL object is not open, or is a open on a select. (2,295) SCM_IN_FULFILL_COMMON.LockSQL.OnExecute Name:Execute

The failed Process Instance can be restarted and runs to completion.


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