ORA-01086: Savepoint 'WF_SAVEPOINT' Never Established In This Session Or Is Invalid (Doc ID 2109202.1)

Last updated on JUNE 14, 2017

Applies to:

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

Symptoms

On Release 12.1.3 version, Punchout

AUTOCREATE PO FROM REQUISTION, ERRORS ORA-01086, NO SAVEPOINT 'WF_SAVEPOINT'Auto Create Purchase Order gets error
ERROR:
=======
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 'WF_SAVEPOINT' never established in this session or is invalid
ORA-20002: 3101: Status row for item 'REQAPPRV/50756-73447', activity ID '263521' does not exist.
ORA-06512: at "APPS.POR_UTIL_PKG", line 1543
ORA-06512: at line 1
.
## Detail 0 ##
java.sql.SQLException: ORA-01086: savepoint 'WF_SAVEPOINT' never established in this session or is invalid
ORA-20002: 3101: Status row for item 'REQAPPRV/50756-73447', activity ID '263521' does not exist.
ORA-06512: at "APPS.POR_UTIL_PKG", line 1543
ORA-06512: at line 1

STEPS TO REPRODUCE
=====================
The issue can be reproduced at will with the following steps:
ign on to Application
Select Responsibility: iProcurement Entry
Navigation: iProcurement - Home Page->> Shop Tab ->>
Stores - >> Select: "Insight" ->> Punchout to Supplier:XXX Web Site
Scroll Through Ultra Light Weight Laptop ->> Select: Laptop XXX-111-C6EQ
Add to Cart and Checkout ->> Click: Submit ->> Returns to the iProcurement Shopping Cart ->>
Click: Checkout ->>Review Checkout: Requisition Information, And Click: Submit ->>
Receive Error: 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 'WF_SAVEPOINT' never established in this session or is invalid
ORA-20002: 3101: Status row for item 'REQAPPRV/50756-73447', activity ID '263521' does not exist.
ORA-06512: at "APPS.POR_UTIL_PKG", line 1543
ORA-06512: at line 1
.
## Detail 0 ##
java.sql.SQLException: ORA-01086: savepoint 'WF_SAVEPOINT' never established in this session or is invalid
ORA-20002: 3101: Status row for item 'REQAPPRV/50756-73447', activity ID '263521' does not exist.
ORA-06512: at "APPS.POR_UTIL_PKG", line 1543
ORA-06512: at line 1



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