OSS-流程简述.docxVIP

OSS 流程简述1、CRM购物车下单SELECT DISTINCT ol.ol_nbr,bf.flow_inst_id 流程实例ID,op.redu_access_number 接入号FROM so.order_list olJOIN so.b2o_flowbus bf ON bf.ol_id=ol.ol_id –购物车和流程实例关系表JOIN so.busi_order bo ON bo.ol_id=bf.ol_id –购物车和业务动作JOIN d_order po ON po.bo_id=bo.bo_id –bo动作和产品JOIN inst.offer_prod op ON d_id=d_idWHERE ol.ol_nbr=’12201203260024653889′;2、调动流程总线启动流程select * from WF_MESSAGE_RECEIVE_EVENT WF WHERE WF.RECEIVE_DATE betweento_date(’2012/02/08 00:00:00′, ‘yyyy/mm/dd hh24:mi:ss’) andto_date(’2012/02/09 00:00:00′, ‘yyyy/mm/dd hh24:mi:ss’);3、流程总线返回流程实例ID(CRM记录下来)select f.*from so.order_list oljoin so.b2o_flowbus f on f.ol_id = ol.ol_idwhere –ol.ol_nbr = ’12201202080024642764′ f.flow_inst_id=3095734、流程总线向OD派单 ，OD落地消息，并生成环节单，用MQ消息放到MQ队列补充：OD去取MQ消息，放到事件表WF_EVENT_OD表中。—MQ落地表SELECT a.flow_id,a.event_id FROM wf_event_od a WHERE a.flow_id=319170 –OD环节消息接收事件UNIONSELECT b.flow_id,b.event_id FROM his_wf_event_od b WHERE b.flow_id=319170;—侦听MQ落地表，生成环节单SELECT * FROM srv_tache_order a WHERE a.flow_id=319170; —主表SELECT * FROM srv_crm_tache_order a WHERE a.to_id=12000000004725; —CRM受理环节单 从表，这个里面包含了CRM送来的购物车报文—购物车id查PSO_IDSELECT * /*distinct(B2P.PSO_ID)*/ FROM SRV_B2O_BUSI_ORDER_2_PSO B2P WHERE B2P.ACTION_ID IN(SELECT B2O.ACTION_ID FROM SRV_B2O_BUSI_ORDER B2O WHERE B2O.TO_ID IN(select ss.to_id from SRV_CRM_TACHE_ORDER ss where ss.ol_nbr =’12201203060024648437′));5、OD根据流程实例ID 通过数据总线到crm取购物车报文 （问题一：CRM送的内容不对，修改报文继续走下去6、OD定单分解短流程实例id查PSO_IDSELECT distinct(B2P.PSO_ID) FROM SRV_B2O_BUSI_ORDER_2_PSO B2P WHERE B2P.ACTION_ID IN(SELECT B2O.ACTION_ID FROM SRV_B2O_BUSI_ORDER B2O WHERE B2O.TO_ID IN(SELECT O.TO_ID FROM SRV_TACHE_ORDER O WHERE O.FLOW_ID = 123357));环节单拆分、合单、压单（OD，生成以产品服务、产品服务定单为粒度的定单，产品服务定单生成资源变更单——涉及到的表select * from srv_b2o_busi_order; ——–购物车照业务动作拆分select * from srv_prod_serv; ——–产品服务定单（业务动作合并成产品服务)——合并基本思路为同产品、同购物 车、同一开通时间的业务动作进行合单，产品服务和能力、资源服务关联select * from srv_prod_serv_order; ——–产品服务定单，和产品服务在同一事务中生成，轻载，数据放在产品服务中select* from srv_res_order; ——–资源变更单，开通、工程所有需求都转化成同构的资源变更单select *from