Process Flow

Description of fields on the Process Flow page

Process - Comprised of a user-assigned process code and name.

Frequency - The default is “once” unless a reoccurring schedule is selected.

Start Date - Start date and time entered in the Scheduler when adding the process.

Status - Status is automatically updated based on the frequency and recurrence end date/occurrences set in the Scheduler. For a One Time Process Flow, the status is initially set to Unscheduled. Once the job is executed, the status is automatically updated to Inactive.

If Scheduler details are modified to run an inactive job again at a later date, the status is automatically updated back to ‘Unscheduled ’ or ‘Active’.

For recurring schedules, the Process Flow status is automatically updated to ‘Inactive’ when the last job is run based on the recurrence end date or at the end of all occurrences.

1. Unscheduled - A Process Flow that is saved without entering scheduler details or the Save & Schedule button is not selected on the Process Flow page. No Jobs are added to Job Manager for Unscheduled Process Flows.
2. Active – A Process Flow with scheduler details or the Save and Schedule button is selected on the Process Flow page, there are active jobs for the Process Flow, and the Process Flow is not expired.
3. Inactive- A Process Flow that is expired or contains no active jobs

Add Process Flow

Click Add from the Process Flow page. Three tabs are displayed on the Add Process Flow page: General Information, Tasks, and Scheduler. Each of the three tabs is explained below. High-level steps are:

1. Complete the information on the General Information tab.
2. Add tasks.
3. Schedule to run or run immediately.

General Information

General Information is comprised of information that defines the Process Flow; Code, Name and E-mail Recipients.

Code - Mandatory. Enter up to 128 alpha-numeric or Latin-based characters. Code must be unique.

Name - Enter up to 256 alpha-numeric or Latin-based characters.

E-mail Recipients - The user creating the process flow is included as an email recipient by default. Enter e-mail recipients who you want to receive information on the status of the process flow. You can add Planful or external users as email recipients. There is no restriction to the number of e-mail addresses that can be added

Save - Save the process flow you are creating without starting it (i.e., it remains inactive even if the start date occurs). You must have at least one task to save a process flow.

Save & Schedule - Save the process flow add it to the Job Manager to run as configured. You must have at least one task to schedule a process flow.

Run Now Arrow - Click to execute the process flow, regardless of the start and repeat parameters you have selected.

Tasks

Add one or more tasks to a workflow.

Add/Edit Task - Clicking Add/Edit Task opens the New/Edit Task dialog page. Complete the following fields:

Task Type - Select from the following task types:

• Data Load Rule - Process selected Data Load Rules.
• Financial Package - Process a Financial Package.
• Consolidation - Run the Consolidation Process. Select to include Interim Currencies, Reporting Currencies, Eliminations, Dynamic Journals and Non Controlling Interest to run as part of the Consolidation Process. When scheduling the Consolidation Process to run via Cloud Scheduler, automate the processing of journals and currencies by clicking Configurable Steps and selecting the checkboxes.
• Dynamic Journals - Process and post active Dynamic Journals as an independent task. Inactive Dynamic Journals are not available for selection via the Cloud Scheduler. You must make inactive Dynamic Journals active via the Consolidation Control Panel to make them available for selection in Cloud Scheduler. Dynamic Journals can be processed for both the Actual scenario and other scenarios. If you select Custom Period for the Period field, additional From and To fields are displayed. This allows you to select specific dates for which to process Dynamic Journals. If you delete a Dynamic Journal from the Consolidation Control Panel that is part of a process flow in Cloud Scheduler, the Dynamic Journal will be deleted from the process flow along with all the data.
• Report Collection- Report Collection is integrated with Cloud Scheduler so that you can schedule Report Collections to run and manage and track the status on individual schedules. You must have read-only permission at the very least to add Report Collections to a Process Flow. A single Report Collection can be added to multiple Process Flows. When a Report Collection is run as a task in a Process Flow, the following takes place:
  • When substitution variables are used, Cloud Scheduler uses default settings.
  • If the Report Collection is executed successfully, users are notified via email and in application notifications.
  • E-mails and report attachments are sent to users configured on the Task, E-mail recipients, and the users/user groups as configured in the Report Collection, Distribution list.
  • Output files are saved to the File Cabinet if configured in the Report Collection.
  • Folder and file security is enabled as configured in the Report Collection.
  • Output format, number of files generated, file names, sheet names, headers/footers, TOC, and member selections (order of priority) all adhere to the configurations made in the Report Collection.
  • Status is tracked through Job Manager.
• Scenario Process - Select the Scenario Process task type, Financial or Workforce, to process in the Process Flow.
• Simulation Engine - Selecting this Task Type displays Scenario and Process selection fields. Any Simulation Engine Process, as configured in the Simulation Process Setup screen, is available for the Scenario selected. For example, after a dataload, you can run a simulation process and then have scenario processing invoke a report collections process.
• Currency Conversions - The Currency Conversions in Process Flow makes multi-currency reporting accessible to Structured Planning users. Now, the currency conversion process leverages the Ivy framework, resulting in faster processing time from Local to Common Currency, Interim Currencies, and Reporting currencies. While executing Currency Conversions, the Scenario is locked to avoid conflicts.

• Task Name – A required field. Perform a search and select the appropriate task based on the populated hierarchy in right pane of dialog page as the Task Type selected. Only active Data Load Rules with a Cloud Services type are displayed. You must have the appropriate Data Integration permissions to view Cloud Services Data Load Rules. .

• Dependencies – An optional field. Select tasks which must be executed in sequence with the task you are creating. Dependency means that the new task cannot be started until the dependent tasks are successfully completed. A dependent task is executed only if the task in which it is dependent upon is successfully completed. If the task in which it is dependent upon fails, the dependent task will not execute. All tasks without dependencies are executed in parallel.

A single task can have zero, one, or multiple dependencies. When a task has no dependencies it is added directly under Start in the Workflow. One task type can have a dependency with the same or different task type. For example, a Data Load Rule can be dependent upon another Data Load Rule. A task cannot be added as dependency to itself. Circular dependencies are not allowed. For example, Task B has a dependency on Task A so Task A cannot have a dependency on Task B.

• E-Mail Recipients - Default E-Mail Recipients are displayed based on the Data Load Rule. You can edit E-Mail Recipients and add or delete recipients. These changes are not reflected in the original Data Load Rule as they are specific to the Process Flow only. Planful users and non-users can be added to E-Mail Recipients.

• Delete - When a Task is deleted, other tasks dependent upon the task being deleted are updated and the dependency is removed.
• Save - To save the Process Flow, at least one valid task must be added to the Work Flow/List View.
• List View - Click to view in a list format.

Scheduler

Use the Scheduler tab to run the process flow at a scheduled date and time, or, a selected frequency.

Start Date - Defaulted to the current data and time. Select the date in which you’d like to process flow to execute.

Start Time - Select the start time in which you’d like to process flow to execute.

Time Zone - Select a UTC-specific time zone (e.g., UTC-08:00 Pacific Time, UTC-05:00 Eastern Time, etc.)

Repeat - Select to have the process execute more than once.

Repeats - Select to have the process executed daily, weekly, monthly, hourly, or by 30 or 45 minutes. You can view Process Flow schedules 5 days out in Job Manager. This applies to schedules that are configured to repeat daily, weekly, and monthly. For schedules that repeat hourly or based on minutes, the jobs are shown in Job Manager as soon as they start running. Every job added to Job Manager is first queued and begins processing based on server availability.

Recurrence Ends:

• Never – the process is executed indefinitely according to your repeat specifications.
• End after: _ occurrences – the process will no longer execute after a given number of occurrences.
• End by: - the process will no longer execute after a given date.

Auditing of Process Flow

You can enable the auditing of Process Flows by navigating to the Audit Setup page ( Maintenance > Audit > Application Audit > Setup Application Audit ) and selecting the Cloud Scheduler checkbox.

Access the Application Audit Details page (Maintenance > Audit > View Audit Log ) to view Cloud Scheduler process flow actions, which include Add, Delete, and Edit.

Overriding Substitution Variables for Report Collections and Financial Package When Running a Process Flow

You can edit substitution variables (either standard or dynamic) for Dynamic Reports for a Report Collection or Financial Publishing Package (FPP) when Process Flows are run for variables that are used in the header and footer, member selections, report sets, or line headers.

The substitution variables user prompt is displayed when Process Flows are executed via Run Now.

A consolidated list of all substitution variables used in all reports across all Report Collections and FPPs mapped in the Process Flow tasks is displayed. You can override the default values before generating the Dynamic Report by clicking the variable and making the change.

Additionally:

• If a single variable is used in multiple reports or multiple times in a single report, it is displayed only once in the User Prompt and takes the common value;
• Icons appear in the gird if the variable is used on headers, report sets, or dimensions;
• If the same variable is used in the header of one report and on the report set in another report, both header and report set icons are shown;
• Default values from master substitution variables are displayed in the dialog, and you can update the variable values before running the Process Flow.