My Oracle Support Banner

Updating Absence Dates on Absences Already Approved , Errors: ORA-20001:Data PER_EMP_NUMBER Not Found At Line 66 Of BG_ABSENCE_DURATION (Doc ID 1992135.1)

Last updated on AUGUST 31, 2023

Applies to:

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


On : 12.0.6 version, Assignment,Term,Pay,ChgMgr,LOA

When attempting to update absence dates on absences already approved, the approval process can be performed from the front end but the following error occurs in the workflow at commit stage

The changes were not applied because ORA-20001: Data PER_EMP_NUMBER not found at line 66 of BG_ABSENCE_DURATION Cause: A SQL SELECT statement, obtained from the application dictionary,

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

1. Employee Self-Service > Absence Management
2. Create Absence: Enter Details

3. Create Absence: Review
4. After final Approval the Borrowed Leave was posted in Core HR.
5. Update the same absence in SSHR: leave on 21st instead of 20th
6. Now due to certain changes in the plan I want to take my leave on 21st instead of 20t.
7. Approve
8. Workflow monitor: Transaction in error

11. Workflow Activities history




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

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