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
PeopleSoft Enterprise SCM Supply Planning - Version 9.2 to 9.2 [Release 9] Information in this document applies to any platform.
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.
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