My Oracle Support Banner

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


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.