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