The ODTUG Board of Directors is a group of volunteers elected by ODTUG members to serve the community at large. What board members all have in common is a genuine dedication to offering our members the best technical content, access to a large network of well acclaimed industry experts, exposure to Oracle product management, and countless professional growth opportunities. All ODTUG board members also share a sincere appreciation for how the ODTUG network has played a critical role in setting the course of their technical and leadership professional paths.
There’s no better time to reflect on the accomplishments, and lessons learnt in the past 365 days than in the last week of the year! Among a myriad of other things that I experienced in 2018, something that I felt really good about was giving both an active indirect and direct contribution towards tackling Climate Change. In this blog post I aim to visualize data sets that have the potential to influence the readers to in turn take direct and/or indirect #ClimateAction in 2019!
What if I were to tell you that Hurricane Florence poured over North Carolina as much as the average rainfall for an entire year in Seattle?! Are you able to imagine the devastation? What if I were to show you that seeing a real photo of one flooded road would look very similar as one visualization of hundreds of flooded roads?!
The sexiest topic of account reconciliations consistently revolves around automation. Yes, ARCS provides a central repository. Yes, ARCS is auditable. YES, ARCS shows a traceable workflow throughout the reconciliation cycle. All of these features are highly useful and absolutely a prerequisite to an enterprise worthy solution, but if you want to really grab people’s attention in a design session, start talking about the things they won’t have to do.
Redesign IS possible: ARCS does not permanently punish any design decisions made on “Day 1,”…but not all changes are equal in complexity, nor can all changes be made without consequence. A successful implementation ensures that the application design is sound for today and that a well laid roadmap is in place for tomorrow.
A common question I am asked during a design session is “Can I manually enter this reconciliation today, but create new feeds to automatically load the data tomorrow?” The answer is a resounding YES, and it provides clear added value to the next phase of any ARCS (or ARM) project. It can be a viable project strategy to set up reconciliations using an Account Analysis format on “Day 1” and change to a Balance Comparison format when automated data loads are built on “Day 100.”
Out-of-the-box, ARCS makes it easy to “oh, and this!” when adding new scope. The obvious example is monthly maintenance. Reconciliation Administrators and Power Users can build new Profiles to deploy for future months (or even the current month) with relative ease. With the “Copy” feature, previously created Profiles can serve as ready-to-use templates and reduce the manual effort involved in building a Profile from scratch.
Modularity – My initial experience with this concept was during the build of my first computer. There is a great, omnipresent dread that consumes people who share this hobby – imagine this scenario (or nightmare rather!): you have just invested significant time, energy, and finances to create the perfect machine – only to have it rendered obsolete the next month by changing technology that is incompatible with your swanky new rig!
Peruse the Account Reconciliation Cloud Service (ARCS) forums on Oracle’s Cloud Customer Connect and you’ll notice a theme: Transaction Matching. Questions, comments, and critiques have been flooding in from across companies and industries, clients and consultants alike. Combine this with Oracle’s game-changing announcement of the EPM Cloud price simplification plan teased for 2019 – that is, the strategic move to strictly sell bundled EPM Cloud products in the near future (more on this another time – it’s a doozy) – the changes released for ARCS in Patches 1811 and 1812 could not have come at a more opportune time. Furthermore, these changes provide a sneak peek into Oracle’s crystal ball of what’s to come.
Account reconciliations – the means by which this question is answered – are a fundamental part of the financial close process. Imagine you are trying to build a sandcastle. Now imagine your “sand” is harvested from a cow pasture. You *could* continue to build this “sandcastle,” but you will likely finish with a pile of…bull-sand. In the same way, if your account balances and transactions have an integrity equivalent to “bull-sand,” this will inevitably lead to problems down the line.