Do you have any corruption in GL Balances? GLBALFIX script is here to help you.
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.
1) The original version which works for version 11.5.1 through 11.5.10 CU2 of applications.
2) A version that will work on release 11.5.1 to 11.5.10 CU2 for both standard and Average Daily balances.
3) A release 12 version for both standard and Average Daily balances, that will work for releases R12.0, R12.1 and R12.2.