EGL: What Are Some Recommendations For Correcting Journal vs. Ledger Integrity Problems (Journal vs Ledger Out of Sync) (Doc ID 607598.1)

Last updated on NOVEMBER 29, 2023

Applies to:

Goal

This document discusses some common scenarios on how to correct the problem of having the Ledger and journals out of sync?


This situation should not occur naturally but it may occurs sometimes due to the user error,  system bug, environmental issues(ie running out of tablespace, timeouts, power outages, network issues)

Since every integrity issue is unique to the customer and to the environment, It is recommended that you make a copy of the environment and test out any alternatives you identify for resolution and verify what options(as identified below or that you identify) works.

Once you test it out, you can follow the same steps in affected environment.

Solution

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