Poor Performance Of Workflow Background Process For Item OEOL

(Doc ID 2268447.1)

Last updated on MAY 31, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms