Oracle R12 Patching May Cause a Large Number of InvoicePaid Events to be Alerted

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

• When patch # 14040540 is installed, all entries in the AP_INVOICES_ALL table are updated.
• When this table is updated, the MVOA_AP_INV_UPD_TR trigger alerts an InvoicePaid event for every invoice where the PaymentStatus = 'Y' (Yes).

Resolution

• To prevent this problem from occurring, the following steps should be followed during the installation of Oracle patch # 14040540:
  1. Disable the MVOA_AP_INV_UPD_TR trigger
  2. Install Oracle patch # 14040540 (If you are upgrading from Oracle 11i to R12 you can disable the trigger, complete the upgrade and then re-enable the trigger.)
  3. Re-enable the MVOA_AP_INV_UPD_TR trigger

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