This is a quick tip on how to find out whether your EPM cloud running instance is running on OCI Classic or OCI Gen2 datacentre. The answer is quite simple: find out by viewing your instance's activity reports. The activity report will include a header "Cloud Infrastructure" and it'll state whether it is "OCI Classic" or "OCI (Gen2)". There is another way, cheeky one I must add, to find out and it is simply when you login to your environment: OCI Gen2 login screen will look like this: And OCI Classic login screen will look like this: This should save you some time next time you a ..read more

I have found a workaround that enables me to delete scheduled jobs in Enterprise Profitability and Cost Management (EPCM). Check my last post for more details about the error itself. Here is the error to begin with. As you can see above, I cannot simply delete the job straight away (this is still a bug as of the date of this post), so what I need to do is create an LCM export for that job, modify the xml file, and re-import the file again. 1. Export the LCM job definition  2. Export the LCM definition and download the file locally 3.Edit the XML file and change the ..read more

So I came across this error in EPCM that is stopping me from deleting scheduled jobs.  As of the creation date of this post, I'm unable to delete or edit a created scheduled job in EPCM, so until there is a fix for this, I suggest you do not create scheduled jobs in the interim and look for other workarounds (server side schedules, task manager in another pod etc). This is the error message I'm getting while attempting to delete the job. I have create an SR with and they have replicated the same issue in-house (this means it is a bug), I will update this post when I have more infor ..read more

 This is a quick post about accessing Calc Manager rules properties using groovy class Rule. I have the following script that validates just fine. But if I try to run the rule I get the following error message: The issue is caused by the rule not being deployed to the Planning tables: The solution is simple. Deploy the run the rule again ..read more

 I found a typo in the Calculate Model REST API  in EPCM documentation that made go around in circles for a couple of hours trying to figure out what exactly is the problem! I already got in touch with the Oracle team in charge of the documentation and they are going to update the documentation at some point, so this post is about navigating such issues in the futures. So the doco says the parameters (jobType and jobName) are required and their values must be "Calculate Model" However, when I first tried to use this API using the exact same information, I got the following e ..read more

 This post is the first post of two part series about serverless functions in Oracle Cloud Infrastructure, why they appear to be popular, how they're invoked in OCI and finally, a use case on how to build a serverless function to automate the backups of an EPM Cloud application. Let's start by what is an Oracle Function as defined by Oracle: “Oracle Functions is a fully managed, multi-tenant, highly scalable, on-demand, Functions-as-a-Service platform. It is built on enterprise-grade Oracle Cloud Infrastructure and powered by the Fn Project open source engine. The serverless and elastic a ..read more

This post is about some tips on how to successfully deploy Essbase 21c marketplace offering in OCI.  Thanks to OCI's Resource Manager, this task is straight-forward and is not time-consuming. That said, it is easy to miss a single step and ending up spending hours troubleshooting an issue you shouldn't have in the first place. The pre-deployment configuration steps are as follows: Create compartment  Create a vault, encryption key, create secrets for your admin passwords and note down the OCID. Decide on your database option for RCU schemas (you can use an existing database or creat ..read more

I've been having a bit of time on my hands lately thanks to the current covid lockdown we have in Australia and I got to spend more time setting up my Oracle Cloud Infrastructure(OCI) tenancy.  One of the topics I wanted to write about is a fully automated cloud-based backup solution for EPM Cloud in OCI. The solution I'm going to covert in this post is 100% in the cloud with no on-premise resources/dependencies at all! Pretty cool if you ask me, so let's get to it. This diagram is a very high-level architectural diagram of the solution: So, the main OCI components we are looking at he ..read more

This is the second post of my Financials Cloud for EPM folks series, in these posts I'm trying to familiarize EPM professionals with ERP Financials Cloud because we all have to interact and work with ERP cloud at some point.  In the first post, I covered value sets and in this post I will briefly writing about hierarchies. In the ERP world metadata is defined in two ways: 1- Value sets (flat lists) primarily used for transactions, journal entries and all kind of ERP related configuration/ 2- Hierarchies - primarily used for reporting and budgetary control purposes (hierarchic ..read more

 This blog is a quick follow-up to my last post about Geomaps, and the focus of this post is to show another way we can build the metadata to support Geomaps chart types. While there are restrictions when it comes to country names, there is nothing that stops us from creating additional members that roll up to countries. For example, let us look at the following hierarchy: As you can see above, I have suburbs rolling up to cities, and finally to countries which is the level the Geomaps will work at. So this means we can store data in non-recognized Geographical members (Manly as ..read more