MarkView Viewer - Long delay when placing Entry Complete Markup
4136
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