Dear IFS Experts,
Please see line included in a SQL statement below:
NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_WAGE_HOURS
(ED.COMPANY_ID,
ED.EMP_NO,
Wage_Group_API.Encode('HOL Holiday'),
'HOL',
null,
ED.ACCOUNT_DATE,
ED.ACCOUNT_DATE),0) HOL_HOURS,
this line works in SQL developer but when I try to deploy the IAL in IFS I get the following error:
I have highlighted in red the Encode part of the code that seems to be upsetting the IFS IAL deployment
I would really appreciate if you have any insights about this error message.
Many thanks