How to Manage Value Set Values and Hierarchies

You can upload and review account values and hierarchies using a file-based data import (FBDI) spreadsheet.

To manage value set values:

1. In the Setup and Maintenance work area, go to the Manage Chart of Accounts Configurations task.

   • Offering: Financials

   • Functional Area: Financial Reporting Structures

2. The Manage Chart of Accounts Configurations page displays a list of existing charts of accounts. Click the chart of accounts name link to add or modify the values for a selected value set.

3. On the Edit Chart of Accounts Configuration page, select the applicable segment row that contains the value set for which you need to manage values.

4. On the Value Set tab, click Download Values.

   Here's an image of the Value Set tab.

   

5. In the Download Values dialog box, optionally provide values in the From Value, To Value, and Description fields to filter the returned values.

   Here's an image of the Download Values dialog box.

   

6. Click Prepare in Spreadsheet to process the values for export.

7. After the process completes, click Download.

8. Save the .zip file to a folder.

9. Click Close.

10. Extract all of the files into the same folder.

11. Open the FBDI ChartofAccountsSegmentValuesandHierarchiesImportTemplate.xlsm template with the downloaded values. The template contains an instructions sheet with sections on preparing and verifying the data.

    Note: If you don't see the values for the selected value set, check that macros are enabled for the spreadsheet.

12. In the GL_SEGMENT_VALUES_INTERFACE sheet, modify the values as needed.

13. In the Instructions and CSV Generation sheet, click the Generate CSV button to create the GlSegmentValuesInterface.csv file in a .zip file format.

14. On the Value Set tab, click Upload Values.

15. In the Upload dialog box, select your .zip file and click Submit.

16. Click OK.

17. Confirm the new or modified data is available in the application.

To manage account hierarchies:

1. In the Setup and Maintenance work area, go to the Manage Chart of Accounts Configurations task.

   • Offering: Financials

   • Functional Area: Financial Reporting Structures

2. The Manage Chart of Accounts Configurations page displays a list of existing charts of accounts. Click the chart of accounts name link to edit the chart of accounts hierarchy for a selected value set.

3. On the Edit Chart of Accounts Configuration page, select the applicable segment row that contains the hierarchy with the values you need to manage.

4. Click the Hierarchies tab.

5. Select a hierarchy.

   Here's a partial image of the Hierarchies tab.

   

6. Click Download Hierarchy.

7. In the Download Hierarchy dialog box, optionally provide a parent value to download a partial branch of the hierarchy. Leave the Parent Value field blank to download the entire hierarchy.

   Here's an image of the Download Hierarchy dialog box.

   

8. Click Prepare in Spreadsheet to process the values for export.

9. After the process completes, click Download.

10. Save the .zip file to a folder.

11. Click Close.

12. Extract all of the files into the same folder.

13. Open the FBDI ChartofAccountsSegmentValuesandHierarchiesImportTemplate.xlsm template with the downloaded hierarchy. The template contains an instructions sheet with sections on preparing and verifying the data.

    Note: If you don't see the values for the selected hierarchy, check that macros are enabled for the spreadsheet.

14. In the GL_SEGMENT_HIER_INTERFACE sheet, add or modify the values as needed.

15. In the Instructions and CSV Generation sheet, click the Generate CSV button to create the GlSegmentHierInterface.csv file in a .zip file format.

16. On the Hierarchies tab, click Upload Hierarchy.

17. In the Upload dialog box, select your .zip file and click Submit.

18. Click OK.

19. Confirm the new or modified data is available in the application.