My Oracle Support Banner

When to Use the GL Balances Corruption Fix Script GLBALFIX (Doc ID 387775.1)

Last updated on NOVEMBER 28, 2023

Applies to:

Oracle General Ledger - Version and later
Information in this document applies to any platform.
GLBALFIX - GL Balances Corruption Fix Script


When To Use The GL Balances Corruption Fix Script GLBALFIX.

The GL Balances Corruption Fix script was created by development to allow customers to safely detect and/or fix corrupt actual balance data in their gl_balances table.

This uses the data in the posted journal lines to rebuild the balances with the correct amounts, therefore this is only to be used when the posted journal lines are correct and accurate.

There are three versions of the script available.

The script is not intended to diagnose the cause of the corruption. Root cause analysis should be done prior to running this script or take a backup of gl_balances to enable root cause analysis to be done after running the script.


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
 1. What the script will fix
 2. What to check before running this script
 3. Actions to take prior to running the script
 4. Limitations and Warnings
 5. Upgrades
 6. How to install GLBALFIX?
 7. What to do if there are errors ?
 8. How to Uninstall GLBALFIX ?
 Still Have Questions?

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