Explanation
The two uses of the Column Flattening and Row Flattening features are to set the status of a tree to active and to verify correctness of trees. Column Flattening and Row Flattening are features that optimize parent-child information for run-time performance by storing additional rows or columns in a table for instantly finding all descendants or ancestors of a node without initiating a recursive query. Column Flattening and Row Flattening are required to set the status of a tree to active, as they ensure that the tree data is consistent and accurate.
Column Flattening and Row Flattening are also useful to verify correctness of trees, as they allow users to view and analyze the flattened hierarchy data using various tools such as Oracle Analytics Publisher or Oracle Transactional Business Intelligence. You do not use Column Flattening and Row Flattening to create additional versions of a tree, as this is a feature that allows users to copy an existing tree version and make changes to it without affecting the original version. Youdo not use Column Flattening and Row Flattening to view information for runtime performance, as this is a feature that allows users to monitor and measure the performance of various processes or tasks in Oracle Fusion Applications. You do not use Column Flattening and Row Flattening to optimize parent/child relationships, as this is a feature that allows users to define rules and constraints for how nodes can be related to each other in a tree structure. Reference: Oracle Financials Cloud: General Ledger 2022 Implementation Professional Objectives - Define Chart of Accounts 12