My Oracle Support Banner

Poor Performance Of Workflow Background Process For Item OEOL (Doc ID 2268447.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Transaction Control

ACTUAL BEHAVIOR
---------------
GCR: Poor performance of Workflow background process for item OEOL

Workflow Background process takes 11 hours to process 217752 OEOL records where as it completes in 45 minutes for 231004 OEOH records

EXPECTED BEHAVIOR
-----------------------
Expect background processing to complete in a timely manner

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Import 200k orders with 1.4 million lines.
2. WFBG does not complete for these lines to close.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, performance testing cannot be completed

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.