MarkView Connector - Connector Triggers Not Optimized
- ERP System: Oracle
- MarkView Version: MarkView 5.5 - 6.4
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:
The cause of this problem is nvl functions causing full table scans on the following tables:
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.
Keywords: 6.1.3 6.x