About Extending Data with the Descriptive Flex Fields Attribute Mapper
You can use the Descriptive Flex Fields (DFF) Attribute Mapper custom configuration to select the prebuilt DFFs with their attributes, generate, and deploy the selected DFFs in the warehouse. The deployed DFFs create a custom functional area that you can use like the prebuilt functional areas.
- For attribute name, it supports "alphanumeric", "_", and "$". This is according to the Oracle SQL database restrictions. Avoid using any other characters because they aren’t supported.
- For display name or label, proceed with caution using any special characters because they can create an issue in report generation. Comma isn’t allowed by default.
The DFF Attribute Mapper custom configuration is available with the 22.R3 application update. For tenant instances that you create after upgrading to this application update, as a service or functional administrator, you must navigate to this custom configuration, search for and select the DFFs that you want to move to the warehouse, map the attributes as needed, and deploy the selected DFFs. You can filter based on functional areas such as General Ledger, Accounts Payables, and Accounts Receivables or applications from the source system such as Payables and Receivables to list DFFs that you need to move to the warehouse. If you require a new DFF later, then complete this process again.
For tenant instances already operational before the 22.R3 application update, to ensure backward compatibility, Oracle Fusion Data Intelligence automatically copies the DFFs based on the functional areas that are activated. For existing tenant instances, Oracle Fusion Data Intelligence also copies the DFFs when you activate a new functional area. Oracle recommends that you start using the DFF Attribute Mapper to select DFFs and map the required attributes yourself.