Skip to main content

Oracle

Effortless Data Integration: Step-by-step Editing and Running of Oracle EPM Cloud Pipelines

Cloud Computing And Network Security

In my recent blog, Efficiency Redefined: How Oracle Cloud EPM Pipelines Can Streamline Your Business Process, I discussed how Perficient implemented a single streamlined process to organize the daily data load and processing jobs of one of our clients. Now, let’s review editing an existing Pipeline to add a new job, how to execute the Pipeline, and review the log file.

Editing a Pipeline to Add a New Variable

  1.  From the Data Integration home page under Data Exchange, click C1 to the right of the Pipeline you want to edit, and then select ‘Pipeline Details‘.

C2

  1. Click the C3 icon and ‘Details’ tab to edit the Pipeline details like name and number of parallel jobs.

C4

C5

  1. Click ‘Variables‘ tab to add/update/delete Variables.

C6

  1. Click C7 to add a new variable. A new row is added to the bottom of the page. Enter the following details:
    • Variable name: CopyScenario
    • Display Name: Copy Scenario
    • Display Sequence: 8
    • Required: Yes
    • Validation Type: Custom List

C8

  1. To add custom values to be available for selection during run time for this variable, click the C3 icon. Enter the list values in the below format.
Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

C9

  1. Below is the available values we want for the CopyScenario variable during run time. Click ‘OK‘. Click ‘Save‘.

C10

 

Editing a Pipeline to Add a New Job

  1. On the Pipeline page, expand the stage to which you want to add a new job.

C11

  1. Click the add job icon.

C12

  1. To add a new job to run the data copy rule, select the below:
    • Type: Business Rule
    • Connection: Local
    • Name (Select the business rule to launch in this job): Copy Working to Final
    • Title (Name of the job): Copy Working to Final
    • Sequence: 2
    • Label (runtime prompt as it is defined in the selected business rule): Not Applicable
    • Value (custom value type for a runtime prompt, specify the actual value): Not Applicable

C13

  1. The new job is auto-saved to the Pipeline.

Running a Pipeline

  1. You can open the Pipeline and Click C14 to run the Pipeline. C15
  2. Or you can run it on the Data Integrations page. C16
  3. On the Run Pipeline page, complete any runtime prompts and then click ‘Run‘. C17
  1. When the Pipeline is running, the system shows the status as C18 . You can click the status icon to download the log. C19

 

  1. When a job has been successfully executed, C20 a checkmark appears in the job card. C21
  2. You can see the status of the Pipeline in Process Details. You can click on the C24 icon to download the log files for each job. C22

With the above detailed steps, Perficient was able to convert a manual and time-consuming data load process into a streamlined Pipeline that can be executed end to end with a single click. Mastering the process of editing and running EPM Pipelines can be crucial to your organization achieving efficiency and streamlined data management, thus harnessing the full potential of Oracle EPM Cloud for your business endeavors.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.