Creating Custom Process Automation Integrations

In Task Manager, you can create custom process automation integrations with external applications. In a Process Automation integration, a task is automatically executed in an external application when its start date and time are reached, and when any predecessor tasks are completed, for example, an overnight feed from a General Ledger.

Make sure you have the prerequisites and follow these steps to set up an integration between Task Manager and an external application.

For an overview of the custom integrations flow, see Creating Custom Task Manager Integrations.

Prerequisites

To integrate Task Manager with an external application, you need:
  • A subscription to Oracle Integration Cloud Service, to integrate with on-premises and non-EPM Cloud services.

    Note:

    You need one Integration Cloud instance per Oracle EPM cloud instance.
  • The external application set up.
  1. Subscribe to Oracle Integration Cloud/Oracle Autonomous Integration Cloud. See Integration Cloud Service Documentation for detailed information.
  2. Install Integration Cloud Agent in your application environment to communicate with your Oracle EPM cloud instance.. For details on setting up Integration Cloud Agent, see Managing Agent Groups.

    Note:

    If the on-premises application services are deployed in an environment set up in a demilitarized zone (DMZ) configuration so that these services are publicly accessible through the Internet, you do not need to install Integration Cloud Agent.

Creating a Connection in Task Manager

  1. On the Home page, click Application and then click Task Manager.

  2. Click the Integrations tab on the left, and then click Manage Connections.

  3. Click New.

  4. For Connection enter a name for the connection.

  5. Select Enabled to enable the connection.

  6. Select Cloud if the external application is a Cloud service.

  7. Click OK to save the connection.

Setting Up the Integration in Task Manager

  1. On the Home page, click Applications, and then click Task Manager.

  2. Click the Integrations tab on the left, and then click New.

  3. On the Properties tab, specify the required information:

    1. For Name, enter a name for the Integration.

    2. For Code, enter an Integration Code for the integration task.

      The code is used to execute the Integration and to map updates to an Integration from a file import.

    3. Optional: In Description, enter a description for the integration task.

    4. For Connection, select an application to which the task belongs.

      You can maintain the list of applications from the Manage Connections icon in the Manage Connections dialog box.

    5. For Execution Type, select Process Automation.

  4. On the Parameters tab, specify the required information:

    1. For Name, enter a name for the parameter.

    2. For Parameter Code, enter a parameter code.

    3. Optional: Enter a parameter tooltip.

    4. From the Parameter Type list, select a type, and enter additional information for the parameter:

      • Check box: Boolean value

      • Date: Date value

      • Integer: Numeric value in whole numbers

      • Number: Numeric value in whole numbers or fractions

      • Options Group: Check box for a predefined set of values

      • Static List: Predefined set of text values

      • Task Information: Task information, for example, Assignee, duration, start and end dates

      • Text: Free-form text value.

      • EPM Artifact: Name of the artifact, such as the form or report.
    5. If the parameter requires a value, select Required.

    6. Click OK to save the parameter.

    7. Click Save and Close to save the Integration.

Creating a Task Type for the Integration

  1. On the Home page, click Application, and then click Task Manager.

  2. Click the Task Types tab on the left.

  3. Click New.

  4. On the Properties tab, specify a Task Type Name and Task Type ID. See Creating Task Types.

  5. For Integration, click Search, select the Integration, and then click OK.

  6. On the Parameters tab, set the Task Type parameters.

Setting Up a Connection in Task Manager

  1. On the Home page, click Application, and then click Task Manager.

  2. Click the Integrations tab on the left.

  3. Click Manage Connections, and then from Actions, select Integration Cloud Connection.
  4. Specify the Integration Cloud connection URL and credentials and click Validate. After validation is successful, click Save. This saves the server and credentials of the connection.

Creating a Connection and Integration in Integration Cloud

  1. Log in to Integration Cloud.

  2. On the left, click Connections, and then click Create.

  3. From Create Connection - Select Adapter, search for "Oracle Enterprise Performance Management Cloud", and then click Select.

  4. In Create New Connection, enter a Name and Identifier, and click Create.

  5. Under Connection Properties, click Configure Connectivity.

  6. Select the Service Type, enter the Connection URL, and click OK.

  7. Click Configure Security.

  8. In Credentials, for Security Policy, leave the default of Basic Authentication.

  9. Enter the User name and Password, confirm the Password, and then click OK.

  10. From the EPM Connection page, click Test, and then click Save.

  11. From Integrations, click Create.

  12. Enter a name and description for the integration.

  13. Click Create.

  14. Navigate to Connections.

  15. From the list of Triggers, select the Oracle Enterprise Performance Management Adapter and drag it to the diagram as the Start trigger.

  16. From the list of Triggers, drag and drop the external application connection that triggers the event.

  17. From Operation Selection, select the operation for the external application.

  18. Navigate to Mapping, and complete the mapping between the Source parameter and Target parameter.

  19. From the list of Invokes, drag and drop the service connection and select Update Task Status Operation.

  20. Edit and complete mapping the parameters.

  21. Navigate to Tracking, and specify the Business Identifier for Tracking, for example taskID, integrationCode, and parameters.

  22. From the list of Integrations, select and activate the integration.

Completing the Integration Setup in Task Manager

Use these steps to complete the Integration setup in Task Manager.

  1. On the Home page, click Application, and then click Task Manager.

  2. Click the Integrations tab on the left and verify that the new Integration is displayed on the Integrations list.

  3. In Task Manager, select Schedules, and create a new Schedule in Pending state. See Manually Creating Schedules.

  4. Create the process automation task and add it to the schedule. See Creating Tasks.

  5. From Schedules, select and open the schedule.