Skip to main content
Question

Error message when deploying an IAL - Encode

  • May 15, 2020 10:18 AM UTC
  • 3 replies
  • 410 views
Sidekick (Customer)
Forum|alt.badge.img+9

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

    3 replies

    eqbstal
    Superhero (Partner)
    Forum|alt.badge.img+21
    • eqbstal
    • Superhero (Partner)
    • May 15, 2020 12:10 PM UTC

    Miguel,

    When entering an IAL you see in screen IAL Object Developer, amongst others, the following

    For you this means that you will have to write the line as:

    &AO..Wage_Group_API.Encode('HOL Holiday'),

    Yes, that is two dots (‘..’) between the O and the W.

    Steve

    Thanks for using the community, it helps me. I hope I can help you.
      Sidekick (Customer)
      Forum|alt.badge.img+9
      • Miguel
      • Author
      • Sidekick (Customer)
      • May 15, 2020 12:45 PM UTC

      Hi Steve,

      Many thanks, the deployment went through without errors.

      I don’t think I understand the rationale of the change though. Please see the main part of my SQL code with the IAL deployed successfully now. I only inserted the &AO.. in the nested API call, not everywhere.

      Miguel

       

      ifsapp.work_sched_assign_api.Get_Day_Sched_Code(COMPANY_ID,EMP_NO,ACCOUNT_DATE) SCHEDULE,
        NVL(IFSAPP.WORK_SCHED_ASSIGN_API.GET_SCHED_HOURS_DB(COMPANY_ID,EMP_NO,ACCOUNT_DATE,ACCOUNT_DATE),0) SCHED_HOURS,
        NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_ABSENCE_HOURS(COMPANY_ID,EMP_NO,ACCOUNT_DATE,ACCOUNT_DATE),0) ABSENCE_HOURS,
        NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_WAGE_HOURS(COMPANY_ID,EMP_NO,&AO..Wage_Group_API.Decode('Absemce'),'HOL',null,ACCOUNT_DATE,ACCOUNT_DATE),0) HOL_HOURS,
        NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_WAGE_HOURS(COMPANY_ID,EMP_NO,&AO..Wage_Group_API.Decode('Absemce'),'SICK',null,ACCOUNT_DATE,ACCOUNT_DATE),0) SICK_HOURS,
        NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_WAGE_HOURS(COMPANY_ID,EMP_NO,&AO..Wage_Group_API.Decode('Absemce'),'BHOL',null,ACCOUNT_DATE,ACCOUNT_DATE),0) BHOL_HOURS,

      eqbstal
      Superhero (Partner)
      Forum|alt.badge.img+21
      • eqbstal
      • Superhero (Partner)
      • May 15, 2020 3:32 PM UTC

      Miguel,

      It works what you have done. However it would be best if everywhere where you have entered IFSAPP. manually change it in &AO..

      This ensures that if for one reason or the other the application owner is changed, the IAL remains working as designed.

      Steve

      Thanks for using the community, it helps me. I hope I can help you.
      Terms & ConditionsAccessibility statement