My Oracle Support Banner

General Ledger FAQ for Balances (Doc ID 358137.1)

Last updated on FEBRUARY 17, 2023

Applies to:

Oracle General Ledger - Version and later
Information in this document applies to any platform.
Executable:GLPPOS - Posting
Form:GLXJEPST.FMB - Post Journals
Form:GLXJEENT.FMB - Enter Journals/Encumbrances
Executable:GLPAUTOP - Program - Automatic Posting
Executable:GLSMST - Program - Maintain Summary Templates
Executable:GLSIMS - Program - Incremental Add/Delete Summary Templates
Executable:GLOOAP - Open Period
Executable:GLSTPM - Add/Delete Summary Accounts


This FAQ provides the answers for the most common questions about Balances.

Questions regarding usage, functional clarification, general information, documentation or functionality of the Oracle General Ledger product will receive the fastest response (generally real time to 24hrs timeframe) if they are posted on the My Oracle Support Community for Oracle E-Business Suite General Ledger.
This is monitored on a daily basis by Oracle Support Services (OSS) with the highest importance. Discussion threads often receive multiple responses from other users and/or consultants on questions and issues.
OSS is strongly recommending that issues of this nature be posted on the Oracle E-Business Suite General Ledger Community.

Questions and Answers

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
Questions and Answers
 1. Can Average Balance transactions be archived and purged?
 2. Can the Average Balance feature be restricted to a specific range of accounts?
 3. How are the PTD, QTD and YTD balances I see on reports and forms calculated?
 4. Can a Journal be Double-Posted from the Enter Journals and Post Journals forms?
 5. How to avoid inconsistencies in GL_BALANCES?
 6. How to check for inconsistencies in GL_BALANCES?
 7. How to correct the 'number of updated GL_BALANCES rows does not equal the number or rows in gl_posting_interim_xxxxx table' problem?
 8. Why and How to Roll Back Actual account balances to a particular accounting period for a specific set of books?
 9. Why and How to Roll Back Encumbrance budget balances based on the encumbrance_type_id for a particular accounting period for a specific set of books?
 10. Will misclassified accounts affect account balances. If so, how can this be fixed?
 11. What is stored in the quarter_to_date_dr and quarter_to_date_cr columns in the gl_balances table?
 12. Where can I find clarifying information on Journal Types and Average Balance Processing?
 13. Why journal posting creates rows in gl_balances for the current period, and subsequent periods also?
 14. Will STAT currency numbers aggregate when calculating YTD information, Actual and/or Budget?
 Community Discussions

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