Resubmitting Documents Error: Calling stored procedure sdbp_routing.to_pending ORA-06503: PL/SQL: function returned without value (Doc ID 1158217.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.8.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 14-JUNE-2013***

Symptoms

When resubmitting documents for approval, if the combination of the document description and resubmit reason is over 355 characters, the following error is displayed and the document is not resubmitted:

Error: Calling stored procedure sdbp_routing.to_pending
ORA-06503: PL/SQL: function returned without value
ORA-06512: at “SYNERGEN.SDBP_SEND_ALERT”,line 244
ORA-06512 : at “SYNERGEN.SDBP_ROUTING”


Please NOTE that line breaks are also counted in the total number of characters. So even if the actual number of characters does not exceed 355, line breaks can cause the number to go over 355

Please also Note that the error occurs in all modules where documents can be resubmitted

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