About Extending Data with Data Applications

Data applications provide prebuilt solutions that transform into an application or functional area, and you can manage them collectively. You can also create custom data applications using the Data Augmentation scripts.

Data applications can be:
  • Configuration-based – These are the prebuilt data applications in which the high-level application structure is fixed, and your configuration determines what components are generated. Metadata and data model inputs come from the source system. Examples include Configurable Account Analysis (CAA), DFF Mapper, and Fusion Accounting Hub (FAH). The system categorizes these as Standard.
  • Code-based: You build these data applications from scratch or semi-scratch using an integrated development environment with SQL/programming understanding such as the Data Augmentation scripts. Using the Data Augmentation scripts, you can create custom transformations across multiple source tables.

You can select data from the deployed data applications for a prioritized refresh and frequently refresh the data applications-related data. You later use these custom functional areas to augment the data from the source or enrich the data available in the Autonomous AI Lakehouse. When you start using a data application for the first time and deploy it, Oracle Fusion Data Intelligence assigns the data application a version number. You can then edit the deployed version, make changes, and save it. This saved version then gets a new version number. While you’re changing the definition, the deployed version continues to fetch new data.

While using the Data Applications feature you typically follow this flow:
  1. Define the application: In Data Configuration, select the source and create a new application from the Data Applications tile. Provide an application ID and name.
  2. Publish the application: In this step, the system generates (creates the application definition and artifacts) and deploys (performs a full load like a full load for a prebuilt functional area) the application.

    After deployment, the system creates application-specific warehouse tables and populates the data model definitions into the applicable tables, which you can use to extend the semantic layer. The system runs the incremental data loads for the application as part of the system incremental job. You can edit, regenerate, redeploy, reload, refresh data, undeploy, or delete using the available actions for a data application on the Data Applications page.