Siebel SQLs/Error Messages > Check if all Workflows are correctly set up
Every Active Workflow needs to have Policies and arguments. If
these are missing, then we need to correct this.
It is quite hard to check every Workflow from the GUI.
Here is an sql that will display results for all workflows.
This was Tested in Oracle 11g.
SELECT distinct
pol.name "Policy Name",
acdeg.NAME "Policy Action",
arg.name,
arg.default_value
FROM siebel.s_escl_rule pol,
siebel.s_escl_cond con,
siebel.s_escl_link_col COL,
siebel.s_escl_col escol,
siebel.S_ESCL_ACTION ac,
siebel.S_ACTION_DEFN acdeg,
siebel.S_ACTION_ARG arg
WHERE pol.expire_dt IS NULL
AND pol.row_id = con.rule_id
AND escol.name = con.link_col_name
AND COL.cond_col_id = escol.row_id
and ac.ACTION_ID = acdeg.row_id(+)
and pol.row_id = ac.RULE_ID(+)
and acdeg.row_id = arg.ACTION_ID(+)
and (pol.expire_dt is null or pol.expire_dt > sysdate)
order by pol.name;
|