With the release of EPM 21.04 version update you can now send custom emails from EPM using EPM Automate or EPM REST APIs. You can read more about the new release in Mark Rinaldi’s update.
Make sure to upgrade to the latest version of EPM Automate.
With EPM automate you can use the “sendMail” command to
epmautomate login username password url
epmautomate sendMail firstname.lastname@example.org "Data Load Finished" Body="Data Load Finished at 9 AM EST"
epmautomate login username password url
epmautomate sendMail email@example.com…
I had the opportunity to try out ODA for EPM and it looks great. Here is how to get started. Thanks to Mike Casey, Pat Malay and Joe Huang for the wonderful session.
The ODA for EPM is available for FCCS and ARCS currently. ODA will be available for other EPM offerings in the future.
First things first, you need access to an ODA Instance. Once you login, navigate to the Development > Store.
The SWP offering from Oracle is more geared towards the HR users. It acts as a collaborative platform between Finance, HR and Executive leadership team. There are two main modules within SWP offering — Head Count Planning and Labor Cost Planning. I will be focusing more on the Head Count Planning module of SWP in this article.
Labor cost planning is the same offering as what we have in Planning (Workforce Planning module).
Executive leadership team decides the long term goals. It could be net new expansion or developing a new product or entering a new market etc. …
As you may already know, I love using Python to work with Oracle Cloud EPM REST APIs. Today I wanted to share the code snippet that can be used to search for a file in EPM. Under the hood is the “List Files” REST API. You can read more about the API here.
Here is the code snippet for the function. The function has one input, which is the file name to be searched for in EPM.
I have written detailed blogs about how to invoke Oracle BI Publish Report using Web Services. Recently there was a question in Cloud Customer Connect forum regarding how to pass multiple values for a specific parameter while invoking the Web Services call. I was able to answer that question. So here is how you.
Please read my blog “Invoke Oracle BI Report using Web Services” to understand the basics of using ExternalReportWSSService web services end point to invoke an Oracle BI Publisher Report. …
Oracle Fusion Security Console allows a convenient way to manage the PGP keys. Let me walk you through the process.
Pretty Good Privacy is an encryption program that provides cryptographic privacy and authentication for data communication. PGP is used for signing, encrypting, and decrypting texts, e-mails, files, directories, and whole disk partitions and to increase the security of e-mail communications. Phil Zimmermann developed PGP in 1991.
— Source Wikipedia
Navigate to Security Console : Tools > Security Console > Certificates
You will see two options here.
There is a new version of EPM Automate as part of 21.05 update. The update is available in your EPM TEST instances.
Make sure to upgrade EPM Automate to the latest version. Lets take a look at some of the new features.
I am really excited about this one. You can now use shortened URLs in the login command.
Earlier you had to provide the complete URL to the EPM instance while using the “epmautomate login” command.
epmautomate login <username> <password> https://test-cloud-pln.pbcs.us1.oraclecloud.com
As part of the 21.05 update, you have the option of shortening the URL using bitly, tinyurl or…
Oracle provides web services to invoke and retrieve data from OTBI (Oracle Transactional Business Intelligence) Analysis. Let’s see how in this post.
For a complete list of available web services check out Oracle documentation. We will be focusing on two services and 3 methods.
Let’s first login and create a session. Use the below code snippet and provide the correct user name and password.
Web Services URL to be used — https://hostname/analytics-ws/saw.dll?SoapImpl=nQSessionService
The return message will have session id field. The session Id will be passed in the executeXMLQuery method call.
You should have the path to the…
In this article lets see the different ways we can load data into Transaction Matching module in Oracle Account Reconciliation Cloud Service (ARCS). Click here to know more about Oracle ARCS and feel free to connect with me if you have questions on implementing Transaction Matching in Oracle ARCS.
So what are the 4 different ways and let’s take a look at each one in detail.
If you have a pre-formatted file then navigate to “Application > Jobs > Transaction Matching”. Click on Actions > Import Transactions. …
In this post let’s try to understand the Transaction Matching module data model. Unlike other Oracle EPM products, ARCS (Account Reconciliation Cloud Service) uses relational database. So we have tables and views and it is pretty easy to create custom reports using BI Publisher. This opens up lot of possibilities. If you are interested to learn more about creating custom reports in ARCS, check out my YouTube tutorial series.
For most updated list of tables and views, you can check out the Oracle Documentation here.
There are 19 pre-defined tables at the time of writing this blog. Here are a…