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.
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…
In a previous article I wrote about how you can invoke an Oracle BI Report using ExternalReportWSSService Web Service. You may read it here.
In the article I have an example of a BI Report with a single parameter. I had a very interesting question from a reader asking about how we pass parameter values if there are more than one report parameter. So here it is.
Access to Oracle BI Server
The only difference between various scenarios is the…
In this post we will understand how to import Balances into Oracle Account Reconciliation Cloud using EPM Automate. To learn more about Oracle ARCS head over to Oracle Documentation.
There are two ways to import balances (Source and Sub System) data into ARCS. Those are using Pre-Mapped Balances and using Data Management.
Loading Pre Mapped Balances
The data file is formatted in a specific format and is ready to be consumed by ARCS. The file has to be comma delimited or tab delimited file. The…
Manager Strategic Cloud Services (Oracle Cloud ERP, EPM), Integration Specialist, Big Data, Data Science & Python Enthusiast)