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

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