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!

Friday Mar 28, 2014

Using Additional Currencies for Reporting Purposes in General Ledger

The need to report in additional currencies may occur at any time to satisfy legal, statutory or management supplementary reporting requirements. This is also a good option to be considered if you operate in countries with highly inflationary economies.

In General Ledger this can be accomplished using

  • Reporting Currencies - where the need is to simply maintain transactions in multiple currencies
  • Secondary Ledgers - where the main purpose is to represent transactions in a different accounting method, calendar, currency, chart of accounts

You may configure any of these setup alternatives to comply with your Generally Accepted Accounting Principles circumstances.

Add Secondary Ledger, Why The Primary Ledger is in Use?


But what if the business requirement comes after your Primary Ledger is already in use?

What would be the impact of such setup changes?

Would this change be permitted? 

The answer is Yes!

We Can accommodate such a change, find out How in

Impact of Newly Added Alternate Ledger Currency(ALC)/Secondary Ledger in Release12 (Doc ID 1479782.1)

This document provides a complete impact analysis for new installs or upgraded instances regarding

  • Business flows
  • Accounting and Reversals
  • Validations
  • Non-upgraded data options

We made it EASY to get meaningful balances in Any Currency, Anytime!


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



« November 2015