E-TR: “Data Integrity Error (124,85)" After Click On "Recent Search Results" Button In Tree Manager (Doc ID 1620282.1)

Last updated on JULY 15, 2023

Applies to:

Symptoms

When attempting to use the “recent search results” lookup that appears near the Tree Manager menu in the navigation bar and then click on any tree node in the Tree Manager maintain page the following error occurs:

“Data Integrity Error (124,85)

The data structure from the page does not match the data structure in the database. This can be caused by a change in the record definition while you were viewing the page. This is a non-recoverable error and the current transaction will be aborted.”

Steps
-------
The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Tree Manager > Tree Manager
3. Search by DEPT_SECURITY tree name
4. Select DEPT_SECURITY tree with SHARE SETID
5. Enter Tree Manager maintain page after chosen SHARE SETID
6. Click on the “Magnifying Glass” icon (“Recent Search Results”), right after “Tree Manager” menu item (click on Recent Search Results icon that appears on the navigation bar)
7. A “Recent Search Results” page popup. And pick up another tree DEPT_SECURITY tree with BNUSA SETID.
8. The new tree is displayed
9. Then click on any tree node, the error message occurs

Cause

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