7.5.2 Running CTR Scenarios for a GTO

To run CTR scenarios which consider the GTO, follow these steps:

1. Create a new scenario threshold set that meets the reporting criteria required by the GTO using the Scenario Threshold Editor. For more information, see Chapter 3, Scenario Threshold Editor, in the Admin Tools User Guide.
2. Run the following query, then commit the transaction.

   select 'insert into kdd_job_template values ('||kdd_job.job_id||', '||kdd_pttrn.scnro_id||');' QUERY
   from kdd_param_binding, kdd_job, kdd_pttrn, kdd_job_template, kdd_param_set, kdd_centricity,
    
   kdd_scnro
   where kdd_param_binding.param_set_id = kdd_job.param_set_id
   and kdd_param_binding.param_set_id = kdd_param_set.param_set_id and kdd_scnro.cntry_id = kdd_centricity.cntry_id
   and kdd_pttrn.scnro_id = kdd_scnro.scnro_id and kdd_job.status_cd = 'IGN'
   and kdd_param_binding.param_nm = 'pattern' and kdd_param_binding.param_value_tx like
   '%' || kdd_pttrn.pttrn_id || '%'
   and kdd_job.job_id = kdd_job_template.job_id(+) and kdd_scnro.scnro_id = '&ScenarioID'
   and kdd_job_template.template_group_id IS NULL
   order by kdd_pttrn.scnro_id, kdd_pttrn.pttrn_id, kdd_job.job_id;
   

3. Select the scenario and the GTO threshold set you have created to execute the scenario.
4. Click Test to implement the test run for the GTO version of this scenario.
5. Verify the details are correct in the Scenario Test Execution pop-up window. Click Run. The scenario runs.
6. Verify the alerts were generated under the GTO threshold set by executing the following query:

   select r.review_id, r.creat_ts, r.scnro_id, b.tshld_set_id, t.tshld_set_nm
   from kdd_review r
   inner join kdd_break b on r.review_id = b.prnt_break_id inner join kdd_tshld_set t on b.tshld_set_id = t.tshld_set_id where r.scnro_id = '&ScenarioID'
   and r.creat_ts = to_date('MM/DD/YYYY', 'MM/DD/YYYY');