My Oracle Support Banner

Inconsistent Balances Scripts for Releases 10.7 - (Doc ID 101579.1)

Last updated on DECEMBER 23, 2021

Applies to:

Oracle General Ledger - Version to [Release 10.7 to 11.5.10]
Information in this document applies to any platform.


Scripts to identify inconsistencies in gl_balances or between gl_balances and gl_je_lines.

This bulletin could be useful when there are inconsistencies in balances for some accounts, customer can find inconsistency or corruption with information between two or more modules of the applications. For example, Account Analysis Report and Summary Trial Balance.

With this information it is possible to verify the inconsistency, the periods and sometimes the list of accounts involved.

Keep in mind that if there is one account with inconsistency is necessary to do a "balances rollback" or to use the Balances Corruption Datafix script (GLBALFIX).

Log a service request if these scripts show that there is an issue.

Versions Affected:

For R12 see Note:472159.1 R12: Scripts to Check Inconsistencies in GL_BALANCES

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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