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