When Using RFQ Template During RFQ Creation, ORA-01086 Error Occurs When Adding a Requisition Line to the Negotation
(Doc ID 2478276.1)
Last updated on JULY 03, 2023
Applies to:
Oracle Sourcing - Version 12.2.4 to 12.2.8 [Release 12.2]Information in this document applies to any platform.
Symptoms
In Oracle Sourcing and Oracle Purchasing, Release 12.2.4 through 12.2.8, an error occurs when a user attempts to add an existing requisition line to a new RFQ (solicitation) document.
Due to this issue, users cannot add the existing requisition lines to a new RFQ document.
Error
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01086: savepoint 'CREATE_NEGOTIATION_BULK_SP' never established in this
ORA-06512: at "APPS.PO_NEGOTIATIONS_SV1", line 167
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:156)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.createDocument(DocBuilderBaseCO.java:309)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.createDocumentAndForward(DocBuilderBaseCO.java:137)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.handleCreateButton(DocBuilderBaseCO.java:380)
at oracle.apps.po.autocreate.webui.DocBuilderSideCO.processFormRequest(DocBuilderSideCO.java:347)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:909)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1136)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1087)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:942)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1424)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1121)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1087)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:942)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1121)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1087)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:942)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3397)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2061)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:586)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:474)
at _pages.__oa._jspService(__oa.java:233)
..
..
## Detail 0 ##
java.sql.SQLException: ORA-01086: savepoint 'CREATE_NEGOTIATION_BULK_SP' never established in this session or is invalid
ORA-06512: at "APPS.PO_NEGOTIATIONS_SV1", line 167
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.apps.po.common.server.PoCallableStatement.execute(PoCallableStatement.java:297)
at oracle.apps.po.autocreate.server.CreateDocumentSvrCmd.createNegotiation(CreateDocumentSvrCmd.java:730)
at oracle.apps.po.autocreate.server.CreateDocumentSvrCmd.createDocument(CreateDocumentSvrCmd.java:574)
at oracle.apps.po.autocreate.server.CreateDocumentSvrCmd.execute(CreateDocumentSvrCmd.java:229)
at oracle.apps.po.common.server.PoBaseAMImpl.executeServerCommand(PoBaseAMImpl.java:110)
at sun.reflect.GeneratedMethodAccessor5961.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:156)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.createDocument(DocBuilderBaseCO.java:309)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.createDocumentAndForward(DocBuilderBaseCO.java:137)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.handleCreateButton(DocBuilderBaseCO.java:380)
at oracle.apps.po.autocreate.webui.DocBuilderSideCO.processFormRequest(DocBuilderSideCO.java:347)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:909)
..
..
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01086: savepoint 'CREATE_NEGOTIATION_BULK_SP' never established in this
ORA-06512: at "APPS.PO_NEGOTIATIONS_SV1", line 167
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:156)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.createDocument(DocBuilderBaseCO.java:309)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.createDocumentAndForward(DocBuilderBaseCO.java:137)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.handleCreateButton(DocBuilderBaseCO.java:380)
at oracle.apps.po.autocreate.webui.DocBuilderSideCO.processFormRequest(DocBuilderSideCO.java:347)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:909)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processFormRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1136)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1087)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:942)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)
at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1424)
at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1121)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1087)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:942)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1121)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1087)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:942)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:424)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3397)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2061)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:586)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:474)
at _pages.__oa._jspService(__oa.java:233)
..
..
## Detail 0 ##
java.sql.SQLException: ORA-01086: savepoint 'CREATE_NEGOTIATION_BULK_SP' never established in this session or is invalid
ORA-06512: at "APPS.PO_NEGOTIATIONS_SV1", line 167
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.apps.po.common.server.PoCallableStatement.execute(PoCallableStatement.java:297)
at oracle.apps.po.autocreate.server.CreateDocumentSvrCmd.createNegotiation(CreateDocumentSvrCmd.java:730)
at oracle.apps.po.autocreate.server.CreateDocumentSvrCmd.createDocument(CreateDocumentSvrCmd.java:574)
at oracle.apps.po.autocreate.server.CreateDocumentSvrCmd.execute(CreateDocumentSvrCmd.java:229)
at oracle.apps.po.common.server.PoBaseAMImpl.executeServerCommand(PoBaseAMImpl.java:110)
at sun.reflect.GeneratedMethodAccessor5961.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.po.common.webui.ClientUtil.executeServerCommand(ClientUtil.java:156)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.createDocument(DocBuilderBaseCO.java:309)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.createDocumentAndForward(DocBuilderBaseCO.java:137)
at oracle.apps.po.autocreate.webui.DocBuilderBaseCO.handleCreateButton(DocBuilderBaseCO.java:380)
at oracle.apps.po.autocreate.webui.DocBuilderSideCO.processFormRequest(DocBuilderSideCO.java:347)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:909)
..
..
Steps To Reproduce
The issue can be reproduced at will with the following steps:
1. Log in to Oracle Applications, using a Sourcing Buyer or Sourcing Super User responsibility.
2. On the Negotiations home page, select Create Solicitation (Create RFQ).
3. On the Create Solicitation page (Create RFQ page), enter the required info and add existing RFQ template to the RFQ. Save as draft.
4. Click the Lines link (to navigate to the Lines region).
5. On the Create Lines page, select Actions = Add Requisition Lines and click the Go button.
6. On the Demand Workbench page, select the desired requisition and click the "Add To PO or Solicitation" button ("Add to PO or RFQ" button).
7. Then, in the Document Builder region, the requisition's line is seen. Click the Create button to add it to the solicitation being created. The error occurs at this point.
The same issue occurs when adding the lines from the Buyer Work Center in Purchasing responsibility.
Changes
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 |