Skip to main content

Hello,

  1. Open Project Deliverables Design window from Aurena.
  2. Go to Components tab.
  3. Select a record and edit it.
  4. Save the changes.

I receive below error when updating a record or saving a new record in the above mentioned window.

(Server Error) savepoint 'ORACLE_SVPT_93' never established in this session or is invalid.

 

Customer is in APP10 UPD10.

Any help would be greatly appreciated.

 

Best regards,

Devni

Hi @Devni Panduwawala ,

As per the oracle community post , when you do insert or update into the associated table for this screen, if there any implicit commit statements in the business logic, it is possible to  avoid reaching a savepoint and oracle will automatically raise this error.

https://community.oracle.com/tech/developers/discussion/4279679/why-a-savepoint-gets-invalid

(check the best answer in this post)

So in your case, please find the connected, table and and the package for page “Project Deliverables” and search for ‘COMMIT’ statements and compare with APP10 UPD10 core file whether  your plsql package has any extra commit statements.

Hope this will assist you to troubleshoot the issue.

Regards

Manoj

Terms & ConditionsCookie settings