Unable to delete UK SMP Maternity Absence Record : HR_PERSON_ABSENCE_API

(Doc ID 1186838.1)

Last updated on FEBRUARY 06, 2018

Applies to:

Oracle HRMS (UK) - Version and later
Information in this document applies to any platform.


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 )


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