Skip to main content
Kofax

Escalate document Increase Priority and Reassign document actions are not available for some document types

3019370

Question / Problem: 

For some document types the actions 'Escalate document', 'Increase Priority' and 'Reassign document' are not available out of the box, to enable them you need to create the join points manually.

Answer / Solution: 

1- To create the missing join point for AP CONNECTOR INVOICE EXCEPTION document type, execute the insert command below:

insert into mv_tool_join_point
  (join_point_id,
   tool_id,
   document_type_id,
   join_point_when,
   join_point_type,
   join_point_call,
   module_name)
  select mv_tool_join_point_seq.nextval,
         t.tool_id,
         (select document_type_id
            from mv_document_type
           where document_type_name = 'AP CONNECTOR INVOICE EXCEPTION'),
         tjp.join_point_when,
         tjp.join_point_type,
         tjp.join_point_call,
         'CUSTOM'
    from mv_tool_tab t, mv_document_type d, mv_tool_join_point tjp
   where d.document_type_name like 'PO INVOICE'
     and tjp.tool_id = t.tool_id
     and tjp.document_type_id = d.document_type_id
     and t.tool_name_unq in
         ('Escalate document', 'Increase Priority', 'Reassign document');

commit;

2- To create the missing join point for the SSI RENDERED INVOICE document type, execute the insert command below:

insert into mv_tool_join_point
  (join_point_id,
   tool_id,
   document_type_id,
   join_point_when,
   join_point_type,
   join_point_call,
   module_name)
  select mv_tool_join_point_seq.nextval,
         t.tool_id,,
         (select document_type_id
            from mv_document_type
           where document_type_name = 'SSI RENDERED INVOICE'),
         tjp.join_point_when,
         tjp.join_point_type,
         tjp.join_point_call,
         'CUSTOM'
    from mv_tool_tab t, mv_document_type d, mv_tool_join_point tjp
   where d.document_type_name like 'NON-PO INVOICE'
     and tjp.tool_id = t.tool_id
     and tjp.document_type_id = d.document_type_id
     and t.tool_name_unq in
         ('Escalate document', 'Increase Priority', 'Reassign document');

commit;

 

3- To create the missing join point for the PO OCR-INVOICE document type, execute the insert command below:

insert into mv_tool_join_point
  (join_point_id,
   tool_id,
   document_type_id,
   join_point_when,
   join_point_type,
   join_point_call,
   module_name)
  select mv_tool_join_point_seq.nextval,
         t.tool_id,
         (select document_type_id
            from mv_document_type
           where document_type_name = 'PO OCR-INVOICE'),
         tjp.join_point_when,
         tjp.join_point_type,
         tjp.join_point_call,
         'CUSTOM'
    from mv_tool_tab t, mv_document_type d, mv_tool_join_point tjp
   where d.document_type_name like 'PO INVOICE'
     and tjp.tool_id = t.tool_id
     and tjp.document_type_id = d.document_type_id
     and t.tool_name_unq in
         ('Escalate document', 'Increase Priority', 'Reassign document');

commit;

4- To create the missing join point for the NON-PO OCR-INVOICE document type, execute the insert command below:

insert into mv_tool_join_point
  (join_point_id,
   tool_id,
   document_type_id,
   join_point_when,
   join_point_type,
   join_point_call,
   module_name)
  select mv_tool_join_point_seq.nextval,
         t.tool_id,
         (select document_type_id
            from mv_document_type
           where document_type_name = 'NON-PO OCR-INVOICE'),
         tjp.join_point_when,
         tjp.join_point_type,
         tjp.join_point_call,
         'CUSTOM'
    from mv_tool_tab t, mv_document_type d, mv_tool_join_point tjp
   where d.document_type_name like 'PO INVOICE'
     and tjp.tool_id = t.tool_id
     and tjp.document_type_id = d.document_type_id
     and t.tool_name_unq in
         ('Escalate document', 'Increase Priority', 'Reassign document');

commit;

Applies to:  

Product Version
MarkView for Oracle Any