Summary Account Examples
Here are some common dimensions and examples of ways you can summarize information within each dimension:
• A segment that indicates legal entities. You might summarize companies by major industry, such as Electronics Companies; by regions within a country, such as Eastern Companies; or by country group, such as European Companies.
• A segment that indicates functional areas of your business, such as Accounting, Facilities, Shipping, and so on. You might keep track of functional areas at a detailed level, but produce summary reports that group cost centers such as Accounting, Planning & Analysis and Facilities, into one division called Administration.
• A segment that indicates your "natural" account, such as Cash, Accounts Payable, or Salary Expense. You will likely summarize your accounts by account type, namely your Assets, Liabilities, Equity, Revenues and Expenses. You might also summarize at a more detailed level, with summary accounts like Current Assets or Long–Term Liabilities.
• A segment that indicates products. You might want to summarize products into product groups such as personal computer components, storage devices, and so on.
• A segment that indicates geographical locations, such as Northern California, Central Florida or Western New York. If you define segments that record data within smaller geographical areas, such as districts, you can easily summarize districts into states, or even into groups of states you can call regions.
• Updated when journals are posted to a corresponding detail account
• Enable online summary inquiries
• Speed concurrent processing
• Allow direct posting of business transactions and journals
Summary Accounts Versus Parent Values:
Parent Values and Rollup Groups
Parent Values and Rollup Groups
After determining your needs and organizing your summary account structure, define your parent values and your rollup groups.
Note: You can use the Account Hierarchy Manager or the Account Hierarchy Editor, if Applications Desktop Integrator is installed, to create and edit your account hierarchies graphically. You can use the Account Hierarchy Manager or the Account Hierarchy Editor to define parent and child segment values, as well as rollup groups.
About Rollup Groups:
• A rollup group is a collection of parent segment values for a given segment
• A value cannot belong to a rollup group unless it is a parent value that has child values
• Parent values and child values belong to the same value set, which is attached to a key flexfield segment
Summary Account Templates
• Oracle General Ledger uses summary templates to create summary accounts.
• Oracle General Ledger uses the templates in combination with parent segment value definitions to create summary accounts.
• You specify when you want Oracle General Ledger to begin maintaining your summary account balances.
• When you delete a summary template, Oracle General Ledger deletes all summary accounts created from that template and their associated balances.
Defining Summary Accounts
Plan Your Summary Account Templates
• Set up templates to define and maintain summary accounts. You can enhance the speed of your summarizations by controlling the number of summary accounts created by your template. The number of summary accounts your template creates depends on the template segment values.
- Use the formula above to determine the number of summary accounts any given template will create.
Summary Account Creation Example
How to Define a New Summary Account Template
1. Open the Summary Accounts window.
2. Enter a Name for the summary account template.
3. Enter the Template.
4. Enter the Earliest Period for which you want General Ledger to maintain your actual, encumbrance and budget summary account balances. General Ledger maintains summary account balances for this accounting period and for subsequent periods.
5. If you are using budgetary control for your ledger, set the budgetary control options for the summary template.
6. Save your work. General Ledger submits a concurrent request to add the summary accounts, and displays the Status of your summary template.
- Current: The summary accounts are active.
- Adding: The concurrent request to create summary accounts is pending or running.
- Deleting: The concurrent request to delete summary accounts is pending or running.