Unable to delete UK SMP Maternity Absence Record : HR_PERSON_ABSENCE_API
(Doc ID 1186838.1)
Last updated on FEBRUARY 16, 2019
Applies to:
Oracle HRMS (UK) - Version 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
Attempting to delete an SMP absence from the absence form, for a Maternity absence, the following error occurs;
-----------------------
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HR_PERSON_ABSENCE_API", line 1861
Steps to Reproduce:
UK Super HRMS Manager resp >
1. SSP Menu >
2. Person Details >
3. query for employee >
4. People screen >
5. Others button >
6. select Maternity >
7. Maternity screen
Child Detail region > ( table SSP_MATERNITIES )
Birth Date ( column ACTUAL_BIRTH_DATE )
Notified ( column NOTIFICATION_OF_BIRTH_DATE )
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 |