This article applies to Fusion Analytics Warehouse release 22R3 and walks you through the step-by-step process of enabling Extensible Flexfields in Fusion Analytics. This is the first article in a two-part series.
Deciding on the flexfield structure is important in any organization implementing Oracle Cloud Applications. An extensible flexfield is similar to a descriptive flexfield in that it provides a customizable expansion space that implementors, such as Oracle Cloud Applications customers, can use to configure additional attributes (segments) without additional programming. Once extensible flexfields are enabled, it's essential that they're available for reporting.
1. Log in to Oracle Cloud Applications.
2. In Settings and Actions, click Setup and Maintenance.
3. Click Search and navigate to Manage Extensible Flexfields.
4. Click Edit.
5. Click Manage Contexts.
6. Click Search and Edit Context.
7. Ensure that View Privileges within Context Usages is set to None.
8. In Context Sensitive Segments, click Edit.
9. Ensure that BI Enabled is checked under Business Intelligence.
10. Save your changes and repeat these steps for all Context Sensitive Segments and for all Segments.
11.Click Deploy Flexfield.
The Flexfield should be deployed without any errors.
12. Log in to Oracle Transactional Business Intelligence (OTBI) and confirm that flexfields are available in the subject areas.
13. Create a report with all these flexfields and capture the OTBI logs.
14. Based on the logs, find the attribute names and VO name.
The VO name is used in Fusion Analytics Warehouse to create Data Augmentation, which is covered in the second article of the series.
By following these steps, you've enabled and verified an extensive flexfield.
You can proceed to configuring the extensive flexField in Fusion Analytics Warehouse, as describedin the second article in this series.
Schedule a meeting today to talk to the Oracle Analytics product team and learn more about how you can deploy Oracle Fusion Analytics Warehouse.