MarkView Expense Management - Expense Report Receipts are not recognized and directed to the Manual Review Queue.

Applies To

• ERP System: Oracle
• MarkView Version: All.

Behavior

Expense report recipts are not recognized and are directed to the Manual Review queue for categorization.

Known Causes

The barcode being orientated horizontally is a known cause of low recognition rates.

Resolution

• A significant improvement can be made to recognition rates by changing the orientation of the barcode from horizontal to vertical on the expense report cover page. For customers using the MarkView Expense Management module, the following code change to the MVOA_OIE_CUSTOM package body can be implemented to achive this.

Replace:

l_html_text := '<table><tr><td align=CENTER><img src="' ;
        l_html_text := l_html_text || MVOA_OIE_Util.GetPreferenceValue('MVAS_BCG_BASE_URL',user);
        l_html_text := l_html_text || '?text=' || l_barcode_string;

if barcode_format is not null then
    l_html_text := l_html_text || chr(38) || 'bar_format=' || barcode_format;
end if;
if bar_width is not null then
    l_html_text := l_html_text || chr(38) || 'bar_width=' || bar_width;
end if;
if include_checksum is not null then
    l_html_text := l_html_text || chr(38) || 'checksum=' || include_checksum;
end if;
if include_caption is not null then
    l_html_text := l_html_text || chr(38) || 'caption=' || include_caption;
end if;

l_html_text := l_html_text || chr(38) || 'x_offset=' || '1';
l_html_text := l_html_text || chr(38) || 'y_offset=' || '1';
l_html_text := l_html_text || '"';
l_html_text := l_html_text || ' alt="Barcode could not be generated" ';
l_html_text := l_html_text || ' border="0"></td></tr>';
l_html_text := l_html_text || '<tr><td align=LEFT><font size=2>';

-- loop through instructions and add to text
for instruction_rec in instruction_cur loop
    l_html_text := l_html_text || replace(MVOA_OIE_Util.GetPreferenceValue(instruction_rec.preference_name,user), '<OIE_EXPENSES_FAX_NUMBER>',l_fax_number) || '<BR>';
end loop;
l_html_text := l_html_text || '</font></td></tr></table>';

With:

l_html_text := '<table><tr><td align=LEFT><font size=2>';
        -- loop through instructions and add to text
    for instruction_rec in instruction_cur loop
        l_html_text := l_html_text || replace(MVOA_OIE_Util.GetPreferenceValue(instruction_rec.preference_name,user), '<OIE_EXPENSES_FAX_NUMBER>',l_fax_number) || '<BR>';
    end loop;
    l_html_text := l_html_text || '</font></td>';
 
l_html_text := l_html_text || '<td align=RIGHT><img src="' ;
l_html_text := l_html_text || MVOA_OIE_Util.GetPreferenceValue('MVAS_BCG_BASE_URL',user);
    l_html_text := l_html_text || '?text=' || l_barcode_string;
l_html_text := l_html_text || chr(38) || 'orientation=' || 'v';

if barcode_format is not null then
    l_html_text := l_html_text || chr(38) || 'bar_format=' || barcode_format;
end if;
if bar_width is not null then
    l_html_text := l_html_text || chr(38) || 'bar_width=' || bar_width;
end if;
if include_checksum is not null then
    l_html_text := l_html_text || chr(38) || 'checksum=' || include_checksum;
end if;
if include_caption is not null then
    l_html_text := l_html_text || chr(38) || 'caption=' || include_caption;
end if;

l_html_text := l_html_text || chr(38) || 'x_offset=' || '1';
l_html_text := l_html_text || chr(38) || 'y_offset=' || '1';
l_html_text := l_html_text || '"';
l_html_text := l_html_text || ' alt="Barcode could not be generated" ';
l_html_text := l_html_text || ' border="0"></td></tr></table>';

Note: The attached MVOA_OIE_CUSTOM.pck and MVOA_OIE_CUSTOM-modified.pck files show the MVOA_OIE_CUSTOM package body before and after the specified changes.

It is the recommended policy of Kofax, Inc. that all system changes be applied in the customer's test environment and tested thoroughly before being migrated to a production environment.

Keywords: recognition, barcode, bar code