Circuit Reconciliation and Equipment Specification Edit/Update Issues - Performance Related (Doc ID 2187547.1)

Last updated on OCTOBER 18, 2023

Applies to:

Symptoms

Problem Statement
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Circuit reconciliation and equipment update issues

Circuit reconciliation is very slow and very often it crashes. Here are some examples what happens here -

1) We updated FDP spec to increase ports from 48 to 96 to show both front and back panels that effected 44 pieces of equipment.  User never receives pop-up window indicating the number of affected circuits.  Approximately one hour later around users receives an error stating a database error occurred and with prompted options to "Abort", "Retry", "Ignore".  Selecting "Retry" keeps the user's session logged on.

2) The same behavior occurs when attempting to update an LC bulkhead spec which affects over 800 pieces of equipment.  The application never displayed the window indicating the number of affected circuits or the option to send it to the Background Processor.
 
Commonly received error during the problem:

Expected Behavior
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
After changes in the Equipment Specifications should trigger Circuit Reconciliation

Steps
¯¯¯¯¯
The issue can be reproduced at will with the following steps:

1. Open Equipment Specifications for Spec LC-BULKHEAD

2. Make a change that reflects in the circuits: ACRONYM: LC_BH-1 to LC_BH-1X and Save changes

3. Reconciliation informing number of affected circuits is not being displayed even after a long time in the process

4. In some instances a database error is thrown prompting to Abort, Retry, Ignore.

Business Impact
¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Users are unable to make changes to the Specifications which are then reflected on the affected circuits.

Changes

Cause

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