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 18.104.22.168 and later
Information in this document applies to any platform.
***Checked for relevance on 14-JUNE-2013***
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document