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

Keywords: 25581, SPR00063010