Performance Issue when Closing Visits due to Poorly Designed START WITH - CONNECT BY PRIOR Statement
(Doc ID 1325026.1)
Last updated on APRIL 01, 2024
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.
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!