My Oracle Support Banner

E-PIA: "Data Integrity(124,85) Error" When Clicking On "Return To Search" Button After Selecting The "Clear" Button On The Configurable Search Page (Doc ID 2971910.1)

Last updated on OCTOBER 18, 2023

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.60 and later
Information in this document applies to any platform.


Below error shows up when clicking on "Return to Search" button after selecting the "Clear" button on the Configurable Search page.


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.


This issue can be replicated at will using the below steps:

Below is the navigation from HCM environment.

  1. Navigate to Workforce Administration > Job Information > Review Job Information > Workforce Job Summary
  2. Select any employee id (e.g. AA0001)
  3. Click on Search.
  4. From the search results click on that employee id.
  5. Now click on return to search
  6. Click the "Clear" button
  7. Now again repeat the above process till "Return To Search".

    It throws below error



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

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