Skip to main content
Kofax

MarkView OCR Invoice - Error when attempting to re-create an AP invoice document as an OCR Invoice Document. - MarkView

4186

MarkView OCR Invoice - Error when attempting to re-create an AP invoice document as an OCR Invoice Document. - MarkView

 

Applies To

  • ERP System: Oracle, SAP
  • MarkView Version: MarkView 5.5 - 7.x

Behavior

  • The MarkView Process Manager fails with the following error if you categorize a document as a OCR Invoice Document:

08/14/2007 12:24:09: EventOccurrenceID: 8416

08/14/2007 12:24:09: EventTypeID: 122
08/14/2007 12:24:09: WorkItemInstanceID:
08/14/2007 12:24:09: EventName: MVCNEntityCreated
08/14/2007 12:24:09: AlertingUserID: SQLFLOW
08/14/2007 12:24:09: PropertyTypes:3
08/14/2007 12:24:09: 182
08/14/2007 12:24:09: 183
08/14/2007 12:24:09: 184
08/14/2007 12:24:09: PropertyValues:3
08/14/2007 12:24:09: 341
08/14/2007 12:24:09: 1222
08/14/2007 12:24:09: Connector Entity (OA AP)
08/14/2007 12:24:09: Firing Rule Instance: 505
08/14/2007 12:24:09: Encountered the following error while firing rule (rule instance id = 505):
08/14/2007 12:24:09: ORA-01403: no data found
ORA-20001: No rows in MV_PAGE table for document_id

Known Causes

  • The root cause is the fact that these documents are created without a batch number.  This is reported in SPR00063010, which was originally seen in MV 5.10.  A workaround was identified and the defect was not fixed in product code.

Resolution

  • The workaround is to modify MVT_DOCUMENT_CAPTURE_CUSTOM.PostCreateDocument to set a batch number.

    For example:

      if BatchNumber is null then
        insert into mv_batch
          (batch_number, batch_description, scan_timestamp)
        values
          (MV_BATCH_NUMBER_SEQ.nextval, 'MVCN Batch', sysdate);
      
        update mv_document
           set batch_number = MV_BATCH_NUMBER_SEQ.currval
         where document_id = DocumentID;
      end if;

 


Revision History

27 AUG 2012 Reformatted


 

Keywords: 25581, SPR00063010