Skip to main content
Kofax

MarkView Oracle Integration - Oracle R12 Patch # 14040540 (formerly #9076040) causes a large number of InvoicePaid events to be alerted.

Summary

4861

Applies To

  • ERP System: Oracle R12
  • MarkView Version: 6.4 and higher

Behavior

  • After installing Oracle patch # 14040540, large numbers of InvoicePaid events are alerted, resulting in a build up of events in the SF_EVENT_ALERT table.
  • This results in significant resource usage to process the added events.
Note: If you are upgrading from Oracle 11i to Oracle R12 this patch is applied.

Known Causes

Resolution

As Oracle patch # 14040540 is updating the total tax amount on the invoice header for upgraded invoices, it is not affecting the payment status itself. Since the payment status is not changing there is no need for the InvoicePaid event to be alerted, thus we can temporarily disable the trigger while the patch is applied.

Note: Oracle patch numbers may change. Refer to Oracle Note 972143.1 which will always have the latest patch number. The patch number was formerly # 9076040.
Please note Kofax's recommendations for applying patches - Please see Article Number 000003935 — Kofax Recommendations and Best Practices for Applying Patches; Upgrades and Updates - and ensure that the installation of a patch is thoroughly tested in a Non-Production environment before deploying the patch to a Production environment.

Keywords: 9076040 9076040