5.13 Create and use an Oracle Fusion Subscription Management Connection

Oracle Fusion Subscription Management is part of Oracle Fusion Cloud Applications that is designed to manage subscription-based products and recurring revenue business models. You can use Data Transforms to load subscription-related data from CSV files stored in Oracle Object Storage into Oracle Fusion Subscription Management tables.

You need to first create the Oracle Fusion Subscription Management Connection, and then use the Oracle Fusion Import step in the Workflow editor to load the data.

The newly created connections are displayed in the Connections page. See View and Manage Connections.

This topic has the following sections:

Creating an Oracle Fusion Subscription Management Connection

You can use this connection only as a target to load data from CSV files stored in Object Storage.

To create an Oracle Fusion Subscription Management connection:

  1. From the left pane of the Home page, click the Connections tab.

    Connections page appears.

  2. Click Create Connection.

    Create Connection page slides in.

  3. Do one of the following:
    • In the Select Type field, enter the name or part of the name of the connection type.
    • Select the Applications tab.
  4. Select Oracle Fusion Subscription Management as the connection type.
  5. Click Next.
  6. The Connection Name field is pre-populated with a default name. You can edit this value.
  7. In the Service URL text box, enter the URL pointing to the Oracle Fusion Subscription Management Service. Enter the value in the <host>:<port> format.
  8. Enter the user name and password to connect to the service.
  9. Click Test Connection, to test the established connection.
  10. After providing all the required connection details, click Create.

Loading Data to Oracle Fusion Subscription Management Tables

You can use the Oracle Fusion Import step that is available in the Workflow editor as a step to load data from Object Storage to the Oracle Fusion Subscription Management tables.

Before you use this step, make sure that:
  • You have a source object storage connection that contains the CSV files.
  • The CSV files are generated using the correct Fusion Subscription Management template.
To load data into Oracle Fusion Subscription Management Service tables:
  1. On the Home page, click the required Project title and then click Workflows in the left pane.
  2. On the Workflow page, click Create Workflow.

    The Create Workflow page appears.

  3. In the Name field provide a name for the new workflow and click Create. The Workflow editor opens.
  4. Drag and drop Oracle Fusion Import on the canvas.
  5. Double click the Oracle Fusion Import step to open the step properties page.
  6. Under Target Connection do the following:
    1. From the Fusion Type drop-down select Oracle Fusion Subscription Management.
    2. Select the connection you created in Creating an Oracle Fusion Subscription Management Connection.
    3. From the Object Code drop-down select the table you want the data to go in.
  7. Under Source Connection do the following:
    1. From the Object Storage drop-down select the connection where the CSV files are located.
    2. The File Selection (CSV) drop-down is populated with the CSV files available in that Object Storage. Select the files you want to use to load the data. You can search to select the file. You can select multiple CSV files. Note that you can only load CSV files that are in the root folder of the Object Storage. Any files that are stored in folders within the root directory are not listed.
  8. Click save icon to save the created/designed workflow.
  9. Click execute icon to execute the created workflow.
  10. [Optional] To check the status of the workflow, see the Status panel on the right below the Properties Panel. For details about the Status panel, see Monitor Status of Data Loads, Data Flows, and Workflows. This panel shows the link to the Job ID that you can click to monitor the execution status on the Jobs page. For more information about jobs see Create and Manage Jobs.
  11. [Optional] You can set a schedule to run the workflow. See Schedule Data Flows or Workflows for instructions about creating a schedule.

Parent topic: Connections