Assignment Manager Has No Values in Priority

Answer

Yes, you need to run the below scripts using a SQL tool. Create a back up of your database.

Steps to see the problem:

Go to Assignment Manager \Select Action \Set Preferences\Set Priority Preferences.

You will see an empty drop down window.

Script to run:

insert into pricalc
(findex, formula, selected, orgid, siteid, pricalcid)
select 0, 'NONE', 0, site.orgid, site.siteid, pricalcseq.nextval
from site
where not exists
(select findex,siteid from pricalc
where findex = 0 and siteid = site.siteid)
;
insert into pricalc
(findex, formula, selected, orgid, siteid, pricalcid)
select 1, 'PRIORITY', 1, site.orgid, site.siteid, pricalcseq.nextval
from site
where not exists
(select findex,siteid from pricalc
where findex = 1 and siteid = site.siteid)
;
insert into pricalc
(findex, formula, selected, orgid, siteid, pricalcid)
select 2, 'EQPRIORITY', 0, site.orgid, site.siteid, pricalcseq.nextval
from site
where not exists
(select findex,siteid from pricalc
where findex = 2 and siteid = site.siteid)
;
insert into pricalc
(findex, formula, selected, orgid, siteid, pricalcid)
select 3, 'PRIORITY + EQPRIORITY', 0, site.orgid, site.siteid,
pricalcseq.nextval
from site
where not exists
(select findex,siteid from pricalc
where findex = 3 and siteid = site.siteid)
;
insert into pricalc
(findex, formula, selected, orgid, siteid, pricalcid)
select 4, '2 * PRIORITY + EQPRIORITY', 0, site.orgid, site.siteid,
pricalcseq.nextval
from site
where not exists