Performing Column Flattening

Perform column flattening for the account hierarchies needed for reporting in Transactional Business Intelligence.

  To flatten columns for account hierarchies:

  1. Launch Manage Trees and Tree Versions and navigate to the Manage Trees and Tree Versions window.

  2. In the Search section, enter GL_ACCT_FLEX for the Tree Structure Code and the involved tree code or name, and click Search.

  3. In the Search Results section, select the tree version you want to flatten and choose Column Flattening from the Actions drop-down menu.

  4. Click the Online Flattening button to launch the flattening job immediately or click the Schedule Flattening button to schedule the flattening job according to your requirements.

    Note:

    For more information on Key Flexfields, Trees and their management, see the Oracle Fusion Applications Common Implementation Guide and the Oracle Fusion Applications Developer’s Guide.