The UPG_SPL Process Fails at Step UPG_SPL.SPLA01.SPLA with Error "Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). (SQLSTATE 37000) 217" when Upgrading to Release 9.2

(Doc ID 2064456.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Supply Planning - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When upgrading to release 9.2, the Data Conversion Upgrade process UPG_SPL fails at Step UPG_SPL.SPLA01.SPLA005 with the following error:

Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). (SQLSTATE 37000) 217. Failed SQL stmt: UPDATE PS_PL_PROBINST SET PL_SOLVER_INT1 = 3 WHERE PL_SOLVER_INT1 = 0"


The error most notably occurs for customers NOT using Supply Planning.

Changes

 

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