Enabling Oracle Cloud EPM Forms 2.0 for Financial Consolidation and Close (FCC)
Sarah Dow
Practice Leader – Financial Close
If you haven’t made the move to Oracle Cloud EPM Forms 2.0, this blog might be useful before you dive in!
Oracle Cloud EPM Forms 2.0 was first released in 23.11 and there are lots of great additional features that enhance the user experience as summarised below, however, there are a few considerations to be aware of before making the switch!
Considerations
All fixes and enhancements will only take place in Forms 2.0
If you have formatting applied on your current Forms you need to note Forms 2.0 doesn’t have formatting in the browser, however you can apply formatting in Oracle Smart View for Office which is saved for future retrieves and is pretty smart! (ha-ha see what I did there 😉) Forms 2.0 formatting in the browser is in the pipeline, dates to be announced , but unlikely in the next few months. Groovy is an option but can be code heavy. As my colleague Mike informed me!, but personally & I hope you will agree the Oracle Smart View for Office formatting is pretty cool!! See a quick example below,
Forms 2.0 – Web View
Forms 2.0 – SmartView Standard View
Forms 2.0 – SmartView Formatted View
To apply formatting in Oracle Smart View for Office, select the FCCS menu then Apply > Custom Styles from the formatting section, then use normal excel formatting, once complete, select Save from the formatting menu.
I always recommend mitigating any risk by checking out the features in your test environment first, I am sure you will love the improvements!
It’s an application specific setting so if you don’t like it simply reset back to Forms 1.0. or clone production back to test.
And finally, if you are using Dashboards they will need to be migrated to 2.0
Highlights of enhancements
Faster rendering, cell navigation, scrolling across and down the page,
Improved member selections via dropdowns with ability to start typing the member name speeding up selection, it refreshes instantly as the member is selected, no more clicking the Apply arrow to update the form (Yay).
Line-item detail, Like Oracle Hyperion Financial Management (HFM) the ability to add additional lines to give context to a balance with logic to determine how the value rolls up into the balance of a single account see example below.
New updated Icon Menu: Adjust, Grid spread, Comments, line-item detail, Cell History and Undo
Plus the ability to add Comments to multiple cells in one go.
Enabling Forms 2.0
There are no migrations steps, as the Administrator simply updates the settings as below;
Navigate to Application > Settings
And from the dropdown menu against Forms Version select Forms 2.0 and Click Save and you are good to go!
Oracle related webcasts and YouTube content on Forms 2.0
https://youtu.be/naDI1TlHyy0?si=FLt-bT-Yvf3z7cBp
Until next time
Sarah
+44 (0)1483 685450
contact us