My Oracle Support Banner

Error "Data PER_SEX not found at line <n> of BG_ABSENCE_DURATION" in Mobile Absences (Doc ID 2830471.1)

Last updated on JUNE 02, 2023

Applies to:

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

Symptoms

When trying to apply absence from Mobile Applications, following error appears

ERROR
---------

Data PER_SEX not found at line 446 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
-------

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

1. Login using SSHR App (Self-Service Human Resources for EBS) in Mobile Applications.

2. Choose the "Employee Self-Service" responsibility.

3. Choose Absences.

4. Enter the details and click Save.

5. Encounter the above 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.