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

Last updated
Save as PDF

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