Skip to main content
Kofax

MarkView Viewer - Long delay when placing Entry Complete Markup

Summary

4136

Applies To

  • ERP System: Oracle, SAP, Peoplesoft
  • MarkView Version: 6.x and earlier.

Behavior

  • Why is there a long delay after selecting the Entry Complete Markup, before the form appears?

Known Causes

  • The Entry Complete markup can take a minute or more to appear because MarkView is doing a full table scan on the FND_DOCUMENTS_TL table. Other markups perform at a normal speed because they do not scan this table.
  • This has been identified as Defect # SPR00082236 and can affect MarkView versions prior to the 5.10.4 patchset.
  • It has been found that this issue can also affect MarkView 6.x (Defect # SPR00063348).

Resolution

  • For MarkView 5.5 environments, the recommended solution is to install the 5.10.4 patchset. Please note that patchsets 5.10.1, 5.10.2, and 5.10.3 must be installed as a pre-requisite for the 5.10.4 patchset.
  • For MarkView environments prior to 5.10.4, the recommended solution is to create an index on FND_DOCUMENTS_TL, by running the attached mvoa_fnd_doc_tl_file_name_ndx.sql in the MARKVIEW schema.
  • This script will prompt for some sizing parameters.
    The recommended values for these are as follows:
    • MV_LRG_NDX_INIT 256M
    • MV_LRG_NDX_NEXT 256M
    • MV_LRG_NDX_PCT 0
  • For MarkView 6.x, the recommended solution is the same as above, i.e. to create an index on FND_DOCUMENTS_TL, by running the attached mvoa_fnd_doc_tl_file_name_ndx.sql in the MARKVIEW schema.
    The recommended sizing parameter values for these are as follows:
    • MV_LRG_NDX_INIT 512M
    • MV_LRG_NDX_NEXT 512M
    • MV_LRG_NDX_PCT 0

Keywords: mark up, mark-up