My Oracle Support Banner

Performance Issue when Closing Visits due to Poorly Designed START WITH - CONNECT BY PRIOR Statement (Doc ID 1325026.1)

Last updated on AUGUST 24, 2020

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Serious performance issue found during visit closure in CMRO Application. The Close Visit option takes more than 6 minutes even for small Visits (e.g. having only 8 work orders).

EXPECTED BEHAVIOR
-----------------------
The process should complete within 10 seconds.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to CMRO Superuser responsibility
2. Navigate to (N) Execution -> Production Planning -> Visits
3. Search for a Visit
4. Select Close Visit option and click 'Go'.
5. The visit closing takes more than 6minutes.

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
 Community Discussions
References


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