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.

   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.

   • You can 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_Total_Cash hierarchy, in the appropriate category. Additionally, add it as a shared member to the OCF_Driver_Groups 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.

   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.

6. Set user variables. See Setting User Variables.
7. 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 Forecast Methods.
8. 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.

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

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

11. 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 for Oracle Enterprise Performance Management Cloud.

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

13. Load opening balances. This step should be done only once, on the first day of implementation.

    Load your historical bank balance bank to the OCF_Historical Opening Bank Balance member, for the Actual scenario.

    When you run the Process Actuals rule, it looks for data in OCF_Historical Opening Bank Balance. If it finds data, the Opening Balance is set to this value. If it does not find data in OCF_Historical Opening Bank Balance, Predictive Cash Forecasting calculates the Opening Balance using the previous period's Closing Balance.

    Predictive Cash Forecasting provides templates to simplify loading the investing and financing cashflow data:

    • DailyHistoricalOpeningBankBalance.csv
    • WeeklyHistoricalOpeningBankBalance.csv
    • MonthlyHistoricalOpeningBankBalance.csv
    See Using the Sample Data Import Templates.
14. Oracle recommends that you change the application settings to use Forms 2.0 to leverage the latest features and functionalities available in Forms 2.0. From the Home page, click Application, and then click Settings. In Forms Version, select Forms 2.0.

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

16. Communicate the URL to your organization.
17. Set up currencies for the application. For more information, see Setting Up Currencies.