Savepoint START_USER_SQL never established

  • KM03645506
  • 28-May-2020
  • 28-May-2020

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

Workflow execution step calling custom function is failing with an error.

Error

nested detail:DB Package error:

ORA-01086: savepoint 'START_USER_SQL' never established in this session or is invalid

ORA-06512: at "PPM.KWFL_EXECUTION", line 3760

ORA-06503: PL/SQL: Function returned without value {KWFL_EXECUTION-5030} (KNTA-10498)

Cause

This usually happens if custom PL/SQL function is called in workflow execution step and that custom function has a commit statement inside of it.

Fix

Try removing the commit statement from the custom function and check if it will work.