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 AUGUST 04, 2016

Applies to:

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

Symptoms

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.

Cause

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