Human Capital Management - EBS (MOSC)

MOSC Banner

Need Assistance on Fast Formula

edited Oct 3, 2012 7:23PM in Human Capital Management - EBS (MOSC) 2 commentsAnswered
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

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,
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center