Skip to main content
Kofax

MarkView Oracle Integration - Receiving error message: "MarkView document associated with multiple ERP records. Placing the Entry complete is not allowed."

Summary

4016

Applies To

  • ERP System: Oracle
  • MarkView Version: All

Behavior

Invoice Entry users receive the following message when an AP clerk is trying to place a ENTRY COMPLETE markup:
    This MarkView document associated with multiple ERP records. Placing the Entry complete is not allowed

Known Causes

  • The Markview document for which you are attempting to place the Entry Complete markup has been attached to multiple Oracle records. The Entry Complete markup can only be placed if it has been attache record. Please run the following query which will prompt for the MarkView DocumentID to find the attachment records associated with the MarkView Document.
    select *
        from fnd_documents_vl dvl, fnd_attached_documents ad, ap_invoices_all aia
    where to_char(aia.invoice_id) = pk1_value
        and ad.document_id = dvl.document_id
        and dvl.file_name = '&MVDocumentID';

Resolution

  • You can identify InvoiceID property for this Document/WorkItem using SQL*Flow Monitor (under the Properties tab). Once you have identified the InvoiceID property, you s following two steps:
    • Cancel the invoice in the ERP system
    • Recycle the Markview document
    • Re-enter the document and invoice

Keywords: multiple, erp, attachment