1 Introduction

Overview

Oracle Fusion ERP Analytics is a prebuilt cloud native analytics solution for Oracle Fusion Cloud ERP.

It helps finance, procurement, and project professionals uncover the underlying drivers of profitability, improve the use of working capital, and control business expenditures. See Oracle Fusion ERP Analytics.

This guide lists the predefined objects in Oracle Fusion ERP Analytics. You can find information about tables, entity relationships, subject area, job roles, duty roles, associated business questions, metric details, prebuilt analyses, prebuilt business metrics, and prebuilt dashboards.

Features Available for Preview

Preview features enable functional administrators to switch functionality on and off. This way, your organization can evaluate and learn how to use new features before they roll out by default.

To enable the preview features, see Make Preview Features Available.

To learn more about subject areas, see Subject Areas.

Functional Areas

Feature	Description
Agreement Change Orders and Purchase Order Change Orders Details	This feature provides the ability to analyze on what attributes got changed and change order history details in Agreement and Purchase Order documents.
Budgetary Control	This feature provides ability to analyze Budgetary Control Balances and Transactions using Financials - Budgetary Control Balances and Financials - Budgetary Control Transactions subject areas.
Cash Management	This feature provides ability to analyze Cash Management Balances and statement transactions using Financials - Cash Management Bank Statement Balances and Financials- Cash Management Bank Statements subject areas.
Enterprise Contracts	This feature provides the ability to analyze buy side contracts. It includes details on contract headers, contract lines, contracts terms, and fulfillment lines.
Enterprise Contracts - Parties and Parties Contact	This feature provides the ability to load contract parties and the party's contact details on an as-needed basis because these dimensions can be deleted in Fusion Applications. This helps to keepFusion Data Intelligence in sync with Fusion Applications.
Grants Management	This feature provides ability to analyze the Grants awards funding.
Lease Accounting	This feature provides Financials - Expense Lease Portfolio Analysis and Financials - Expense Lease Transactions Analytics subject areas to help you analyze lease contracts, assets, payments, schedules, invoices, and accounting distributions, and manage your lease costs and obligations.
Project Assets	This feature provides reporting on Capital projects in the subject areas.
Project Labor Distribution	This feature provides the ability to analyze Project Labor Schedules and Project Labor Distribution Costs using the PPM - Project Labor Schedules (Preview) and PPM - Project Labor Distribution Costs (Preview) subject areas.
Receipt Accounting	This feature provides the ability to analyze transactions and distributions related to Receipt Accounting sourced from Purchase Orders and PO Receipts interfaced to the Procurement - Receipt Accounting (Preview) subject area.
Spend Classification	This feature enables the Procurement - Spend, Procurement - Requisitions, and Procurement - Purchase Orders subject areas to support the Spend Classification related attributes. Spend Classification is an Opt-In feature in Oracle Fusion Cloud Procurement. Enable this feature in Oracle Fusion Cloud Procurement and then enable the Spend Classification functional area in Fusion Data Intelligence
Sustainability	This feature provides ability to analyze sustainability metrics associated with Scope 1, Scope 2, and Scope 3 greenhouse gas emissions and captures an event or activity that had a Sustainability impact.

Pipeline Features

Feature	Description
GL Unposted Journals	This feature provides the ability to view unposted journals in the Financials - GL Detail Transactions subject area. After enabling this feature, ensure that you reload data for the General Ledger functional area. See Reload Data for a Data Pipeline.
Submitted Agreements in Purchasing	This feature provides the ability to analyze by submitted agreements details in the Procurement - Agreements subject area. After enabling this feature, ensure that you reload data for the Purchasing functional area. See Reload Data for a Data Pipeline.
Submitted Purchase Orders in Purchasing	This feature provides the ability to analyze by submitted purchase orders details in the Procurement - Purchase Orders subject area. After enabling this feature, ensure that you reload data for the Purchasing functional area. See Reload Data for a Data Pipeline.

Features Generally Available

Oracle Fusion Data Intelligence offers certain functionality as generally available that you must enable using the Console. Generally available features are publicly available features that you can use for production workloads. These features enable functional administrators to switch functionality on and off and are disabled by default.

To enable the generally available features, see Enable Generally Available Features.

To learn more about the subject areas, see Subject Areas.

Functional Areas

Feature	Description
Customer Collections Date Prediction	This machine learning feature predicts the expected payment date for open customer invoices. See Customer Collections Date Prediction.
Customer Collections Risk Prediction	This machine learning feature provides the customer collections risk prediction for open AR invoices. See Customer Collections Risk Prediction.
Supplier On-time Payments Prediction	This machine learning feature provides the supplier on-time payments prediction for open AP invoices. See Supplier On-time Payments Prediction.
Project Invoices Prior to Acceptance	This feature provides the ability to view invoices with all statuses in the Project Invoices subject area. By default, the PPM - Project Invoices subject area only shows invoices that are accepted in Receivables.

Pipeline Features

Feature	Description
Configurabe Account Analysis	Configurable Account Analysis (CAA) is a cross finance self-service advanced capability in Oracle Fusion Data Intelligence that enables functional administrators to define the comprehensive account analysis template combining data across general ledger and multiple subledger sources right from the initial extract date. See Configurable Account Analysis.
Encumbrance Accounting	This feature provides the ability to analyze encumbrance balances using the Financials - GL Balance Sheet and Financials - GL Profitability subject areas and encumbrance journals using the Financials - GL Detail Transactions subject area. After enabling this feature, ensure that you reload data for the General Ledger functional area. See Reload Data for a Data Pipeline.

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
• Make the Key Flexfield Segments of Chart of Accounts BI-Enabled
• Create Segment Labels for Desired Segments and Map them to BI Object Names
• Flatten and Publish Hierarchies
• Assign Hierarchies to Each Segment in Chart of Accounts
• Display Fixed Asset Segments in Fixed Assets Subject Areas
• Display the XCC Segments in Budgetary Control Subject Areas
• Set Up Exchange Rates for Analytics Currency
• Force Deploy Extensible Flexfields

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 .
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 .
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 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 .
   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 .
7. On the Edit Key Flexfield Structure Instance page, in Segment Instances, select each segment and click Edit .
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
• Create Segment Labels and Map to BI Object Names

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 Edit, 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 Edit , 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 Edit, 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 to 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
• Create Segment Labels for Desired Segments and Map them to BI Object Names
• Flatten and Publish Hierarchies
• Assign Hierarchies to Each Segment in Key Flexfield Structure Instance

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 , 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 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.

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.