My Oracle Support Banner

Workflow Background Process Has Significant Performance Issues (Doc ID 566577.1)

Last updated on SEPTEMBER 17, 2020

Applies to:

Oracle Order Management - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

On 11.5.10 in Production:
Find that there is performance issue for Work flow Background Process in OE_INVOICE_WF.INVOICE_INTERFACE
and system appears to be doing full table scans on RA_CUSTOMER_TRX_LINES_ALL.
Recently upgraded from 11.5.9 to 11.5.10

EXPECTED BEHAVIOR
Expect the Work flow Background Process to complete in a minute. As of now it takes around 5 minutes to complete.

STEPS
The issue can be reproduced at will with the following steps:
1. Login as Order Management responsibility.
2. Run Workflow Background Process


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.