My Oracle Support Banner

Create Item Errors Out: ORA-01086: Savepoint 'BO_SP' (Doc ID 1290029.1)

Last updated on MAY 31, 2019

Applies to:

Oracle Product Hub - Version 12.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 09-SEP-2014***

Symptoms

The following error appears creating an item as a copy from other items when one hits the Finish (Button).
The item is created but the Attributes are blank that should have been copied from the existing item.
This is an intermittent problem and it works some times and not others.

Workaround
Users are manually entering the attribute data that did not copy from the existing item.

Steps
1. Development Manager > Item Catalog > Create Production Items
2. Create item as a copy from an existing item.
3. Save.
4. Usually works but sometimes get the error.

Business Impact
This is very time-consuming to manually enter attributes.

Error
oracle.apps.fnd.framework.OAException: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Rollback to Savepoint": SQL Statement "null".

Error Stack
Here are more details from the error stack:

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:980)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
at oracle.apps.ego.item.eu.webui.EgoCreateItemTrainNavButtonsCO.handleSubmitEvent(EgoCreateItemTrainNavButtonsCO.java:491)
at oracle.apps.ego.item.eu.webui.EgoCreateItemTrainNavButtonsCO.processFormRequest(EgoCreateItemTrainNavButtonsCO.java:147)
java.sql.SQLException: ORA-01086: savepoint 'BO_SP' never established
java.sql.SQLException: ORA-01086: savepoint 'BO_SP' never established
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:690)
at oracle.apps.ego.item.eu.server.EgoEditItemAMImpl.saveItem(EgoEditItemAMImpl.java:2504)
at oracle.apps.ego.item.eu.webui.EgoCreateItemTrainNavButtonsCO.handleSubmitEvent(EgoCreateItemTrainNavButtonsCO.java:491)
at oracle.apps.ego.item.eu.webui.EgoCreateItemTrainNavButtonsCO.processFormRequest(EgoCreateItemTrainNavButtonsCO.java:147)

Changes

The problem started after upgrading from HP Unix 11 O/S to 11.31.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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