Hata Mesajının Kullanıldığı RuleSet'i & ActionSet'i bulma

 

Data Validation Mantığı,

- Sarı ile highlight edilmiş kısıma hata mesajı yazıp aratılır. (lang_id'ye dikkat edilmeli, hata mesajı hangi dilde ise burası güncellenmeli)

SELECT e.obj_type_cd AS object_type, e.obj_name AS object_name,

       e.evt_name AS event, e.evt_sub_name AS sub_event,

       e.actn_cond_expr AS conditional_expr, s.NAME AS action_set,

       a.NAME AS action, rs.NAME AS rule_set, r.NAME AS RULE, l.msg_text

  FROM siebel.S_CT_ACTION_SET s,

        siebel.S_CT_ACTION a,

        siebel.S_VALDN_RL_SET rs,

        siebel.S_VALDN_RULE r,

        siebel.S_ISS_VALDN_MSG m,

        siebel.S_ISS_VMSG_LANG l,

        siebel.S_CT_EVENT e

WHERE a.ct_actn_set_id = s.row_id

   AND a.svc_context LIKE

                     '"Rule Set Name", "' || rs.NAME || '", "Enable Log", "%"'

   AND rs.status_cd = 'Active'

   AND r.rule_set_id = rs.row_id

   AND r.valdn_msg_id = m.row_id

   AND l.par_row_id = m.row_id

   AND e.ct_actn_set_id = s.row_id

   AND l.lang_id = 'ENU'

 AND L.MSG_TEXT like '%For a Potential or Inactive Account Status this Service Request is not allowed%'

-       Çıkan sonuçtaki rule set ve rule u user interfacete data validation – rule sets te arat.