AW_BULK_CHANGES does not populate the multi-select for module/chains.

Document ID : KB000090454
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
AW_BULK_CHANGES does not populate the multi-select for module/chains.
Resolution:
Detailed Description and Symptoms
There appears to be a problem with the data type "aw_modules_for_bulk_changes"

When requesting the aw_bulk_changes job/module if a prompt value is left blank the multi-select fields are not being populated. Looking at the RmiServer log, the subvar name(s) in the sql statement associated with the data type are being passed. For example the subvar name (#from_agent) is passed to the select statement rather than a null value, resulting in no rows returned.

Solution
Modified the sql statement associated with aw_modules_for_bulk_changes data type.

Open your Data Type Selector.  Edit the "aw_modules_for_bulk_changes".  Update the SQL with the information below.

select so_module,so_job_descr,a.so_application,aw_agent_name agent,b.so_queue,a.so_out_function OutPut_Function,c.so_printer,h.aw_notif_name notif,aw_scan_name scan,aw_envlst_name env_list
from aw_agent_agentgrp_view g,aw_notif h, aw_output_scan g, aw_env_lst f,so_user_table e,
aw_user_role_details d,so_printers c,so_queues b,so_job_table a
where a.so_application = nvl(decode('{#from_application}', '#from_application',null,'{#from_application}') ,a.so_application)
and nvl(h.aw_notif_name,'x') = nvl(nvl(decode('{#from_notif}','#from_notif',null,'{#from_notif}'),h.aw_notif_name),'x')
and h.aw_notif_seq(+) = a.so_notif_seq
and nvl(g.aw_scan_name,'x') = nvl(nvl(decode('{#from_scan}','#from_scan',null,'{#from_scan}'),g.aw_scan_name),'x')
and g.aw_scan_seq(+) = a.so_output_scan_seq
and nvl(f.aw_envlst_name,'x') = nvl(nvl(decode('{#from_envlst}', '#from_envlst', null,'{#from_envlst}'),f.aw_envlst_name),'x')
and f.aw_envlst_seq(+) = a.so_envlst_seq
and g.aw_agent_name = nvl(decode('{#from_agent}','#from_agent',null,'{#from_agent}'),g.aw_agent_name)
and nvl(g.aw_agent_seq,0) = nvl(a.so_oper_seq,0)
and b.so_queue = nvl(decode('{#from_queue}','#from_queue',null,'{#from_queue}'),b.so_queue)
and a.so_out_function = nvl(decode('{#from_output_function}','#from_output_function',null,'{#from_output_function}'),a.so_out_function)
and nvl(c.so_printer,'x') = nvl(nvl(decode('{#from_output_device}','#from_output_device',null,'{#from_output_device}') ,c.so_printer),'x')
and b.so_queue_seq = a.so_queue_seq
and c.so_printer_seq (+) = a.so_printer_seq
and d.aw_role_type in ('C', 'M')
and d.aw_user_seq = e.so_user_seq
and d.aw_obj_seq=a.so_job_seq
and d.aw_role_access='Y'
and d.aw_flag = 'Y'
and e.so_user_name = '{requestor}' order by 1