What is Consolidation/Global Consolidation Sys ?

[ramu.parepalli]

I request the Group to give brief note explaining the entire Consolidation Process and also brief about Segment Rules, Rollup Groups etc.,?


Regards,
Ramu
9848625108

[vaneetha]

Hii Ramu

I think this it may be useful for u

Rollup Group

Including in the summary template a rollup group, it is possible to define summary account combinations to hold balances for summary parent combinations.
A Rollup Group is a collection of Parent values for a given segment.

To be used in rollup groups there are a few requirements:
1. The value MUST be a Parent value.
2. The Parent Value MUST contain Child values.
3. The Parent and Child Values MUST belong to the same Value Set.

Users can summarize on any information in any segment using Rollup Groups.

Define a Rollup Group:

Navigation = Setup->Financials->Flexfields->Key->Groups
Responsibility = General Ledger Super User
Form Name = Rollup Groups (FNDFFMHL)

1. Navigate to the Rollup Groups form. The Find Key Flex Segment
Window comes up. Find the value set by either entering the value
set name, or information about your Accounting Flexfield.

2. on the Rollup Groups Screen
1. Identify the Value Set wanted
2. Enter a Name and Description
3. Save & Close Screen

Example
Code (Free Form) Name (Freeform) Description
Assets Assets Rollup group for the Asset
Accounts
Liabilities Liabilities Rollup group for the Liability
Accounts
1 Owners Equ John Johnson Johns Owners Equity rollup

Users should define rollup groups before they define the Key Segment Values Rollup groups are used for reporting purposes by creating summary accounts.
-----------------------------------------------------------------------
Setup->Financials->Flexfields->Key->Values

The Find Key Flexfields Segment Window comes up.
Choose your
Application i.e. - Oracle General Ledger
Title i.e. - Accounting Flexfield
Structure i.e. - Chart of Accounts
Segment i.e. - Natural Account
Press Find

In the Segment Values Screen - Choose the Values, Hierarchy, Qualifiers Tab in the Group column Parent Values will be in white, Child values will be shaded. Pick the Parent Value you want, and pick form the LOV the Rollup group you would like.
Save
Note: At this point you can create an FSG and use Parent Accounts.
-----------------------------------------------------------------------
Setup->Accounts->Summary
On the Summary Accounts Screen you will see

Name Template Description Earliest Period
Status
Assets D.T.Assets.T.T All Assets Jan-01
Liabilities D.T.Liabilities.T.T AP Only Feb-01

1. Name you summary account - Free Form
2. Define how you want the template to present the data for each segment
A. D - Detail
B. T - Total
C. Rollup Group (Rollup groups will appear for each segment that they have been defined for)
3. Enter a Description - Free Form
4. Enter a ?Earliest Period" for when the summary template available
5. Save - After pressing save, Oracle will commit a concurrent request and display the status.

NOTE: After creating a summary account, user must run the "Maintain
Summary Accounts" process through Reports->Request->Summary, before
running the reports.
This ensures that the summary accounts are updated after the postings have been done to pull all the updated information from each account.

References
Oracle User Guides
10.7 Page 5-42
11 Page 6-28
11i Page 9-42

Creating Summary Template; Program Ends with App-8820 Rollup Group Is Not Defined

Problem Description
You create a summary template. The Add/Delete Summary Accounts concurrent process ends with the following errors:

STPM0002: APP-8820 the rollup group 'Name' is not
defined in value set: <'Account'>

APP-8818 the template <'Template'> references
1 undefined rollup group(s)

SHRD0075: Error in chk_template ()
<xaddtmp ()
SHRD0075: Error in xaddtmp () >>

Steps to reproduce:

1. From the Navigator window, select Setup --> Accounts --> Summary 2. Enter all the values to create the summary template:
-Name of the summary account template
-Define the Template, using values D, T or Rollup Group name as
required.
-Enter the earliest period for which you want General Ledger to maintain the actual, encumbrance and budget summary account balances.
-Save your work
-Application generates a concurrent request.

Solution Description

There are parent segment values in the Rollup Group with no child range defined.

1. Choose General Ledger Super User responsibility.

2. From the Navigator window, select
Setup --> Financials --> Flexfields --> Key --> Values
Segment Values (FNDFFMSV)

3. Enter the following information:
Application: Use the list of values, choose Oracle General Ledger
Title: Use the list of values, choose Accounting Flexfield
Structure: Use the list of values, choose the structure used in the summary template.
Segment: Use the list of values, choose the segment related with the
rollup group defined in the summary template.
4. Press Find button.
5. The search retrieves the values defined for the segment.
6. Select Hierarchy, Qualifiers in the alternative region.
7. Query by criteria, define group field with the value of the
rollup group name used in the summary template.
8. Press the Define Child Ranges button.
9. Assign the child ranges from / to.
10. Save the changes.

Explanation
For some accounts in the Rollup Group, the child range is not defined.

Search Words
GLSTP

How to Define a Summary Template, Rollup Group, and 'T' Value

SOLUTION DESCRIPTION


In order to define a summary template where a segment value is totaled by a value 'T', you will need to do the following:

1. Define the value'T'as a valid, enabled value in the segment value set.
2. Create a rollup group.
3. Attach the rollup group to a summary template.

Example:
You have three segments defined in your accounting Flexfield structure:
Company.Department.Account

Your summary template is defined as
T.T.RollupGroup

You must have 'T' defined as a valid segment value for both the Company and Department segments.

Log into Oracle Applications as General Ledger Super user and follow
the steps listed below:

I. Define Value 'T'
GUI Navigation = Setup/Financial/Flexfields/Key/Values
GUI Form Name = FNDFFMSV (Segment Values)

1. Navigate to Setup/Financial/Flexfields/Key/Values.

2. Application: Select 'Oracle General Ledger' from the list of values (LOV)
Title: Select 'Accounting Flexfield' from the LOV
Structure: Select the applicable set of books from the LOV
Segment: Select the segment(s) you would like to define value 'T'
for from the LOV.
a. Click on the [Find] button.

b. Click on Edit/New Record from the toolbar and insert value 'T'
or scroll down to bottom of form an add there.

c. Check the Enabled check box [X].

d. Check the Parent check box [X].

e. When you tab over to the Qualifiers field the? Account Qualifiers? pop-up window will appear. Make sure you select 'No' for the Allow Budgeting and Allow Posting fields.

f. Repeat this procedure for all segments you wish to define a value 'T' for and save your changes before exiting the Segment
Values form.

II. Create a Rollup Group
A rollup group is a collection of parent segment values for a given
Segment.

GUI Navigation = Setup/Financials/Flexfield/Key/Groups
GUI Form Name = FNDFFMHL (Rollup Groups)

1. Navigate to Setup/Financials/Flexfield/Key Group.

2. Enter a Name and Description for your rollup group.

3. Save your changes before exiting the form.

4. Apply your rollup group name to particular values using the
Segment Values form (Navigation: Setup/Financial/Flexfields/Key/Values)

III. Attach Rollup Group to Summary Template

GUI Navigation = Setup/Account/Summary
GUI Form Name = GLXACSUM (Summary Accounts)

1. Navigate to Setup/Account/Summary.

2. Enter a summary account template Name.

3. Enter a summary account Template using one of the following values for each segment:

D:
Your template creates and maintains a summary account for every detail segment value. This value creates the most summary accounts of any template value.
WARNING! Do not define a summary account template using only 'D'
template values. A template using 'D' values for EVERY segment will duplicate your chart of accounts and may corrupt your data.

T:
Your template creates and maintains a summary account that sums
balances of all detail segment values. This value creates the
fewest summary accounts of any template value. As stated above,
this value must be defined and enabled for each segment in order to use this value in your summary template. Also, the segment value must be a parent and detailed posting and budgeting are NOT allowed.

Rollup Group Name:

Your template creates and maintains a summary account for each
parent segment value assigned to the rollup group you specify. The more parent segment values in a given rollup group, the more summary accounts your template creates.
4. Save your changes before exiting the form.

General Ledger launches a concurrent process to add the summary accounts belonging to the template.

REFERENCES
Oracle General Ledger Release 10SC, User's Guide, part number A21643-7,
pages 5-42 through 5-48.

[vaneetha]

Hii Ramu

Global Consolidation is a process of merging the data of two or more susidiaries to a parent set of books

atleast one parent set of books and two or more susidiary set of books is mandatory Company1 - parent Company 2 - Sbsidi1 Company 3 - Susidi2

Step 1 - Define Consolidation Mapping sets
Navigation - Consolidation - Define - Mapping set

Step 2 - Transfer Consolidation Data Set
Navigation - Consolidation - Transfer - dataset

Note - If at all Global Consolidation programe runs successfully this will create unposted journals at parent set of books