Absence : ORA-01843: not a valid month in Package hr_person_absence_swi Procedure create_person_absence (Doc ID 1636217.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Human Resources - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

In 12.1.1, in forms (pui) or in Self Service (sshr), when one tries to enter an absence, the following error occurs :

1) In Forms (PUI) :

ORA-01403: no data found
FRM-435: ON-INSERT trigger raised unhandled exception ORA-01843.


2) In Self Service (sshr) :

Error
ORA-01843: not a valid month in Package hr_person_absence_swi Procedure create_person_absence


--- Steps to reproduce
1. Enter an absence in PUI or in sshr
2. Get the error

--- Business impact
Neither HR user Not End user are unable to enter any leave

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