ORA-01086: Savepoint 'string' Never Established In This Session... When Using Pa_project_pub

(Doc ID 1529683.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Foundation - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 25-AUG-2014***

Symptoms

Using pa_project_pub.update_project API, when profile "PA:Process Structure Updates" is STANDARD
  Getting error: ORA-01086: savepoint 'string' never established in this session
  
  
  When the profile "PA:Process Structure Updates" = ONLINE
  
  Then running the API is giving:
  SQLCODE = "-1086"
  SQLERRM = "ORA-01086: savepoint 'UPDATE_PROJECT_PUB' never established in
  this session or is invalid
  ORA-06510: PL/SQL: unhandled user-defined exception"
  ln_msg_count is null

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