Hello,
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
Best answer by Manoj Ruwanhewa
Hi
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
+15Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
