Siebel Business Process & Functionality (MOSC)

MOSC Banner

WORKFLOW MONITOR ERRORING AFTER UPGRADE FROM 8.1.1.7 SEA TO 8.1.1.8 SIA

edited May 13, 2013 7:27AM in Siebel Business Process & Functionality (MOSC) 5 commentsAnswered

Issue

---------

customer upgraded from 8.1.1.7 SEA to 8.1.1.8 SIA. After the upgrade, workflow monitor agent is encountering error due to the improper syntax of sql generated against the existing rules.The issue is the conditions are getting 
concatenated if there are two IN conditions in the policy. Below mentioned is the policy condition. The environment is Microsoft SQL Server 2005 64 bit 

workflow policy Object: Service Request 

Policy Condition 

Service Request Organization = 0-R9NH 
Service Request Status IN ('Open', 'Closed') 
Service Request Type IN ('Auto', 'Member') 


SQl Generated by workmon is 
--------------------------------------- 
SELECT T0.ROW_ID 
FROM 
&Table_Owner.S_SRV_REQ T0 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center