Skip to main content
Kofax

MarkView Connector - Connector Triggers Not Optimized

MarkView Connector - Connector Triggers Not Optimized

 

Applies To

  • ERP System: Oracle
  • MarkView Version: MarkView 5.5 - 6.4

Behavior

Poor performance may be encountered when trying to import Connector items using the Oracle Payables Interface Import job. This happens because there are no functional indexes set for nvl, so a full scan is required. The three triggers are:
  1. MVCN_OA_AP_IMPORT_REJECTED_TR
  2. MVCN_OA_AP_IMPORT_KEYS_TR
  3. MVCN_OA_AP_IMPORT_PROCESSED_TR

Known Causes

The cause of this problem is nvl functions causing full table scans on the following tables:
  • AP_INVOICES_INTERFACE
  • AP_INVOICES_ALL

Resolution

The defect is no longer present in MarkView 6.5. For prior versions, the workaround for this issue is to disable the MVCN* version of the three triggers and add MVC* versions. Examples are attached in triggers.zip.
  1. MVC_OA_AP_IMPORT_REJECTED_TR
  2. MVC_OA_AP_IMPORT_KEYS_TR
  3. MVC_OA_AP_IMPORT_PROCESSED_TR
Kofax MarkView has seen that replacing the nvl function in the queries dropped the execution plan cost from 34k to 29 (not 29k, just 29). This in turn resulted in a dramatic improvement in the time the triggers took to import items from the invoice interface table.

 

Keywords: 6.1.3 6.x