Close A Discrete Job Got ORA-01086: Savepoint 'WIP_CLOSE' Never Established In This Session Or.. (Doc ID 1491809.1)

Last updated on NOVEMBER 24, 2015

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Others

When attempting to run Close Discrete Job (SRS) on the same Job twice,
the following error occurs.

ORA-01086: savepoint 'WIP_CLOSE' never established in this session or is invalid
ORA-06510: PL/SQL: unhandled user-defined exception

The issue can be reproduced at will with the following steps:
1. Go to Work in Process responsibility

2.Navigate to Discrete>Close Discrete Jobs

3.Run the request Close Discrete Job (SRS) on the same Job twice


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