The blog for Oracle Data Integrator ( ODI )

How to show Business Messages on Operator and, too, debug variables…

Hi Guys,

I frequently got emails asking how to do show Business messages on OD and, as there isn’t such feature until version, I created a way to have it.

It’s just like a magic trick!

We will need an “assistant”….  Let me see….   Please, you, the ODI Procedure! Come to stage!!!!!

Now the preparation to the magic!

1) Create an Option in the Procedure, we can call it The_Message (Type Value), like:

Option to show Message

2) Now create a step, we can call it “Show Message”
3) Put the technology to Java BeanShell

Add the following code:

throw new Exception(“nn<%=odiRef.getOption(“The_Message”)%>nn”)


Procedure to show Message 

That is it! Nothing more!

To use it, add to any package, click on it, go to its proprieties, Option Tab and write however it the message you wish to show at Operator. It will be like:

Package to show Message

Now, if you go to operator, that is what you will get;


Operator to show Message 

Magic Done! Did you like?

OK, now just a small tip! As you see, the “Show any message” step is in RED, that means “The process will be stopped here”. If you wish let it as “Warning” and do not stop the process, click on the checkbox “Ignore Error” in the Procedure step and you can add more steps after the Procedure “Show Message”.

Remember that you can use this Procedure infinite times in the same package or any other… Just change the value of the Option.

That is very useful to debug variable and gots its value at Operator!

Make any sense??

Once more, comments are very welcome!!!!!!


Cezar Santos


Leave a Reply

Required fields are marked *.

This site uses Akismet to reduce spam. Learn how your comment data is processed.