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 laterInformation 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:
-----------------------
## 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 |