Adding Service Item to Quote Error: "oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during Rollback to Savepoint"
Last updated on AUGUST 22, 2017
Applies to:Oracle Quoting - Version 12.1.3 and later
Information in this document applies to any platform.
HTML User Interface
When attempting to add a regular product and a Service Item to a quote the following error occurs.
oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Rollback to Savepoint": SQL Statement "null".
## Detail 0 ##
java.sql.SQLException: ORA-01086: savepoint 'BO_SP' never established in this session or is invalid
Steps to Reproduce
The issue can be reproduced at will with the following steps:
- Add a regular product and a Service Item to a quote
- Receive error
Excerpt from the log file:
ASO SQLERRM : User-Defined Exception
ASO Exception in package : ASO_QUOTE_PUB
ASO Exception in API : UPDATE_QUOTE
ASO SQLCODE : -1086
ASO SQLERRM : ORA-01086: savepoint 'UPDATE_QUOTE_PVT' never established in this session or is invalid
ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62
ORA-06512: at "APPS.ASO_QUOTE_HEADERS_PVT", line 11345
ORA-06510: PL/SQL: unhandled user-defined exception
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