Skip to main content
Kofax

Escalate Document Increase Priority and Reassign Document actions not Available for Some Document Types

Article # 3019370 - Page views: 140

3019370

Problem: 

For some document types, the following actions are not available out of the box:

  • Escalate Document
  • Increase Priority 
  • Reassign Document 

 

Note: These tools are part of the Action Tools toolset related to the Actions Manager user group. 

 

 

Solution: 

You must create the join points manually to enable them.

 

1) To create the missing join point for the 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