My Oracle Support Banner

Unable to Create Absence Due to Error ORA-01086: savepoint 'IRC_SAVEPOINT' never established in this session or is invalid On Java Stack Log (Doc ID 3016706.1)

Last updated on APRIL 15, 2024

Applies to:

Oracle Self-Service Human Resources - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms



When attempting to create Leave of Absence from Employee Self Service responsibility, the following error occurs on Create Absence: Enter Absence Details page:

ERROR
-----------------------

You have encountered an unexpected error. Please contact the System Administrator for assistance.

 

 

Error from the java error stack as below:

ERROR
-----------------------

## Detail 0 ##
java.sql.SQLException: ORA-01086: savepoint 'IRC_SAVEPOINT' never established in this session or is invalid
ORA-06512: at "APPS.IRC_UTILITIES_PKG", line 45
ORA-06512: at line 1



The following error can be found on Human Resource Absence Core form:

ERROR
-----------------------

FRM-40735: ON-INSERT trigger raised unhadled exception ORA-01086

 

 


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


1. Using Employee Self Service responsibility.

2. Navigate to Absence Management page > Click on Create Absence button.

3. Enter absence details > click Next button > get error.


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
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.