Implementation Checklist for Administrators

Follow this checklist to set up Predictive Cash Forecasting.

Prerequisites:

• Prepare metadata load files.
• Prepare data load files. For information about sample data load files, see Using the Sample Data Import Templates.

1. Create the Predictive Cash Forecasting application. See Creating a Predictive Cash Forecasting Application.
2. Enable Predictive Cash Forecasting features. See Enabling Predictive Cash Forecasting.
3. Configure Predictive Cash Forecasting. See Configuring Predictive Cash Forecasting.
4. Import metadata: From the Home page, click Application, then click Overview, and then click Dimensions. Click Import, and then click Create. For each dimension, load metadata. You can import from a file. Refresh the database. For details about each of the dimensions, see Cubes, Dimensions, Rules, and Other Artifacts.

   Note:

   • You can check the status of the Import Metadata job and the Refresh Database job in Jobs.

   • You can leverage EPM Automate to automate the file upload into the Inbox and Outbox folders.

   • Oracle recommends that you schedule a job for metadata import.

   Note:

   You can add new line items for driver categories. In the Dimension Editor, add the line item in the OCF_TotalCash hierarchy, in the appropriate category. Additionally, add it as a shared member to the OCF_DriverGroups hierarchy, in the appropriate category.

5. Import data.

   Oracle recommends that you use Data Integration to manage the data import process, including scheduling jobs. For more information, see Administering Data Integration for Oracle Enterprise Performance Management Cloud.

   Oracle recommends that you schedule a job for data import.

   Predictive Cash Forecasting provides sample data load templates as guidance for you to understand the various intersections at which the application expects data. For more information about the sample data load templates, see Using the Sample Data Import Templates.

   Typical data to load includes daily actuals, and driver data, such as expense payments, fixed assets, project payments, project receipts, revenue receipts, and so on.

   Note:

   The data load for non-Fusion ERP data sources needs to be aggregated at daily or weekly or monthly level to align with the Cash Forecasting time granularity you set up in the application when you enabled features.

6. After data is loaded, run rules:

   From the Home page, click Rules, and then select the rules to run:

   • Daily Process Actuals / Periodic Process Actuals.
   • Daily Process Forecast / Periodic Process Forecast
   • Daily Rollup / Periodic Rollup

   Select OEP_DCSH or OEP_PCSH cube and run these business rules for daily and periodic cash forecasting models.

   For information about the rules, see Rules.

7. Set up currencies for the application and run the required rules. For more information, see Setting Up Currencies.
8. Set user variables. See Setting User Variables.
9. Set the display settings to have number formatting required for your organization. If Administrators have already set up display settings, users can select Use Administrator Settings. This setting enables users to see the numbers properly formatted in forms and dashboards. From the Home page, click Tools, then click User Preferences, and then click Display. For example:
   • Thousands Separator—Comma
   • Decimal Separator—Dot
   • Negative Sign—Parenthesis
   • Negative Color—Red
10. Set up any additional Cash line items.

    From the Home page, click Application, then Overview, then Dimensions, and then select the Line Item dimension. Add new line items as needed, and then refresh the database. From the Actions menu, select Refresh Database. When the database refresh is complete, add the newly added line item members as shared members under the associated Driver group.

11. Set assumptions for forecast methods and the cash buffer:
    • Set forecast methods for each line item and entity combination. Select the forecast methods to drive the calculations for your cash forecasts. This is typically a one-time setup task, although you can make changes any time if needed. See Setting Assumptions for Forecast Methods.
    • Load or enter the Cash Buffer for each entity. See Setting Assumptions for the Cash Buffer.

12. In Access Control, create user groups for Cash Manager and Controller roles and assign them roles as needed. Typically, Cash Managers and Controllers would be Power Users or Planners.

13. Review the provided navigation flows, and modify the navigation flows as needed for your organization. Assign the navigation flows to the associated user groups you created, and then make the navigation flows active.

    To assign the security, make a copy of the navigation flows and assign security users and groups.

    Note:

    If you plan to modify the navigation flows, Oracle recommends that you make a copy of the predefined navigation flows and work in the copy, not the original. When you update, Oracle applies the update to the original navigation flows and leaves your modified navigation flows unchanged.

14. Prepare any data integrations that you created for loading data for incremental data loads by a associating business rule with the data integration. The rule significantly improves performance by calculating data for loaded combinations.
    1. From the Home page, click Application and then click Data Exchange.
    2. On the Data Integrations tab, from the Actions menu next to the integration, select Options, and then click the Business Rules tab.
    3. Expand the Embedded section, click , and add these rules as appropriate for your integration:
       • OCF_Daily Incremental Process Data For Drivers
       • OCF_Periodic Incremental Process Data For Drivers
    4. Click Save.

    For more information about registering business rules in data integrations, see Registering a Business Rule in Embedded Mode in Administering Data Integration.

15. Run data maps to push data to the reporting cube.

    After the daily and periodic cash forecasting process is completed, push the daily and periodic data to the ASO reporting cube to generate dashboards and reports. From the Home page, click Application, then click Data Exchange, and then click Data Maps. Run the provided data maps (seeded based on how you enabled the application) to push the entire forecast data into ASO reporting cube:

    • Daily Cash to Reporting
    • Periodic Weekly Cash to Reporting
    • Periodic Monthly Cash to Reporting

    Oracle recommends that you configure a pipeline job in Data Integration to automate this process.

16. Load opening balances. This step should be done only once, on the first day of implementation. For more information, see Loading the Historical Opening Bank Balance.

17. Make the application available to planners. From the Home page, click Application, then click Settings. In System Settings, change Enable Use of the Application for to All Users.

18. Communicate the URL to your organization.

Videos

Your Goal	Watch This Video
Learn how to create Predictive Cash Forecasting applications and enable features. This video is part of a series on how to configure Predictive Cash Forecasting.	Creating Predictive Cash Forecasting Applications
Learn how to set up the forecast range and time horizon. This video is part of a series to show you how to configure Predictive Cash Forecasting.	Setting up Forecast Range and Time Horizon for Predictive Cash Forecasting
Learn how to load metadata and add line items. This video is part of a series to show you how to configure Predictive Cash Forecasting.	Loading Metadata and Adding Line Items for Predictive Cash Forecasting
Learn how to set up Navigation Flows, assign Roles to those navigation flows, and set User Preferences. This video is part of a series to show you how to configure Predictive Cash Forecasting.	Setting up Navigation Flows, Roles, and User Preferences in Predictive Cash Forecasting
This tutorial demonstrates the Import Data process in Predictive Cash Forecasting using the data load template stored locally or on the server. You learn how to access the Data Import Templates then load the data files into your Predictive Cash Forecasting application. You also run the Rules for Cash Forecasting Models and finally run Data Maps to push data to a Reporting Cube.	Loading Data Files in Predictive Cash Forecasting

Tutorials

Your Goal	Learn How
In this tutorial you create a Predictive Cash Forecasting Application. Then you review the application and set up the forecast range & time horizon.	Creating Predictive Cash Forecasting Applications
In this tutorial you learn how to import and load metadata and data in Predictive Cash Forecasting. First, you load the Metadata into Predictive Cash Forecasting and perform line items setup. Then with the Import/Export utility, you import the historical actual data as well as the forecast data from the sample data load template files. Once the data is imported into the cash forecasting application, you run the associated business rules in sequence. Finally, you push the daily and periodic data into the reporting cube to generate dashboards and reports.	Loading Metadata and Data in Predictive Cash Forecasting
In this tutorial you learn how to configure Driver Methods in Predictive Cash Forecasting. You are introduced to all 11 Driver Methods.	Setting up Forecast Methods and Configuring Driver Methods in Predictive Cash Forecasting
In this tutorial you learn how to set up User Preferences and enable Forms 2.0. Then you verify Dashboards and the Rolling Forecast Grid by using the Cash Manager Navigation Flow.	Setting up User Preferences and Verifying as End User in Predictive Cash Forecasting
In this tutorial you learn how to set up Users, Groups, Roles, and Security in Predictive Cash Forecasting.	Setting up Users, User Groups, Roles and Security in Predictive Cash Forecasting