Execute Event from Command - EVENT_SYS.EVENT_EXECUTE

Hi @Kalindu 

Try following snippet for constructing the message to send to the event.

In this example, it adds value to NEW:WO_NO attribute. you can use it in the event action as &NEW:WO_NO.

For safeguard, I usually keep the event enabled without adding and Fire When actions.

  DECLARE
    msg_       VARCHAR2(32000);
  BEGIN
    msg_ := MESSAGE_SYS.Construct('EVENT_ID');
    MESSAGE_SYS.add_attribute(msg_,'NEW:WO_NO', wo_value);
    IF (EVENT_SYS.event_enabled('EventLU', 'EVENT_ID')) THEN      
      EVENT_SYS.event_execute('EventLU','EVENT_ID',msg_);
    END IF;
  END;

Hope it helps!

Damith

Hi ​@dsj 

Where do you add this message sending parameters to the event?

Thank you!

Krzysztof

Anyone find a solution to this? I am trying to pass parameters through the ExecuteAction to the custom event as well. I’ve yet to find anything online on how to do this from the page designer where the ExecuteAction is defined.

Right now I’m passing a value to the Event_Data_ parameter but, like the original poster said, it isn’t clear what the syntax is needed to assign it to the parameter(s) in the custom event.

If the custom event has the OLD:ORDER_NO field, how does one assign the correct data from the ExecuteAction to that field?

Kalindu, I seem to have found a solution. When creating the ExecuteAction, the Event_Data_ parameter can pass a value to an attribute on the called event with the following syntax:

$OLD:VALUE=${FIELD}

Where VALUE is the name of the attribute on the event, and FIELD is a value from the page you’re creating the ExecuteAction button on. Switch out OLD with NEW as necessary.

I am unsure how to pass more than one, haven’t had time to test it further.