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:

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

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