us-analytics.png
Ask an Expert

ARCS Product Update (June): As of Date Calculations, Generate Query Option, and More

Next week, Oracle will update Account Reconciliation Cloud Service (ARCS). In this blog post, we’ll outline changes, updates, and considerations for June.

We’ll let you know any time there are updates to ARCS or any other Oracle EPM cloud products. Check the US-Analytics Oracle EPM & BI Blog every month.

The monthly update for Oracle ARCS will occur on Friday, June 16 during your normal daily maintenance window.

eBook: The Complete Guide to Account Reconciliations

Oracle NetSuite Integration with Oracle EPM Cloud

Data Management is now available as the integration mechanism for Oracle EPM Cloud customers looking to load data from Oracle NetSuite. Oracle EPM Cloud customers now have direct access to NetSuite’s unified suite of cloud-based ERP, CRM, and commerce applications. The integration uses the NetSuite Saved Search framework to query data from the NetSuite system, which includes pre-packaged or customer defined Saved Searches.

NetSuite customers interested in leveraging this integration should contact NetSuite Support for more information on how to configure the required patch bundle in the NetSuite environment.

New EPM Automate Utility Version

A new version of the EPM Automate Utility is once again available. With this update, you’ll get an improved importsnapshotcommand, which now provides the resetPassword option. This option determines if the Identity Domain users’ (created while importing snapshots into an instance) default password must be changed after signing in for the first time.

As of Date Calculations Supported in Transaction Matching Balancing

Transactions now require an Accounting Date (As of Date) so that the system can determine which transactions should be included for a given period-end reconciliation. This feature helps users balance the reconciling and in-transit transactions at month-end against the source system’s period-end balances of a specific period-end date. When this release update is applied, any existing “Approved” reconciliation types are set to “Pending” status. You must choose a required date attribute to represent the Accounting Date.

Generate Query Option Available for Transaction Matching Custom Reports

The Generate Query option for transactions is now available when generating a custom report in Transaction Matching. This feature allows you to query existing attributes so that you can see the data you want in your report.

Enhanced User Experience in Reconciliation Compliance

Enhancements to the Reconciliation Compliance user interface were introduced in the last release update that provide 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. Since these improvements have gone into effect, please note that as of the next release update, the old method of accessing the Reconciliation List, Transactions List, and Profiles List will no longer be available in the user interface.

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.


eBook: The Complete Guide to Account Reconciliations

Ask an EPM/BI Advisor

If you're here, you've got questions — and we've got answers. Book your consultation to ask us about any range of topics, including:

  • Evaluating EPM or BI technologies
  • Comparing on-prem vs. cloud
  • Planning upgrades and migrations
  • Estimating project costs and timeframes
  • And much more — ask us anything!

Let our experts tackle your toughest questions for you.

Let's Talk