Performance Issues While Searching On Discrepancy Review List And Doing Detail Matching (Doc ID 3038581.1)

Last updated on JULY 31, 2024

Applies to:

Symptoms

Performance issues while searching on Discrepancy Review list and doing Detail Matching

We are having performance issues while searching on Discrepancy Review list and doing Detail Matching.

There are users that report that even after 10-15 minutes, they don't get any data and lose the connection.


ERROR
-----------------------
ADF_FACES-30200:For more information, please see the server's error log for an entry beginning with: The UIViewRoot is null. Fatal exception during PhaseId: RESTORE_VIEW 1..




STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Go to the Discrepancy Review list screen
2. Try searching with 1000 location filter
3. Wait until results appear (sometimes it takes more than 10m and loses connection)
4. If results appear, try to do detail match
5. It also takes too much time and loses connection, giving an error after


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot able to searching on Discrepancy Review list and do Detail Matching

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.