Revision History

This document will continue to evolve as existing sections change and new information is added. All updates are logged below, with the most recent updates at the top.

Date	What's Changed	Notes
28 APR 2017		Initial Document Creation

Oracle Account Reconciliation Cloud, May Update

This document outlines the announcements and considerations in the upcoming Oracle Account Reconciliation Cloud update.

Announcements

Monthly Update Schedule

We would like to inform you of the upcoming monthly update for your Oracle Cloud environments. We will apply the latest updates to your test environment on Friday, May 5, 2017 and to your production environment on Friday, May 19, 2017. The update will be applied during your normal daily maintenance window.

The Oracle Help Center, which provides access to updated documentation, will also be available on May 5, 2017.

File-Based Integration of Data Management with Oracle Fusion Financials Cloud

Oracle Fusion Financial Cloud Budgetary Control and Encumbrance Accounting is now fully integrated with Data Management.

This enhancement brings the integration of Oracle Fusion Financials Cloud with Oracle Enterprise Performance Management Cloud on par with the current file-based integration. As a result, the file-based integration will be phased out starting the September update to the service.

If you are using file-based integration between Oracle Fusion Financials Cloud and Oracle Enterprise Performance Management Cloud, Oracle recommends that you adopt this new integration as soon as possible.

New EPM Automate Utility Transaction Matching Commands Available

A new version of the EPM Automate Utility is available with this update. This version includes the following Transaction Matching related commands:

• importtmpremappedbalances, which imports pre-mapped balances data from a file in Oracle Account Reconciliation Cloud repository into Transaction Matching
• importtmpremappedtransactions, which imports pre-mapped transactions data from a file in Oracle Account Reconciliation Cloud repository into Transaction Matching
• runautomatch, which runs the Auto Match process to match transactions using the rules defined by a Service Administrator.
• New Features

This update applies routine maintenance and infrastructural updates.

Sample and New Application Now Available

Account Reconciliation Cloud now allows you to create a sample or new application. The sample application provides pre-loaded sample data and related artifacts, enabling you to try different operations. Using this out-of-box environment, you can explore the capabilities and performance of Account Reconciliation Cloud to get familiar with the functionality enabling you to more easily work with the service once you are ready. You can also create a new application and then load your own data, either manually or using a flat file. This can also be used with migration functionality to bring in a previously saved backup snapshot.

Reconciliation Compliance New Features

Support for Variance Analysis Reconciliation Method

Reconciliation Compliance now supports the variance analysis process (also known as the flux analysis process) which is a key control in the overall account monitoring process to ensure balance fluctuations are monitored and explained if certain thresholds are exceeded.  Variance Analysis automates the process by automatically comparing balances across periods for all account types including balance sheet, income, and expense accounts. The comparisons are selected as desired, for example, period over period, period over quarter, etc.  When formats are set up, users can now choose from the Balance Comparison, Account Analysis, or Variance Analysis methods.

The same powerful rules engine that customers are using today to streamline their reconciliation process can be used for the Variance Analysis process to either automatically process accounts that do not require any user explanation or require the variance to be explained.  The suggested best practice from best in class performing customers is to complete the Variance Analysis across all desired accounts prior to period-end close and certainly prior to reconciliation sign-off, so that the accounts can be as accurate as possible when the ledger closes for that period.

New Date Calculation Functions Added

New date calculation functions have been added to attributes for Reconciliation Compliance, including Year, Month, Day, Date, and Add Month.

Enhanced User Experience

This release introduces enhancements to the Reconciliation Compliance user interface that provides a more intuitive and improved user experience, including Reconciliation, Transaction and Profile List Views, Manage Reports, and common use of a filter bar across multiple EPM Cloud services. These changes are intended to provide you with quick, easy navigation.

Transaction Matching New Features

Predefined and Custom Reports Now Available

Transaction Matching now includes a number of predefined reports including: Reconciliation Configuration, Reconciliation Type Configuration, Closed Adjustments, Open Adjustments, Reconciliation Status, and Supported Transactions. Users can also now generate custom reports in addition to the predefined reports, as desired.

New Daily Statistics by Reconciliation Type Dashboard Available   

Customers can now view Daily Statistics by Reconciliation Type in a Transaction Matching dashboard. The dashboard shows the number of unmatched transactions, and suggested and confirmed matches, for a specific reconciliation type. You can sort the list by different criteria and view this information for a particular transaction import date.

Configurable Adjustment and Support Transaction Types Now Available

In Transaction Matching, customers can now create as many unique adjustment and support types as needed to suit their reconciliation requirements.  For example, a customer may want to configure an Adjustment Type for their reconciliation for each expense account for that reconciliation. Configuring each transaction type allows the user who is creating the adjustment to select from a list of available adjustments for this reconciliation and with a single click; the system provides all the information required to post a journal from that reconciliation. A Preparer can also input ad-hoc information including adding comments and attachments.  The configurable Support Types is very similar in that the Preparer can now select from a list of available Support Types for that Reconciliation, allowing them with a single click to mark their unmatched transactions into Support categories that make sense for that reconciliation.

Performance Enhancements for Data Load and Auto Match Tasks

Performance of data load and auto match is now enhanced through parallel processing of tasks. Currently the number of threads for parallel processing is set to eight and other tasks will be queued.    

Locking Enhancement for Data Load and Auto Match

To prevent further changes to transactions during a data load or auto match, a locking mechanism has been implemented.  During a data load, the entire reconciliation type is locked, while during auto match, only the reconciliation is locked. A message alerts the user to the lock.

Defects Fixed

Defect Number	Description
25165286	Under certain circumstances, not all attributes specified in a Reconciliation Format were displayed in the deployed reconciliation.

Considerations

• When using EPM Automate, log out and log in again after importing a Financial Close Management (FCM) snapshot to refresh the icons on the Home page.
• You may receive inaccurate messages from Navigator if pop-up blockers are enabled.  Disable pop-up blockers in your browser to avoid this.
• In the Academy, some pages and icons may appear different in the video and the Cloud service.