My Oracle Support Banner

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 later
Information 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


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