Viewing Absence Details, Error's: Data PER_EMP_NUMBER not found at line 175 of BG_ABSENCE_DURATION When Displaying Absence (Doc ID 1320839.1)

Last updated on JANUARY 07, 2016

Applies to:

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

Symptoms

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

When viewing absence details in Manager Self Service, the following error occurs:

Data PER_EMP_NUMBER not found at line 175 of BG_ABSENCE_DURATION
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.

From Core:

6) XX US HRMS SUPER USER>People Enter and Maintain>Others>Absence
7) Record is successfully created with no errors.

Cause

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