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 AUGUST 22, 2017

Applies to:

Oracle Quoting - Version 12.1.3 and later
Information in this document applies to any platform.

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

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