QuickStart steps#

Taking WorkFlow out of commission#

-- Cancel pending Workflows
update p2k_am_work_flow_logs 
   set action_completion_date = trunc(sysdate)
     , action_status = '03'  -- canceled
where action_completion_date is null;

-- Set Emails to be clear that they are from QuickStart

update p2k_am_work_flow_actions
   set description = substr(description,1,32)||'-->From QUICKSTART'
where event_media = '07';

-- Take all WF user calcs out of production

update p2k_am_user_calcs 
   set user_calc_status = '00'
 where mpd_id in (select ID from p2k_am_products where product_code like 'WF%');

Customizing #

IMMS: update SS_LOGIN_EN_0 for self service login identification

IMST: update Logo and Site Description

HighLine.Standard Operating Procedures