Parent and Child Values and Rollup Groups

You can create parent–child relationships for account segments with a validation type of Independent or Table. Since you can enter any value in a value set with a validation type of None, you cannot create parent–child relationships for segments that use these non–validated value sets. In addition, you cannot create parent–child relationships for dependent value sets.
Attention: Only Oracle General Ledger and Oracle Public Sector General Ledger use these features, and only with the Accounting Flexfield. Note that parent and child value sets have a relationship different from the relationship between independent and dependent values.
2. The rollup group assignments cannot be updated for this flexfield structure while the 'Freeze Rollup Groups' checkbox is checked, on the Key Segments form.
Parent Value

A parent value is a value that has one or more child values associated with it. A parent value can be assigned to a rollup group. You create parent–child relationships by defining a range of child values that belong to a parent value. You can use parent–child relationships for reporting and other application purposes. In above, account 1000 is a parent value with child values 1100 and 1200. Account 1100 is a parent value with child values 1125, 1150, and 1175.
Child Value
A child value is a value that lies in a range of values belonging to a parent value. A child value can belong to more than one parent value. A child value is not a dependent value; that is, the actual value of the child does not depend on the value of another segment. You create parent–child relationships by defining a range of child values that belong to a parent value. In above Figure , accounts 1125, 1150, and 1175 are child values of parent value 1100.
Rollup Group

A rollup group is a collection of parent values. Only parent values can be assigned to a rollup group. Parent values and child values belong to the same value set, which is then attached to a key flexfield segment. A rollup group allows you to group related parent values for creating summary templates. Given a summary template, General Ledger creates summary balances using all parent values assigned to that rollup group.
(Roll up groups are available in summary account form and can be used inplace of D: Detail, T: Total)
You define rollup groups using the Rollup Groups window before you define your key segment values. Then, you assign your parent values to the rollup groups when you define the parent values.

Rollup groups are separate from parent–child relationships. You can assign any parent value to a given rollup group, regardless of that parent value’s position in a value hierarchy you might create.
Comments
Post new comment