Framework Error CREATE_NEGOTIATION_BULK_SP On Page When Creating RFQ Based From Requisitions via Buyer Work Center and Oracle Sourcing (Doc ID 1439630.1)

Last updated on DECEMBER 01, 2016

Applies to:

Oracle Sourcing - Version 12.1.3 and later
Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a Request for Quotation (RFQ) from an approved requisition within the Buyer Work Center, the following error occurs.

This issue only occurs when the selected item type is 'Goods or services billed by amount' when creating a requisition, rather there is no problem with the other two item types.

Error:
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01086: savepoint 'CREATE_NEGOTIATION_BULK_SP' never established
ORA-06512: at "APPS.PO_NEGOTIATIONS_SV1", line 149
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1

 

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 167
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1




Replication Steps:
The issue can be reproduced at will with the following steps:

1. Go to the Purchasing Super User > Buyer Work Center > Requisitions
2. Change the view to see all approved requisitions
3. Change Document Builder to 'New RFQ'
4. Select one Requisition and click on the add button
5. Click on the Create button
6. Same error happens if you try to create an RFQ from a requisition in Oracle Sourcing

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms