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" (Doc ID 1577129.1)

Last updated on APRIL 16, 2024

Applies to:

Symptoms

HTML User Interface

When attempting to add a regular product and a Service Item to a quote the following error occurs.

Error

Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Rollback to Savepoint": SQL Statement "null".
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)

## 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:

1. Add a regular product and a Service Item to a quote
2. 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

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.