Posts

Showing posts from August, 2011

Siebel 8.1 weird WF validation error

We got the below error message while validating a workflow in Siebel 8.1 Validation failed for the workflow process 'XYZ' for the branch 'Connector 33' The 'WF Branch Criteria Value' - field such as LO_.. or HI_.. for the respective data type is null or empty. Solution: Run the sql below with the source as workflow row id, you will see all the branch conditions in your workflow. Pick the one which has the same name as the error message, isolate the wf step (you can modify this sql to get that) and then delete and re-add the condition step. SELECT WFBRANCRIT . ROW_ID , WFBRANCRIT . NAME , WFBRANCRIT . BRANCH_ID FROM SIEBEL . S_WFR_PROC WF , SIEBEL . S_WFR_STP WFSTEP , SIEBEL . S_WFR_STP_BRNCH WFSTPBRANCH , SIEBEL . S_WFR_PROC_FLOW WFSTEPCON , SIEBEL . S_WFR_COND_CRIT WFBRANCRIT WHERE WF . ROW_ID = WFSTEP . PROCESS_ID (+) AND WFSTEP . ROW_ID = WFSTPBRANCH . STEP_ID (+) AND WFSTPBRANCH . ROW_ID = WFSTEPCON . FOR_BRNCH_ID (+) AND WFSTPBRANCH...