MarkView Connector - How to Find the Uploaded and Transformed XML for an Invoice

Applies To

• MarkView Connector: All Versions
• MarkView Version: MarkView 5.5 and Higher

Problem

It is sometimes necessary to determine what XML data was passed into MarkView Connector from the OCR system, and to determine what XML data was produced by the transform process that occurs during the creation of the MarkView Connector Import workitem. In order to do this you must have the file_id property from the Import Workitem's Workitem History output. You can then plug it into the following query in order to get the XML output:

SQL> select file_name, file_location, dbms_lob.substr(uploaded_xml, 4000, 1), dbms_lob.substr(transformed_xml, 4000, 1) from mvcn_file where file_id = &fileID;