Workflow Background Engine Poor Performance During Invoice Interface
(Doc ID 1337496.1)
Last updated on AUGUST 28, 2023
Applies to:
Oracle Order Management - Version 12.0.6 and laterOracle Receivables - Version 12.0.6 and later
Information in this document applies to any platform.
Symptoms
The performance of the Workflow Background Process is unacceptable.
It is taking hours to complete and business requires that it should complete in minutes.
Tkprof shows the following costliest queries:
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 954 0.01 0.01 0 0 0 0
Execute 954 25.41 555.86 1564861 21257231 297 953
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1908 25.43 555.87 1564861 21257231 297 953
Changes
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 |
| Changes |
| Cause |
| Solution |