17 Working with Applications

For all application types except for Users applications, you use an Oracle Enterprise Data Management Cloud application to govern an external application's enterprise data. All work on data involves an application's viewpoints and related data objects.

There are different application types, see Understanding Application Types. The principles and features of applications that are described in this topic may not all apply to Users applications. For details, see Working with Users Applications.

Note:

  • An external application is a system or application containing enterprise data that you need to work with. For example, Planning is an external application.
  • An external application can be any data source containing enterprise data. For example, you can use database tables, spreadsheets, and text files as external applications.

Videos

Your Goal Watch This Video

Learn about working with applications.

video icon Overview: Understanding Applications in Enterprise Data Management Cloud

The following list describes the main functions of an application:

  • Ensures that data conforms to the external application's requirements. For example, an application specifies which properties are available and whether they are required.
  • Presents data to users as per your requirements. For example, you can configure an application to make subsets of a dimension's nodes available to different users.
  • Imports enterprise data from an external application using a comma-delimited file. Planning enterprise data can also be imported from an external application by using a connection.
  • Exports enterprise data to an external application using a comma-delimited file. Planning enterprise data can also exported to an external application inbox by using a connection.

Note:

All application types support importing and exporting from comma-delimited files.

For Planning applications, if you enter valid connection information to an external application during registration, you can import and export from the external application inbox by using a connection. You can then import that file into your Planning application.

For Oracle Financials Cloud General Ledger applications, if you enter valid connection information to an external application during registration, you can export to the external application server by using a connection. You can then import that file into your Oracle Financials Cloud General Ledger application.

You can register applications for various application types. For example, there is an application type for Planning, see Understanding Application Types.

When you register an application, the registration process configures settings, dimensions, and properties, and creates data objects used to work with data, see Understanding Registering Applications.

After you have registered the application, you can perform the tasks listed in the following table.

Table 17-1 Application Tasks

Task More Information
Modify a registered application's settings. For example, you can add a dimension to an application. Understanding Modifying Applications
Import data from an external application. Importing Dimensions
Export data to an external application. Exporting Dimensions
Review an application's settings. For example, you can examine a dimension's settings. Inspecting Applications

Note:

If you are working with enterprise data for multiple external applications, you register an Oracle Enterprise Data Management Cloud application for each external application, see Understanding Applications and Sharing Data.