SSI - "Document associated with multiple ERP records" error occurs on Entry Complete action
- Self Service Invoice
- ERP System : Oracle
- MarkView Versions: 7.x
When taking the Non-PO Invoice Entry Complete action on an invoice created via SSI, the following error message is displayed: 'The Markview Document is associated with multiple ERP records. Taking the complete Entry action is not allowed.'
There is a conflict between the MarkView Document ID and the MarkView Folder ID: MarkView is trying to create a document with a document_id value that already exists as a folder_id value. There is a query in mverp_attach_util_ext.getAttachmentEntityCount that pulls up an attachment count based on this ID. If it finds more than 1 row returned it throws the error.
The error will no longer occur if the document_id value is greater than the highest folder_id, and the error only occurs on SSI documents. Therefore, the workaround is to create a non-SSI document, thus increasing the document_id sequence to a value higher than the folder_id sequence. Documents are created much more rapidly than folders, so the problem should not occur again later on.