Unable to delete UK SMP Maternity Absence Record : HR_PERSON_ABSENCE_API (Doc ID 1186838.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle HRMS (UK) - Version 11.5.10.2 and later
Information 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;

ERROR
-----------------------
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

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