Siebel workflows missing Query operation

Homepage » Problem Solutions » Siebel Workflow Step – Missing Query Operation

Siebel Workflow Step – Missing Query Operation

By neel October 7th, 2008

I came across a really strange problem while working with workflows few days ago.

Problem:

I had to create a workflow and the first step in the workflow was Query Operation on Opportunity BC. I dragged the Siebel Operation Step into designer and then started entering Values for this step which were as following

Type: Siebel Operation
Business Component: Opportunity
Operation: Query

But to my utter surprise Query was missing in the Operation field dropdown and only Insert and Update were available.

When I entered Query manually in the field it accepted the value but started giving error

“Error loading Step Definition: Query Operation not found”
(Not exact error message)

Solution:

After going through the logs and thinking logically I was able to find the solution of the problem. My logical thinking that gave met he answer was.

Drop down is a picklist in Siebel and picklist gets it’s values from List of Values. I queried with Insert in the Display Value in List of Values view and there was a LOV Type called “WF_SIEBEL_OPER_TYPE_CD” which had Insert and Update as Active and “Query” was inactive.
After making “Query” record Active and restarting tools I was able to execute my workflow successfully.

Note: Even if you provide LIC of this LOV in small case then also you will get the error. For this LOV Display value has to be in Camel Case and LIC in caps

Hope this will save someone from a lot of hassel and I still have to find the person who made this LOV inactive