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

Last updated on SEPTEMBER 20, 2023

Applies to:

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: <Store> ->> Punchout to Supplier:<Supplier>
Scroll Through <Product> ->> Select: <Product>
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

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