Viewing Absence Details, Error's: Data PER_EMP_NUMBER not found at line 175 of BG_ABSENCE_DURATION When Displaying Absence
Last updated on MAY 24, 2018
Applies to:Oracle Self-Service Human Resources - Version 12.1.1 and later
Information in this document applies to any platform.
On : 12.1.1 version, Assignment,Term,Pay,ChgMgr,LOA
When viewing absence details in Manager Self Service, the following error occurs:
Cause: A SQL SELECT statement, obtained from the application dictionary, returned no rows when executed.
Action: Please refer to your local support representative.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1) XX US Employee Self Service>Absence Mgmt> Create Absence
2) Enter Absence Details.
3) Calculate Duration
5) Issue replicates when Manager Self Service is used as well.
6) XX US HRMS SUPER USER>People Enter and Maintain>Others>Absence
7) Record is successfully created with no errors.
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