Prerequisites for Oracle Fusion ERP Analytics

Be sure you review and set up these prerequisite requirements to use Oracle Fusion ERP Analytics and the provided subject areas.

Topics:

Assign Financial Categories to the Natural Accounts

Be sure you link financial categories with natural accounts before using Oracle Fusion ERP Analytics and the provided subject areas.

Verify and assign financial categories to the natural accounts to identify groups of accounts for reporting/analysis in Oracle Fusion ERP Analytics. The system uses these Financial categories in prebuilt metrics of the GL Balance Sheet and GL Profitability subject areas. Search for the natural accounts, verify that financial accounts are assigned to them, and if not, then assign financial categories to the natural accounts.

Use this spreadsheet to view a list of prebuilt Financial Categories used in GL Metrics and business metrics.

Note:

Prebuilt analyses and the metrics in the GL subject areas are based on the Fusion Applications standard financial categories. If your define custom categories, you need to define your own derived metrics to use in your analysis.

  1. Sign in to Oracle Cloud ERP.
  2. Navigate to My Enterprise, click Setup and Maintenance, and in the Setup and Maintenance work area, go to the following:
    • Offering: Financials
    • Functional Area: Financial Reporting Structures
    • Task: Manage Chart of Accounts Structure Instances
  3. Under Search, select General Ledger from the Module list, and click Search.
  4. In Search Results, select the Application and under Search Results click Manage Structure Instances.
  5. On the Manage Key Flexfield Structure Instances page, under Search, in Structure Name, select applicable name and click Search.
  6. From the search results, select your Chart of Accounts Instance and click Edit Edit icon.
  7. On the Edit Key Flexfield Structure Instance page, in Segment Instances, identify your natural account segment in the Segment Code column, and click the corresponding value in the Value Set Code.
  8. On the Manage Value Sets page, in Search Results, click Manage Values, and on the Manage Values page, click Search to list all the natural account codes.
  9. In Search Results, ensure that all the active natural accounts have financial categories assigned to them in the Financial Category column.
  10. If the active natural accounts don’t have financial categories assigned to them, then assign using either way:
    • Manually select the financial category in the Financial Category column.
    • Map the financial categories to active accounts using the File Based Data Import (FBDI) template. .
  11. To download these values into a spreadsheet, click Action and select Export to Excel.

Make the Key Flexfield Segments of Chart of Accounts BI-Enabled

Be sure you enable key flexfield segments for Oracle Transactional Business Intelligence before using Oracle Fusion ERP Analytics and the provided subject areas.

Perform this procedure in Oracle Cloud ERP.
  1. Sign in to Oracle Cloud ERP.
  2. Navigate to My Enterprise, click Setup and Maintenance, and in the Setup and Maintenance work area, go to the following:
    • Offering: Financials
    • Functional Area: Financial Reporting Structures
    • Task: Manage Chart of Accounts Structure Instances
  3. In Manage Chart of Accounts Structure Instances, select General Ledger in Module, and click Search.
  4. In Search Results, click Manage Structure Instances.
  5. On the Manage Key Flexfield Structure Instances page, under Search, in Structure Name, select applicable name and click Search.
  6. From the search results, select your Chart of Accounts Instance and click Edit Edit icon.
  7. On the Edit Key Flexfield Structure Instance page, in Segment Instances, select each segment, click the edit icon, and in the Edit Key Flexfield Segment Instance dialog, ensure that the BI enabled check box is selected.

Create Segment Labels for Desired Segments and Map them to BI Object Names

Be sure you create segment labels and map them to BI Objects before using Oracle Fusion ERP Analytics and the provided subject areas.

Populate the BI Object name for each of the segment labels that you plan to leverage with Oracle Transactional Business Intelligence (OTBI) for reporting and analysis.

For the following segment labels, populate the BI Object Name as follows:

Segment Label BI Object Name
FA_COST_CTR Dim - Cost Center
GL_BALANCING Dim - Balancing Segment
GL_ACCOUNT Dim - Natural Account Segment

For all other non-qualified segment labels that you want to leverage within Oracle Fusion Data Intelligence, populate the BI Object name with one of the following:

  • Dim - GL Segment1
  • Dim - GL Segment2
  • Dim - GL Segment3
  • Dim - GL Segment4
  • Dim - GL Segment5
  • Dim - GL Segment6
  • Dim - GL Segment7
  • Dim - GL Segment8
  • Dim - GL Segment9
  • Dim - GL Segment10

BI Object name mapping is available for 3 qualifying segments and up to 10 non qualifying segments. Oracle Fusion Data Intelligence can support maximum of 13 GL segments respectively.

Note:

You aren’t allowed to assign a BI Object name to the predefined segment labels. You must create a new segment label and assign the BI Object name to it. It's mandatory to use Cost Center, Natural Account, and Balancing Segment Labels. Chart of Account should have these labels assigned to one of the Segments. Ensure that Segment Labels are a single word without any spaces.

Follow these guidelines to create a segment label code:
  • Use only characters in the following range: a to z, A to Z, 0 to 9 or _ (underscore).
  • Don't start the code with a numeric digit.
  • Don't exceed the total length of the code over 21 characters.

If you’re using the Intercompany Segment and want to use it for reporting, then you must create a label as you can’t use the existing GL_INTERCOMPANY because it's read only. You must create a segment label and assign the BI Object name to it.

  1. Sign in to Oracle Cloud ERP.
  2. Navigate to My Enterprise, click Setup and Maintenance, and in the Setup and Maintenance work area, go to the following:
    • Offering: Financials
    • Functional Area: Financial Reporting Structures
    • Task: Manage Chart of Accounts Structure Instances
  3. In Manage Chart of Accounts Structure Instances, select General Ledger in Module, and click Search.
  4. In Search Results, click Actions and select Manage Segment Labels.
  5. On the Manage Segment Labels page, click Add icon to create a new segment and map it to the BI Object name for all the segment labels that you want to map and click Save and Close. Create segment labels if you aren’t using the predefined segment labels.
  6. Assign these segment labels to your segments in the chart of accounts structure using these steps:
    1. In Search Results, click Actions, select Manage Structure, and then on the Manage Key Flexfield Structures page under Search, click Search.
    2. In Search Results, select the chart of accounts structure and click Edit.
    3. In Segments, select the segment and click Edit Edit icon.
    4. In the Edit Key Flexfield Segment dialog for the selected segment, under Segment Labels, select the applicable Available Labels and move them to Selected Labels. Click Save and Close.
    5. Repeat the steps for all the segments.
  7. After assigning labels to all the segments, deploy the flexfield using these steps:
    1. Navigate to the Manage Chart of Accounts Structure Instances task.
    2. In Search Results, select General Ledger in Module and click Search.
    3. In Search Results, ensure that General Ledger is selected, and then click Deploy Flexfield.

Flatten and Publish Hierarchies

To ensure hierarchies are available in Oracle Fusion ERP Analytics, you need to flatten and publish them in Oracle Cloud ERP.

  1. Sign in to Oracle Cloud ERP.
  2. Navigate to My Enterprise, click Setup and Maintenance, and in the Setup and Maintenance work area, go to the following:
    • Offering: Financials
    • Functional Area: Financial Reporting Structures
    • Task: Manage Account Hierarchies

      Note:

      Ensure that you show All Tasks.
  3. Under Task, click Manage Account Hierarchies and identify the tree structure that you want to flatten. If you have more than one active version of the tree, then you must flatten all active versions. Oracle Fusion Data Intelligence will only consider active tree versions.
  4. In Search Results, select the version. Under Actions select Flatten, and then select Column Flattening.
  5. In Manage Account Hierarchies, click Online Flattening, and then select Force Flattening.
  6. Repeat these steps for all versions of all segments of your chart of accounts. You must complete these steps for all hierarchies of all segments.
  7. Publish all the hierarchies and hierarchy versions that you flattened using these steps:
    1. a. In the Setup and Maintenance work area, go the Financials offering, Financial Reporting Structures functional area, and Publish Account Hierarchies task. Be sure All Tasks is in the Show list.
    2. In the Publish Account Hierarchies search results, select the hierarchy and click Search.
    3. In Search Results, select the Publish check box for the account hierarchies that you want to publish.
    4. Click Publish to update the balances cubes.

Assign Hierarchies to Each Segment in Chart of Accounts

To ensure hierarchies are available in Oracle Fusion ERP Analytics, you need to assign hierarchies to each segment in the Oracle Cloud ERP chart of accounts.

  1. Sign in to Oracle Cloud ERP.
  2. Navigate to My Enterprise, click Setup and Maintenance, and in the Setup and Maintenance work area, go to the following:
    • Offering: Financials
    • Functional Area: Financial Reporting Structures
    • Task: Manage Chart of Accounts Structure Instances
  3. In Manage Chart of Accounts Structure Instances, under Module select General Ledger, and click Search.
  4. In Search Results, click Manage Structure Instances.
  5. On the Manage Key Flexfield Structure Instances page, under Search, in Structure Name, select applicable name and click Search.
  6. From the search results, select your Chart of Accounts Instance and click Edit Edit icon.
  7. On the Edit Key Flexfield Structure Instance page, in Segment Instances, select each segment and click Edit Edit icon.
  8. In the Edit Key Flexfield Segment Instance dialog for the selected segment, in Tree Name, select the applicable value and click OK.
  9. Repeat the steps for all segments in your Chart of Accounts instance.
  10. After assigning labels to all the segments, deploy the flexfield using these instructions:
    1. Navigate to the Manage Chart of Accounts Structure Instances task.
    2. In Manage Chart of Accounts Structure Instances, select General Ledger in Module and click Search.
    3. In Search Results, ensure that General Ledger is selected, and then click Deploy Flexfield.

Display Fixed Asset Segments in Fixed Assets Subject Areas

To display the Fixed Asset segments in the Fixed Assets subject areas, perform these tasks.

Set Key Flexfield Segments of Fixed Assets to BI-Enabled

  1. Sign in to Oracle Cloud ERP.
  2. Navigate to My Enterprise, click Setup and Maintenance, and in the Setup and Maintenance work area, search for Manage Key Flexfields and open the Task Manage Key Flexfields.
  3. Search for the Key Flexfield Code CAT# - for the Asset Category flexfield and select the category flexfield.
  4. Click Manage Structure Instances.
  5. On the Manage Key Flexfield Structure Instances page, under Search, in Structure Name, select the applicable name and click Search.
  6. From the search results, select your Key Flexfield Instance and click Edit.
  7. On the Edit Key Flexfield Structure Instance page, in Segment Instances, select each flexfield segment, click EditEdit icon, and in the Edit Key Flexfield Segment Instance dialog, ensure that the BI enabled check box is selected. Perform this step for all segments that you want to use for Reporting.
  8. Search for Key Flexfield Code LOC# - for the Asset Location flexfield and select the Location flexfield.
  9. Click Manage Structure Instances.
  10. On the Manage Key Flexfield Structure Instances page, under Search, in Structure Name, select applicable name and click Search.
  11. From the search results, select your Key Flexfield Instance and click Edit.
  12. On the Edit Key Flexfield Structure Instance page, in Segment Instances, select each flexfield segment, click EditEdit icon , and in the Edit Key Flexfield Segment Instance dialog, ensure that the BI enabled check box is selected. Perform this step for all segments that you want to use for Reporting.
  13. Search for Key Flexfield Code KEY# - for the Asset Key flexfield and select the Key flexfield.
  14. Click Manage Structure Instances.
  15. On the Manage Key Flexfield Structure Instances page, under Search, in Structure Name, select the applicable name and click Search.
  16. From the search results, select your Key Flexfield Instance and click Edit.
  17. On the Edit Key Flexfield Structure Instance page, in Segment Instances, select each flexfield segment, click EditEdit icon, and in the Edit Key Flexfield Segment Instance dialog, ensure that the BI enabled check box is selected. Perform this step for all segments that you want to use for Reporting.

Create Segment Labels and Map to BI Object Names

You need to create segment labels and map them to BI Objects. Populate the BI Object name for each of the segment labels that you plan to leverage for reporting and analysis.

  • The Major Category and Minor Category labels for the Category Segment are mapped to Segment1 and Segment2 respectively by default.
  • In addition, the BI metadata has below pre-defined BI Objects for the different Asset Category segments shown:
    • Segment3
    • Segment4
    • Segment5
    • Segment6
    • Segment7
  • The State Segment label for the Location segment is prebuilt and is mapped to Segment2.
  • In addition, the BI metadata has below pre-defined BI Objects for the different Asset Location segments shown:
    • Segment3
    • Segment4
    • Segment5
    • Segment6
    • Segment7
  • Similarly , you create segment labels and assign them to BI objects for the Key Flexfield Segment KEY#.

Note:

Be sure that the BI object name is entered correctly in the format SegmentX.
  1. In the Setup and Maintenance work area, search for Manage Key Flexfields and open the Task Manage Key Flexfields.
  2. Search for Key Flexfield Code CAT# and select the Category flexfield.
  3. In the Search Results, click Actions and select Manage Segment Labels.
  4. On the Manage Segment Labels page, click Add Iconto create a new segment and map it to the BI Object name. Repeat these steps for all the segment labels that you want to map. Click Save and Close.
  5. Assign these segment labels to your segments in the flexfield structure by following these steps:
    1. In the Search Results, click Actions, select Manage Structure, and then on the Manage Key Flexfield Structures page under Search, click Search.
    2. In Search Results, select the key flexfield structure and click Edit.
    3. In Segments, select the segment and click Edit.
    4. In the Edit Key Flexfield Segment dialog for the selected segment, under Segment Labels, select the applicable Available Labels and move them to Selected Labels. Click Save and Close.
    5. Repeat these steps for all the segments .
  6. After assigning labels to all the segments, deploy the flexfield.
  7. Search with Key Flexfield Code LOC# and select the Location Flexfield.
  8. In Search Results, click Actions and select Manage Segment Labels.
  9. On the Manage Segment Labels page, create a new segment and map it to the BI Object name for all the segment labels that you want to map. Click Save and Close.
  10. Assign these segment labels to your segments in the Flexfield structure using these steps:
    1. In Search Results, click Actions, select Manage Structure, and then on the Manage Key Flexfield Structures page under Search, click Search.
    2. In Search Results, select the key flexfield structure and click Edit.
    3. In Segments, select the segment and click Edit.
    4. In the Edit Key Flexfield Segment dialog for the selected segment, under Segment Labels, select the applicable Available Labels and move them to Selected Labels. Click Save and Close.
    5. Perform this step for all segments that you want to use for Reporting.
  11. After assigning labels to all the segments, deploy the flexfield.
  12. Search with Key Flexfield Code KEY# and select the Asset Key Flexfield.
  13. In Search Results, click Actions and select Manage Segment Labels.
  14. On the Manage Segment Labels page, create a new segment and map it to the BI Object name for all the segment labels that you want to map and click Save and Close.
  15. Assign these segment labels to your segments in the Flexfield structure using these steps:
    1. In Search Results, click Actions, select Manage Structure, and then on the Manage Key Flexfield Structures page under Search, click Search.
    2. In Search Results, select the key flexfield structure and click Edit.
    3. In Segments, select the segment and click Edit.
    4. In the Edit Key Flexfield Segment dialog for the selected segment, under Segment Labels, select the applicable Available Labels and move them to Selected Labels. Click Save and Close.
    5. Perform this step for all segments that you want to use for Reporting.
  16. After assigning labels to all the segments, deploy the flexfield.

Display the XCC Segments in Budgetary Control Subject Areas

Perform these tasks to display the XCC Segments in the Budgetary Control subject areas.

Set Key Flexfield Segments of Budgetary Control to BI-Enabled

  1. Sign in to Oracle Cloud ERP.
  2. Navigate to My Enterprise, click Setup and Maintenance, and in the Setup and Maintenance work area, search for Manage Key Flexfields and open the Task Manage Key Flexfields.
  3. Search for the Key Flexfield Code XCC and select the Budgetary Control Key Flexfield.
  4. Click Manage Structure Instances.
  5. On the Manage Key Flexfield Structure Instances page, under Search, in Structure Name, select the applicable name, and click Search.
  6. From the search results, select your Key Flexfield Instance and click Edit.
  7. On the Edit Key Flexfield Structure Instance page, in Segment Instances, select each Budgetary Control segment, click Edit Edit icon, and in the Edit Key Flexfield Segment Instance dialog, be sure the BI enabled check box is selected.

Create Segment Labels for Desired Segments and Map them to BI Object Names

You need to create segment labels and map them to BI Objects. Populate the BI Object name for each of the segment labels that you plan to leverage for reporting and analysis.

  • The Department, Fund, and Object segment labels are pre-configured with these BI Object Names
    • XCC_FUND - Dim - XCC Segment1
    • XCC_OBJECT - Dim - XCC Segment2
    • XCC_DEPARTMENT - Dim - XCC Segment3
  • The BI metadata has the listed pre-defined BI Objects for the Budgetary Control segments:
    • Dim - XCC Segment4
    • Dim - XCC Segment5
    • Dim - XCC Segment6
    • Dim - XCC Segment7
    • Dim - XCC Segment8
    • Dim - XCC Segment9
    • Dim - XCC Segment10

These BI Objects are used as dimensions under the Budgetary Control Balances and Budgetary Control Transactions subject areas.

Note:

Be sure that the BI object names Dim - XCC SegmentX is entered correctly.
  1. In the Setup and Maintenance work area, search for Manage Key Flexfields and open the Task Manage Key Flexfields.
  2. Search with Key Flexfield Code XCC and select the Budgetary Control Key Flexfield.
  3. In Search Results, click Actions and select Manage Segment Labels.
  4. On the Manage Segment Labels page, create a new segment and map it to the BI Object name for all the segment labels that you want to map. Click Save and Close.
  5. Assign these segment labels to your segments in the Budgetary Control Key Flexfield structure using these steps:
    1. In Search Results, click Actions, select Manage Structure, and then on the Manage Key Flexfield Structures page under Search, click Search.
    2. In Search Results, select the key flexfield structure and click EditEdit icon.
    3. In Segments, select the segment and click Edit.
    4. In the Edit Key Flexfield Segment dialog for the selected segment, under Segment Labels, select the applicable Available Labels and move them to Selected Labels. Click Save and Close.
    5. Repeat these steps for all the segments
  6. After assigning labels to all the segments, deploy the flexfield.

Flatten and Publish Hierarchies

Be sure that each value set for a segment that you plan to leverage for reporting is configured with a data hierarchy using tree structures. For the tree version, execute the column flattening process in Force mode to make sure the values are populated in the individual segments.

  1. In the Set Up and Maintenance page, enter Manage Trees in the Search field.
  2. Click the Manage Trees and Tree Versions task link.
  3. Select the tree version for flattening. Click Action and select Flatten.
  4. In the next screen, click Force Flattening.

Assign Hierarchies to Each Segment in Key Flexfield Structure Instance

Ensure that the tree structure is assigned to the Key flexfield segment.

  1. From the Manage Key Flexfields page, click Manage Structure Instances.
  2. Click Search on the Manage Key Flexfield Structure Instances page.
  3. Select the desired structure name and click Edit to show the segment codes.
  4. Select the desired segment code and click Edit.
  5. In the Edit Key Flexfield Segment Instance dialog for the selected segment, in Tree Name, select the applicable value and click OK.
  6. Repeat these steps for all the segments in your key flexfield structure instance.
  7. After assigning labels to all the segments, deploy the flexfield.

Set Up Exchange Rates for Analytics Currency

You need to set up exchange rates for analytics currency to ensure the Oracle Cloud ERP data in Oracle Fusion ERP Analytics is accurate.

In the Oracle Fusion Data Intelligence reporting configuration, functional administrators can specify an Exchange rate type that Oracle Fusion Data Intelligence uses to convert from Ledger currency to Analytic currency. Before specifying the Exchange rate type, ensure that the exchange rates are defined in Oracle Cloud ERP for this rate type to ensure that the Analytic currency amounts are calculated correctly. The prebuilt workbooks and dashboards use the analytic currency amounts, so you need to preform this setup first.

Force Deploy Extensible Flexfields

You need to deploy extensible flexfields for Oracle Cloud ERP to work properly with Oracle Fusion ERP Analytics.

  1. Sign in to Oracle Cloud ERP.
  2. Run Refresh and Deploy Offline from the Manage Extensible Flexfields taskflow for EGO_ITEM_EFF.
  3. From Scheduled Processes, run the Import Oracle Fusion Data Extensions for Transactional Business Intelligence job to sync up Oracle Metadata Services with Oracle BI Cloud Service.