Creating Custom Event Monitoring Integrations

In Task Manager, you can create an Event Monitoring integration for an external application. The Event Monitoring integration is triggered when an external event occurs in another Cloud service or on-premises application. An example of an Event Monitoring integration is a trigger from Oracle E-Business Suite - General Ledger when a period, for example, January 2019, is closed.

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.

Setting Up the Integration 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 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 Event Monitoring.

    6. For Event Name, enter a name for the event.

  4. On the Parameters tab, click New and 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.

Setting Up the Integration in Integration Cloud

To set up the integration in Integration Cloud:

  1. Log in to Integration Cloud Services.

  2. Navigate to Connections.

  3. From the list of Triggers, select the connection that triggers the event.

  4. From the list of Triggers, select the service connection.

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

  6. Navigate to Tracking, and specify the Business Identifier for Tracking.

  7. 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.

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

  4. Create the event monitoring task and add it to the schedule. See Creating Tasks.

  5. From Schedules, select and open the schedule.

  6. Trigger the action that generates the event in the external application (for example, EBS).

  7. Wait for the task to be completed.

  8. Optional: To monitor the status of the Integration in Integration Cloud Services, log in to Integration Cloud and navigate to Monitoring.