ARCS_Cover

The 3 A’s of Account Reconciliations

Account Reconciliations are a critical part of the Accounting team’s close process. Using tools like spreadsheets can make this critical process time consuming and prone to errors. Learn how simple process and tools can alleviate those risk and modernize your close.

Sales Chart 2

Corporate Forecasting Post COVID

COVID’s impact on the world has reeked havoc. As we begin to see an uptick in businesses and growth again with the hope of a vaccine we have to reset our expectations of the past. In this issue, learn about different options business have when planning for the future and how to overcome the past.

ProTip10

Pro Tip 10

On premise Hyperion Planning and early versions of PBCS automatically linked accounts across plan types. To disable this default behavior administrators were required to assign each non linked account with a UDA of HSP_Nolink.
Oracle planning now allows you to globally disable this function in the Application settings. Set the “Link Accounts by Default” setting to “No” to disable any linking of accounts across plan types.

AP3

Auto Predict – AI in Oracle EPM

Recently Oracle introduced Auto Predict in their Planning Environments. These feature is true artificial intelligence where Planning predicts your forecast automatically. This blog goes into the details of how Auto Predict can help your business.

ProCoreTip9

Pro Tip 9

On premise Hyperion Planning and early versions of PBCS automatically linked accounts across plan types. To disable this default behavior administrators were required to assign each non linked account with a UDA of HSP_Nolink.
Oracle planning now allows you to globally disable this function in the Application settings. Set the “Link Accounts by Default” setting to “No” to disable any linking of accounts across plan types.

Flex Form Image

Smart View and Flex Forms

A good reason to update to at least the 11.1.2.5.900 version of Smart View is the Enhanced Free-Form Support. This new feature is only available within Smart View and allows you to customize the row members within a form. Having the ability to delete, insert and reorder members within a form can be helpful when using large forms. Using an Enhanced Free-Form also allows you to sort and filter members using native Excel functionality.

ProTip8

Pro Tip 8

Do you have EPM Automate running for you automated EPM Processes? A good rule of thumb is to make sure and add an “Upgrade” process to your first step. Oracle will on occasion create updates to this utility and with a simple command of “EPMAutomate upgrade” you can ensure that your utility is up to date. If you’re version of EPM Automate is up to date, then nothing will happen and it’ll move forward to the next process.

Pro Tip 7

If you ever struggle with the traditional Calc Scripts of Essbase in the Oracle EPM Cloud suite spend some time looking at the Custom Defined Functions such as @CalcMgr and @CalcMgrExcel. Often times these calculations are overlooked by traditional implementations because of the lack of literature and examples of them. However, these functions are perfect for complex date logic when date fields are used in EPBCS or any of the EPM tools. They can help identify entered day, month, or year, calculate differences in time, tell you the current date and even account for leap years. So the next time you’re struggling with date logic consider these calculation functions.