Order Release Event Notifications

albert · #1 (**permalink**) January 29th, 2008, 13:32

Hi All,

Our customer require new Order Releases to be monitored before shipped. We monitor the 'production' process of the order. Events are added to each Order Release. These Events needs to be monitored or actioned when they are added to an Order Release. For example, each Order Release has a Cargo Handover Date, if a user add an event (Reason Code: Cargo Handover Data Changed), an agent needs to initiate and notify an involved party that the cargo handover date has changed.

I have created a custom agent event, called, Order Release - Event Created. The agent created is an Order Release agent with the new agent event. The agent actions has an IF statement with a saved condition with a saved sql query. The query 'looks' for the specific reason code, and if the condition is met, another action will notify the involved parties. This is not working.

Any suggestion on how to solve this problem?

Thanks for the help,
Albert

bmj_23 · #2 (**permalink**) January 29th, 2008, 20:44

Is there any information in the log files that is pointing to an error ? and when you say it is not working, do you mean that an outbound eamil notification is not being generated ? Are any other email notifications to that involved party working ?

Repost if you are still having issues.

albert · #3 (**permalink**) January 29th, 2008, 20:59

Hi,

Thanks for the reply. No information in the log file. The agent doesn't execute on the event it needs to. Let me explain. When an event is added to an Order Release, the agent needs to execute and then based on the reason code in the event, notify a contact or an involved party. I created a custom event, Order Release - Event Created. This Agent should then listen for the event to be added to the order release, and then, based on an 'if' and saved condition in the Agent Actions, notify a contact and an involved party.

All notification on the involved party and contact is working. My order release events is added with a Quick Code and the Reason Codes and Status Codes assigned to the specific Quick Code.

I suspect the agent event is the problem, but have no idea on how this 'fix' it.

On this point, is it possible the action agents on order release events?

Albert

bmj_23 · #4 (**permalink**) January 29th, 2008, 21:05

Albert - so, it is only the notification for this automation agent that is not working right ?

I would turn on more detail in the log files and re-run the process. Its probably something quite straightforward to fix if you take a look at the log files.

My suggestion would be to turn on Exception, Workflow, WorkflowDetails, Agent and SQL in a log file and see what that gives you.

albert · #5 (**permalink**) January 29th, 2008, 21:14

Hi,
Thanks for the tip. I'll do it. Will update the thread to let you know if I got it working.
Albert

albert · #6 (**permalink**) January 30th, 2008, 07:06

Hi,

I did turn-on more detail in the log file, but still no joy.

Is there any Agent Events that execute when and Order Release Event is added to an Order Release. An Order Release Event in my clients world is, 'Production Line Down'. This is event or occurrence is added to the Order Release through the Add Order Release Event menu action.

Once such an occurrence is added to the Order Release, an Involved Party needs to be notified automatically.

Regards,
Albert

bob_romijn · #7 (**permalink**) January 30th, 2008, 08:49

Hi,

As far as I understand your story, you are using the wrong event in the agent (at least because your agent is not triggered). Your telling "Order Release - Event Created". I always use "ORDER RELEASE STATUS - RECEIVED". I assume you are adding events through the UI (or Integration). I also use this event with my own created events and reasons, which works very well.

I don't know how you configured your saved conditions but you can use the agent variable "$bs_status_reason_code_gid" for getting the reason code for this event. No difficult SQL is this case. (Just a hint)

If this idea doesn;t solve it. Please look into the logs whether your agent is getting triggered. You have to set up your log setting at least with "Agent" active.

Feel free to report when not clear.

albert · #8 (**permalink**) January 30th, 2008, 08:53

Hi Bob,

Thanks for these pointers. I appreciate it a lot. Will use them and post the outcome.

Regards,
Albert

albert · #9 (**permalink**) January 30th, 2008, 10:04

Hi Bob,

Thanks for the advice, working beautifully.

But, can you help with the following. On the email notification and the notification send to the message center, the Status Information that needs to be displayed is not displayed (No Event Date, Event Group and Status Code). In the Comment field of the new event added, information will be added that will be used to update the external system where the orders is created, this also needs to be displayed. I think it has to do with the style sheet, its just that I don't have any knowledge of style sheets and needs some guidence, if this is the place to do it.

Any other suggestion you may have are very welcome.

Thanks again, I appreciate it,
Albert

bob_romijn · #10 (**permalink**) January 30th, 2008, 13:10

Hi,

I'm glad it worked for you.
Normally I should expect the event information on the notification as it also the case with shipment events.

Perhaps the stylesheet is not extended (by the time this was added) to host this. You can do it yourself.........
It should be in the stylesheets that are triggered out of stylesheet "workflow/DefaultOrderEventHtml.xsl".

Hope this helps.