Event Monitoring Integration Tasks for Oracle Fusion General Ledger

This section lists the out of box Task Manager Integrations for Oracle Fusion General Ledger Event Monitoring.

Note:

For custom process automation or event monitoring integration to Fusion cloud, see Creating Custom Task Manager Integrations.

Supported Events for Oracle Fusion General Ledger

The following events are supported for General Ledger:

Source Event Description
General Ledger Accounting Period Closed

Signals when a general ledger accounting period is closed.

General Ledger Accounting Period Opened

Signals when a general ledger accounting period is opened.

General Ledger Accounting Period Reopened

Signals when a general ledger accounting period is reopened.

General Ledger Journal Batch Approved

Signals when a journal batch is approved.

General Ledger Journal Batch Posting Completed

Signals when a journal batch is posted.

Prerequisites

To integrate Task Manager with the business events, you need:

  • Fusion Version R13 (update 19B) (11.13.19.04.0)
  • Oracle Integration Cloud Standard Edition (19.2.1.0.0)

Integrations Added to Existing Out of Box Connection

The table lists integrations that are added to monitor these business events from Task Manager, which includes:

  • Integration Types in Task Manager
  • Task Types in Task Manager
  • Integration Flows in Integration Cloud
Connection Name Integration Name Integration Code Event Name Description Parameter(s)

Oracle Fusion R13 General Ledger

Period Close Event

R13GLPeriodClose

Accounting Period Closed

Fusion General Ledger Period Close Event Monitoring

LedgerName - Name of the Ledger. For example, US Primary Ledger.

Period - Name of Period. For example, 01-19

Oracle Fusion R13 General Ledger

Period Open Event

R13GLPeriodOpen

Account Period Opened

Fusion General Ledger Period Open Event Monitoring

LedgerName - Name of the Ledger. For example, US Primary Ledger.

Period - Name of Period. For example, 01-19

Oracle Fusion R13 General Ledger

Period Reopen Event

R13GLPeriodReopen

Accounting Period Reopened

Fusion General Ledger Period Reopen Event Monitoring

LedgerName - Name of the Ledger. For example, US Primary Ledger.

Period - Name of Period. For example, 01-19

Oracle Fusion R13 General Ledger

Journal Approve Event

R13GLJournalBatchApprove

Journal Batch Approved

Fusion General Ledger Journal Batch Approve Event Monitoring

BatchName - Journal Batch Name

Period - Name of Period. For example, 01-19

Oracle Fusion R13 General Ledger

Journal Post Event

R13GLJournalBatchPost

Journal Batch Posted

Fusion General Ledger Journal Batch Post Event Monitoring

BatchName - Journal Batch Name

Period - Name of Period. For example, 01-19

Setting Up the Integration in Task Manager

In Task Manager, you can create an Event Monitoring integration for Oracle Fusion General Ledger. The Event Monitoring integration is triggered when an external event occurs in another Cloud service or on-premises application.

Make sure the business events are enabled in Oracle Fusion Cloud. You can verify the events using REST API. For more details, see Get Business Event Records. If any event is not enabled, use the REST API to enable the event. For more details, see Update Enabled Indicator for a Business Event.

Follow these steps to set up an integration between Task Manager and Oracle Fusion:

  1. On the Home page, click Application, then Task Manager.
  2. Click the Integrations tab on the left, Manage Connection, then Integration Cloud Connection.
  3. On the Integration Cloud Connection dialog, add the required information:
    1. For URL, enter the Oracle Integration Cloud URL.
    2. For Service Administrator and Password, enter the Service Administrator credentials.
    3. Click Validate.
    4. After successful validation, click Save and close the dialog.

Enabling the Oracle Fusion R13 General Ledger Connection

To enable the Oracle Fusion R13 General Ledger connection:

  1. On the Home page, click Application, then Task Manager.
  2. Click the Integrations tab on the left, then Manage Connection.
  3. Select Oracle Fusion R13 General Ledger from the list, click Actions, and then Edit.
  4. In the Edit Connection dialog, select Enabled, then click OK.
  5. In the Deploy to Integration Cloud dialog, click Generate.

    If the Oracle Fusion R13 General Ledger connection is already enabled, deploy the integration flow to Oracle Integration Cloud by selecting the event monitoring integrations from the Integrations screen, and clicking Deploy to Integration Cloud from the toolbar. Then click Generate in the Deploy to Integration Cloud dialog.

    The integration flow is deployed to the Integration Cloud and you can view the flow by logging in to Integration Cloud Services.

Note:

The first time you enable the connection to Integration Cloud, all Integration Cloud deployments will fail during activation. The Administrator must activate the integrations in Integration Cloud. Before activating the integrations, the Administrator must set up the integration in Integration Cloud.

Setting Up the Integration Flow in Integration Cloud

To set up the integration flow in Integration Cloud:

  1. Log in to Integration Cloud Services.
  2. Navigate to Connections.

    EPM Fusion Connection and EPM Connection are automatically created.

  3. Edit the connections by providing the environment and credential information. For details on prerequisites for creating a connection, see Prerequisites for Creating a Connection.

    After configuring, testing, and saving the connections, you see a green check mark next to the connections.


    Integration Cloud Connections
  4. Return to Task Manager and select Integrations.
  5. Select the integration from the list, then click Deploy to Integration Cloud from the toolbar.
  6. In the Deploy to Integration Cloud dialog, click Generate.

    The Cloud Integration deployment is successful. Verify the activation status in the Integration Cloud by logging into the Oracle Integration Cloud service, then Integrations.


    Integration Cloud Screen

Adding Event Monitoring Task to Template or Schedule

After the set up is complete, you can add the event monitoring tasks to a schedule or a template.

  1. On the Home page, click Application, and then click Task Manager.
  2. Click Templates and create a new template, for example ERP Event Template.

  3. Create the event monitoring task. See Creating Tasks.

    In the Task Type, make sure to select Oracle Fusion R13 General Ledger, then select the event monitoring task, for example, Period Open Event.

  4. In Task Manager, click Template, select the ERP Event Template and create a schedule. See Creating Schedules from Templates.
  5. In Task Manager, click Schedules, select the schedule, and change the status to Open.

    You can monitor the schedule task in the Schedule Tasks screen.

Triggering the Period Close Event in Fusion Cloud

To raise the Period Close event in Fusion Cloud:

  1. Login to Fusion Cloud.
  2. Select the General Accounting tab, then Period Close.
  3. Click General Ledger and select the period, then click Close Period.
    Fusion Cloud Screen
  4. Wait for a few minutes for the task to be completed. Then navigate to the Schedule Tasks screen in Tasks to verify the task is closed.

Triggering the Period Open/Reopen Event in Fusion Cloud

To raise the Period Open event in Fusion Cloud:

  1. Login to Fusion Cloud.
  2. Select the General Accounting tab, then Period Close.
  3. Click General Ledger and select the period, then click Open Period.
  4. Wait for a few minutes for the task to be completed. Then navigate to the Schedule Tasks screen in Tasks to verify the task is closed.

Note:

If you open a period that has never been opened, the Period Open Event is triggered. If you open a period that has been closed before, the Period Reopen Event is triggered.

Triggering the Journal Batch Approved Event in Fusion Cloud

To raise the Journal Batch Approved event in Fusion Cloud:

  1. Login to Fusion Cloud.
  2. Select the General Accounting tab, then Journals.
  3. Click Requiring My Approval and select the journal batch, then click Approve.
  4. Wait for a few minutes for the task to be completed. Then navigate to the Schedule Tasks screen in Tasks to verify the task is closed.

    Note:

    You can trigger the Journal Batch Approved event only if it is the last approval in the multi level approval process.

Triggering the Journal Post Event in Fusion Cloud

To raise the Journal Batch Approved event in Fusion Cloud:

  1. Login to Fusion Cloud.
  2. Select the General Accounting tab, then Journals.
  3. Click Tasks and select Create Journal.

  4. In Create Journal screen, specify the required information, then click Save.

    Note:

    The journal batch name and accounting period should match the parameters of the task in the Task Manager schedule.
  5. Wait for a few minutes for the task to be completed. Then navigate to the Schedule Tasks screen in Tasks to verify the task is closed.