Oracle Cloud Infrastructure Documentation

Upload and Download Financial Category Assignments

You can download financial category assignment template files to help you set up financial categories, and then upload the files to your environment.

You can download Sample or Current files. Sample provides a csv file with relevant headers to help familiarize you with the types of data you can expect. Current provides a list of current data assignments you can download to your test or production environments. Prior to download a file, you must select the segment combination you want to use to map your financial categories in the Select Columns dialog. The list prepopulates the segments defined in your chart of accounts that are BI enabled. Regardless of the file you download, you need to populate the FINANCIAL_CATEGORY column. Don't change any of the header names in the downloaded files. When you're done updating the files, you can upload them to your environment.
Note

Replace existing configuration settings deletes existing data security assignments.
  1. Sign in to your service.
  2. In Oracle Fusion Data Intelligence Console, click Uploads under Application Administration.
    You see the Uploads page.
  3. On the Uploads page, click Download File, select Financial Category Assignments and then select the type of file you want to download.
  4. Open the csv file you downloaded and populate the fields as required:
    • CHART_OF_ACCOUNTS – Name of your chart of accounts.
    • Actual segment values.
    • FINANCIAL_CATEGORY: The financial category code. This can be a predefined category or a custom category defined using the Financial Categories upload option.
  5. When you're done updating the file, save your changes.
  6. On the Uploads page, click Upload File and the applicable file type.
  7. Select whether you want to Merge to the existing settings or Replace existing configuration settings.
    Note

    If you want to change the segment combination for your financial category definition, then ensure to provide the data for all chart of accounts and use the replace option. The data is completely replaced. Different segment combinations for different chart of accounts is NOT supported.
  8. Select the file you want to upload and click Upload File.
    You can review the status of the upload on the Uploads tab.
  9. Use Actions next to the file name to perform actions on a specific upload file:
    • Click Properties to check the upload statistics.
    • Click Download to download the file you just uploaded in the event you want to upload the file again.
    • Click Delete if a file fails to process and you want to remove the file history.