Need Assistance on Fast Formula
Hr formula can't get value.
/**********************************************************
FORMULA NAME: EJU Sickness Leave Deduce
*********************************************************/
DEFAULT FOR PAY_PROC_PERIOD_DATE_PAID IS '4721/01/01 00:00:00' (date)
DEFAULT FOR SYS_DATE IS '2012/05/25 00:00:00' (DATE)
SYS_DATE = to_date('2012/05/25','yyyy/mm/dd')
l_years = to_char(23)
l_service_year=to_number(get_table_value('EJU Sickness Leave1 Deduce Rate',
'Dedution Rate',
l_years,SYS_DATE))
RETURN l_service_year
/**********************************************************
FORMULA NAME: EJU Sickness Leave Deduce
*********************************************************/
DEFAULT FOR PAY_PROC_PERIOD_DATE_PAID IS '4721/01/01 00:00:00' (date)
DEFAULT FOR SYS_DATE IS '2012/05/25 00:00:00' (DATE)
SYS_DATE = to_date('2012/05/25','yyyy/mm/dd')
l_years = to_char(23)
l_service_year=to_number(get_table_value('EJU Sickness Leave1 Deduce Rate',
'Dedution Rate',
l_years,SYS_DATE))
RETURN l_service_year
Error
Data GET_TABLE_VALUE not found at line 36 of EJU Sickness Leave Deduce
Cause: A SQL SELECT statement, obtained from the application dictionary, returned no rows when executed.
But I can get Value from plsql hruserdt.get_table_value(p_bus_group_id => 0,
Data GET_TABLE_VALUE not found at line 36 of EJU Sickness Leave Deduce
Cause: A SQL SELECT statement, obtained from the application dictionary, returned no rows when executed.
But I can get Value from plsql hruserdt.get_table_value(p_bus_group_id => 0,
Tagged:
0