Keeping up with EPM Cloud

The ODTUG Kscope conference attracts Oracle experts from all over the globe to learn and share knowledge with other Oracle technology users. This year Kscope24 was held in Nashville (aka music city), at the Gaylord Opryland Resort & Convention Center. Representing Brovanture this year was myself (Lydia Maksoud) and my colleagues Sarah Dow and Roger Cressey. Friday As Sarah and I were travelling over from London, we flew in on Friday and after a relatively smooth journey (compared to the connecting flights last year) we arrived in Nashville on Friday evening. The first thing that hit us was the heat, it’s around 38 degrees in Nashville and very humid! The second thing was the size of the hotel – the Gaylord Opryland has multiple regions, almost like a small town, and is quite literally the biggest hotel either of us had ever been to. Saturday Luckily on Saturday we had some spare time to explore a bit of Nashville before the conference kicked off. This of course meant we had...

When building Reports in Oracle Cloud EPM Planning or FCC, text functions can be utilised to expand the report beyond a simple grid format and give added context to data. Text functions can also be used to surface additional information, including attributes, UDAs and cell commentary.   Functions are access via the dropdown at the bottom of the Member Selector :   Here are my top 5 text functions to use when creating EPM reports:        1. CellText Purpose: Surfaces the cell comments for a specified cell Example: Use this to report on variance commentary which is entered as a comment on a cell Syntax: CellText(Row,Col) where Row/Col are optional Benefits: ·          Cell comments can be entered against any member combination, which can then be surfaced for reporting ·          Comments add context to data for reporting ·       ...

When loading GL balances from Oracle Cloud ERP to Account Reconciliation Cloud (ARCS), there are a few differences to the standard process used when loading to FCC and EPM Planning. This blog will detail the full setup process required when loading GL balances to ARCS for reconciliation compliance. Before setting up the GL balances load from Oracle Cloud ERP to ARCS, there are a couple of prerequisite tasks required, which are part of the standard ARCS setup. Firstly, ensure the correct Segments and Sub-Segments have been specified in the Configuration -> System Attributes area. This is a fundamental part of the ARCS setup, which cannot be reversed without rebuilding the application. Then add all the necessary ARCS Profiles and run the Create Reconciliations job for the required period. To setup the GL balances data connection to Oracle Cloud ERP, the following 11 steps are required: 1. Setup the ERP Cloud Source System As this is an Oracle built connector, it’s as simple ...