Category: Oracle Planning
-
Oracle ARCS Transaction Matching Data Model
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…
-
Load Balances in Oracle ARCS using EPM Automate
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. Prerequisites Access to Oracle ARCS EPM Automate has been installed Basic understanding of EPM Automate and ARCS There are two ways to import balances (Source and Sub…
-
Load Data From Oracle Cloud ERP to Oracle EPM using PowerShell
Before we start, I am assuming that you have some knowledge of PowerShell and EPM Automate commands. I am also assuming that EPM Automate is installed on your system and that you have setup the import jobs in your EPM instance to import the data file. In this post we are looking at how to…
-
Python and EPM REST APIs
One of the best things that have happened over the last few years for Oracle EPM consultants is the availability of REST APIs. I have written about it in my previous post on using Groovy and PBCS REST APIs. However, today I wanted to present my experience on using Python and EPM REST APIs. This…
-
PBCS REST APIs Using Groovy Scripts
In this post we will try to cover the basics of using PBCS / EPBCS REST APIs using Groovy Scripts. Most of you may have used EPM Automate utility in your day to day activities. Although it is a great tool, it has its limitations. So lets see how we can use PBCS REST APIs.…