Predictive Cash Forecasting Integration with Oracle Cloud ERP for Early Adopters

Predictive Cash Forecasting integration with Oracle Cloud ERP is now available for Early Adopters. Along with the existing Predictive Cash Forecasting features, the integration now offers the following features:

  • Offers automated ready-to-use integration with Fusion Cloud ERP sources for Accounts Receivables, Accounts Payables, and Cash Management cash flows.
  • Provides pre-seeded Data Integration pipelines for Predictive Cash Forecasting integration with Fusion data sources.
  • Allows you to drill down to Cloud ERP aggregate and detailed transactions to understand the forecast in detail and for deeper analysis.

The drill-down capability allows cash and treasury users to understand the forecast amount in detail in the context of additional business attributes. Users can drill to web-based aggregate and transactional views for Receivables, Payables, and Cash Management cash flow sources. These transaction listings and their business attributes will help users understand, analyze to make decisions for actions, and gain confidence of the forecast outcomes.

Receivables Overdue Invoice Summary

Drill down to Receivables Overdue Invoice Summary

Overall, Predictive Cash Forecasting offers a comprehensive solution for cash forecasting that can help businesses make better decisions for their liquidity planning and working capital management strategies. Automated integration of Fusion Cloud ERP provides the power to use real-time transactional data from Receivables, Payables and Cash Management sources for the most detailed forecasts. Users can gain actionable insight in advance, make informed decisions, and take appropriate actions to better manage working capital. With its advanced features and flexibility, it is a valuable tool for any organization looking to improve its cash forecasting capabilities.

Business Benefit:

  • Optimize cash by finding problems and opportunities earlier with increased automation and more frequent cash forecast updates.
  • Act faster by aligning stakeholders and unifying scenario planning with corrective actions.
  • Enable deeper insights to improve liquidity.

Steps to Enable

To enable this feature you need to log a Service Request (SR).

Predictive Cash Forecasting integration with ERP is currently available as a controlled release for eligible early adopter customers. Create a service request or reach out to an Oracle sales representative to get started.

To enable Predictive Cash Forecasting, there are setups to be performed in Cloud EPM and in Cloud ERP.

The following setup tasks are to be performed in Cloud ERP:

  1. Enable the Predictive Cash Forecasting feature using the Change Feature Opt In option for Financials offering in Cloud ERP Setup and Maintenance.
  2. Configure the data management and data integration users from the security console.
  3. Use the Manage Accounting Calendars task in the Financials functional area to set up the weekly forecast calendar, if required.
  4. Use the Review Predictive Cash Forecasting Data Extraction Options task in the Predictive Cash Forecasting functional area to complete the data extraction options.
  5. Use the Review Predictive Cash Forecasting Data Extraction Options task in the Predictive Cash Forecasting functional area to enable the integration between Oracle AI and Cloud ERP to initiate machine learning model training.
  6. Use the Manage Transaction Sources and Manage Transaction Types tasks in the Financials functional area to exclude receivables transaction sources and transaction types that do not align to a due date-based customer payment process, from ML training and prediction.
  7. Complete the security related setup tasks for data access.

The following setup tasks are to be performed in Cloud EPM:

  1. Create a new Planning application of type Cash Forecasting in Cloud EPM.
  2. At the end of the Application Creation wizard, click Configure. Or, from the Home page, click Application and then click Configure.
  3. Click Enable Features.
  4. Select the features you want to enable, and then click Enable. When you click Enable, the Predictive Cash Forecasting artifacts are populated, including dimensions, forms, line items, rules, navigation flows, and so on.

Tips And Considerations

  • This release provides integration between the existing Predictive Cash Forecasting capabilities and Fusion Cloud ERP (Accounts Receivable, Payables, and Cash Management).
  • Operational readiness of ERP business processes having data impacting cash flows, to be available in its most current and complete state for cash forecasting is important.
  • Availability of minimum 18 months of historical Receivables transactions with complete record of the related transactional activities is recommended to maximize machine learning model training.
  • Requires an EPM Enterprise subscription to enable the Predictive Cash Forecasting application in Cloud EPM. 
  • Requires a separate instance to enable the Predictive Cash Forecasting application in Cloud EPM. 
  • Currently available in English only. Other languages are coming soon.
  • Predictive Cash Forecasting Application is multi-currency only.
  • Predictive Cash Forecasting Application is Hybrid Essbase enabled in EPM.
  • Predictive Cash Forecasting Application provides Redwood Experience.

The capabilities listed in this document will be available incrementally across releases starting with smart driver based forecasting in the base release. The machine learning model based forecast method, capability to drill down to aggregate and detailed views and the Smart View capabilities are scheduled to be available in the upcoming future releases.

Key Resources

Access Requirements

  • Set up access to both Cloud ERP and Cloud EPM applications using one set of credentials by defining the single sign on. This allows you to seamlessly access both applications with a single login.
  • Set up Cloud EPM connections to Cloud ERP using the Manage Enterprise Application option in the topology definition.
  • Use the Cloud ERP Manage Job Roles task in the Users and Security functional area to create user-defined roles, in addition to the predefined roles with the required roles and privileges for assignment to users.
  • Use the Cloud ERP Manage Data Access for Users task in the Users and Security functional area to assign users access to appropriate data based on their job roles.