Skip to main content
Kofax

MarkView All Components – Web Inbox with large number of invoices causes errors or items disappear.

Summary

11919

Applies To

  • ERP System: All
  • MarkView Version: All

Behavior

  • After approving a number of invoices (normally between 10 and 20) the remaining invoices disappear from the Web Inbox; and re-appear on the following day.
  • When approving invoices 1 at a time, the following message appears error across the top of the page.
    mvt_web_display_ul.GetMainDataRecords : ORA-06502: PL/SQL: numeric or value error: character string buffer too small.

Known Causes

  • End Users with large number of items in the Web Inbox are affected; normally in excess of 100 or 120 items.

Resolution

The MVT_WEB_RECS_PER_PAGE preference can be used to limit the number of items per page in the Web Inbox. Once the MVT_WEB_RECS_PER_PAGE preference is set to an appropriate value, the issue will no longer occur. The MVT_WEB_RECS_PER_PAGE preference can be set at User or System level; as the issue is likely to only affect a very limited number of users it is recommended to set the preference at User level.

  • Please add the MVT_WEB_RECS_PER_PAGE preference at User level to each of the affected users.
    • On MarkView Home -> Administration -> MarkView Admin -> Details (next to the User ID) -> User Preference (tab)
    • Then add the MVT_WEB_RECS_PER_PAGE preference and set the value to the number of items you wish the page to display – i.e. 30.

Keywords: Webinbox, wib, working folder, MVT_WEB_RECS_PER_PAGE