Diagnose and Synchronize Application Data

Sometimes, inconsistency errors might occur in the application data. To resolve these errors, you can run the Diagnose and Synchronize Application Data scheduled process. Oracle Support might request you to run this process, or you can proactively run the process as needed.

Using this process, you can do these tasks.
  • Delete orphan rows in the base and translation tables
  • Reconcile GUID and clear the data security cache
  • Update the value set of empty flexfield segments
Run the Diagnose and Synchronize Application Data process from the Scheduled Processes work area.
  • From the Operation Type list, select the task.
    Note: Make sure to select an operation type, because if you leave it blank, the process might run into errors.
  • From the Action Type list, select the required option. You can choose to just view any inconsistency errors, or to view and fix the errors.
After the process is completed, you can check the log file of the process to see the details of any inconsistency errors.