When Attempting To Create A New RFQ Errors: ORA-01086: savepoint 'CREATE_NEGOTIATION_BULK_SP'
(Doc ID 2811397.1)
Last updated on FEBRUARY 19, 2024
Applies to:
Oracle Sourcing - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.10 version, Auction/RFx creation
Receive Error when attempting to Create a new RFQ from Sourcing Buyer Responsibility on 12.2.10
This does work in 12.1.3.
ERROR
-----------------------
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: 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 172
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
. . .
## 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 172
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Sourcing > Requisitions > Demand Workbench > Search by Buyer
2. In Search criteria Add Another "Assignment Number" and click Add
3. Click Create and error occurs
Changes
Upgrade to 12.2.10
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 |