MarkView Expense Management - performance issue with Expense cover page generation

Applies To

• ERP System: Oracle
• MarkView Version: 6.1 and earlier.

Behavior

A performance issue is encountered during the creation of The Internet Expenses packets cover page.

Known Causes

A known cause is due to the composition of the query used to generate the expense cover page.

Resolution

• The query to generate a cover page can be modified via MarkView Module Admin. From MarkView Home, navigate to Administration> Module Admin> Cover Page LOV > Update option for ReportNumber lov.
  Change ReportNumber LOV from

select aerha.invoice_num, to_char(aerha.report_header_id) from ap_expense_report_headers_all aerha where ( (:DescriptionSearchString is not null AND aerha.invoice_num LIKE :DescriptionSearchString) OR (:DescriptionSearchString is null) ) and ( (:ActualValueSearchString is not null AND aerha.report_header_id LIKE :ActualValueSearchString) OR (:ActualValueSearchString is null) ) order by aerha.invoice_num

To:

select aerha.invoice_num, to_char(aerha.report_header_id) from ap_expense_report_headers_all aerha where ( (:DescriptionSearchString is not null AND aerha.invoice_num = :DescriptionSearchString) OR (:DescriptionSearchString is null) )

and ( (:ActualValueSearchString is not null AND aerha.report_header_id = :ActualValueSearchString) OR (:ActualValueSearchString is null)
) order by aerha.invoice_num

Keywords: MV EM, MVOA