(Doc ID 1940432.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Benefits - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.


On Applications 12.1.3 in Prod, R12RUP6:
When attempting to run retropay for some employee's OSP entitlement, the following error occurs.

-- Error
UDF Error in formula <XXX>_OSP_OSP_ABSENCE_PAY_INFORMATION_FORMULA at line 498: 'pqp_absval_pkg.get_absences_taken_to_date{60}: ORA-01840: input value not long enough for date format'

-- Steps
The issue can be reproduced at will with the following steps.
1. Absences deleted and life event records became corrupted.
2. Backed out the life events for the effected employee back to when the life events became corrupted.
3. Re-enrolled absence records one by one ensuring that the employee's life events appeared correct.
4. Run the Retro-Notifications Report (Enhanced) PDF which showed the employee twice with two slightly different assignment numbers.
5. Run the Enhanced Retropay process comlpeted with a status of Incomplete


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