Trying to set up element 'Input Validation' with Date Format - getting APP-FF-33208: ora-1861 (Doc ID 1556498.1)

Last updated on DECEMBER 19, 2016

Applies to:

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

Goal

Using the following code in my fast formula (below) but when I go on the element and enter any date, it errors :

 

/* Formula Type: Element Input Validation */
INPUTS ARE entry_value(TEXT)
P_DATE = TO_DATE(entry_value,'DD-MM-YYYY')
COUNT = XX_HR_COUNT_FUTURE_ENTRIES('Tickets Processing',P_DATE)
IF count <>0
THEN
(
  formula_status = 'e'
  formula_message = 'The employee has future entries for ticket processing'
  RETURN formula_status, formula_message
)
ELSE
(
  formula_status = 's'
)
RETURN formula_status, formula_message

Note that I have update the formula to make it simple like below, and still got the same error

/* Formula Type: Element Input Validation */
INPUTS ARE entry_value(TEXT)
P_DATE = TO_DATE(entry_value,'DD-MM-YYYY')
 formula_status = 's'
formula_message= 'ok
RETURN formula_status, formula_message
 

 

Error :

=====
APP-FF-33208: ora-1861 occurred at line 3 of formula xx_hr_tkt_proc_val
cause: whilst executing pl/sql, an oracle error occurred the line number and line position, are given where available
Action: please refer to your system administrator.
(4=0)

Solution

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