Previous | Next | Contents | Index | Navigation | Glossary | Library |
You cannot open this window if the value belongs to a rollup group and rollup groups are frozen. You freeze rollup groups using the Key Flexfield Segments window.
You can create networked hierarchies; that is, you can create hierarchy structures where a particular value may be a child that belongs to more than one parent. You should plan your value hierarchy structures carefully to avoid unwanted duplication of information caused by reporting or counting the same value more than once.
For example, suppose you want to define a hierarchy structure like this:
1000 _________|___________ 100 200 300 ____|______ 301 302 303
For the parent value 300, you could specify the child value range 301 (Low) to 303 (High). Since all three values 301, 302 and 303 are not parent values, you give this range a range type of Child.
For the parent value 1000, you need to specify two ranges so that you include both non-parent values (100 and 200) and parent values (300). First, you specify the child value range 100 (Low) to 200 (High) and give this range a range type of Child to include the values 100 and 200 as well as all the values between them (alternatively, you could specify these two values individually by specifying the same value for both Low and High). Then, to include the parent value 300, you specify the child value range 300 (Low) to 300 (High) and give this range a range type of Parent.
Attention: The Accounting Flexfield uses value sets that have a format type of Character, so you should specify your child ranges carefully for those value sets. For example, 100 is less than 99 (even though they appear to be numbers).
To specify a range that contains only a single value, enter the same value for both Low and High.
If you have existing child ranges from a previous version of Oracle Applications, those ranges automatically receive a range type of Child and they behave exactly as they did with your previous version.
Previous | Next | Contents | Index | Navigation | Glossary | Library |