Thursday Jul 02, 2015

General Ledger Balances Corruption - Causes, Suggestions, Solutions

Finding correct and accurate balances in General Ledger(GL) at the end of each period and year is one of the main targets for the functional applications users and accounting departments. The GL balances are considered base for reporting purposes and also important to reveal the results and current position of the company based on the accomplishments and changes reflected by the accounts through balances. It is important to be able to rely on the trial balance reports.

What if the balances get corrupted? 

In the last months our Developers worked close with General Ledger Support team and reviewed all the balances corruption cases reported by customers, preparing a complex document to reflect their findings: 

  • Potential Causes identified
  • Solutions for each potential cause that could lead to corruption
  • Suggestions to prevent such corruptions from happening

Do review this document we have prepared for you - it will help prevent potential corruptions, allowing the users to focus on period closure activities and report on the balances without delays: 

General Ledger Balances Corruption - Causes, Solutions and Suggestions. (Doc ID 1995324.1

Tuesday Mar 31, 2015

Balances Corruption Fix Script (GLBALFIX) Now Available for Parameters Including Special Characters

General Ledger Balances Corruption Fix script -known as GLBALFIX- was provided by Development to help safely detect or fix corrupted actual balances. This script basically rebuilds the balances based on the posted journal lines.

We have briefly presented the script to customers in a previous blog article which is still available here

This easy-to-use script could not be used for cases where the input parameters such as ledgers or calendar periods included special characters (arabic, german, polish and so on).

New version available!

Development recently released a new version of GLBALFIX script which will addres special characters cases

Did you have this concern before?

Just check: GLBALFIX errors when Input Parameters Contain Special Characters (Doc ID 1958420.1)

Do you suspect balances corruption? Do not hesitate, get help today!

Monday Mar 24, 2014

Get Help to Verify Your General Ledger Balances Anytime!

General ledger is the core of accounting information summarizing all financial transactions into accounts and gathering all data into balances that will be used to prepare financial statements or for various other reporting purposes. 

  • Maintaining correct balances is crucial for reporting purposes
  • Financial users may want to verify balances periodically to make sure they are accurate 

In order to gather information needed for analyzing problems related to General Ledger balances, in addition to the usual period closure activities such as running specific diagnostics from Doc ID 1416402.1 that would spot balances issues, you should also consider our Glbalfix - Gl Balances Corruption Script.

We have gathered all the useful information related to Glbalfix script, from installation to detailing all checks performed, preparation and execution along with potential errors and suggestions to spot and eliminate the root cause prior to performing any fix, in this new document:

Glbalfix: GL Balances Corruption Script - Master Note (Doc ID 1563019.2).

Once installed, the script can be safely submitted to run anytime in report mode, to verify the balances only - here's a sample output:

Glbalfix output sample

Remember, running the script does not mean it would change any data, you can use it just to verify the balances are correct! If a problem is detected, you decide further if and when to fix it!

Why don't you give Glbalfix a try?


About

Welcome to the EBS Support Blog where Oracle insiders share news and information about EBS products including new releases, tips and tricks, troubleshooting guides, upcoming webcasts and links to EBS Communities.

Stay Connected

Twitter

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today