Hey community,

we are trying to improve the Time registration process for our users and want to add pop-up information message to remind users to confirm their hours entered when week is completed.

I have set up a Custom Event to LU TimmanJobTrans and table TIMMAN_JOB_TRANS_TAB. It fires upon new records created and records changed. So far it’s working.
I have also added two Event Actions to this event: 

1. Type: E-Mail - which works just fine but was considered only for testing reasons (check if the event is fired etc.)
2. Type: Execute Online SQL - which seems to be not firing or at least the pop-up message doesn’t show up.

Can anyone assist on making the Online SQL Event action work?

DECLARE
   msg_de VARCHAR2(200) := 'DE';
   msg_en VARCHAR2(200) := 'EN';
   msq_output VARCHAR2(200);

   job_status_ VARCHAR2(50);

BEGIN

   IF '#USER_LANGUAGE#' = 'de' THEN
      msq_output := msg_de;
   ELSE 
      msq_output := msg_en;
   END IF;

   job_status_ := IFSAPP.Project_Pers_Diary_API.Date_Intervall_Confirm_Status('&NEW:COMPANY_ID', '&NEW:EMP_NO', TO_DATE('&NEW:ACCOUNT_DATE', 'YYYY-MM-DD'), TO_DATE('&NEW:ACCOUNT_DATE', 'YYYY-MM-DD')+6);

      --IF job_status_ = 'PARTLY CONFIRMED' THEN
         Client_SYS.Add_Info('CompanyPerson', msq_output);
      --END IF;

END; 

The If statement at the end should not actually be commented out, but I have commented it out for testing purposes. Nevertheless, no message appears.