Latest YouTube Videos
Learn how to install Oracle Database 23ai Free on Windows. This is a great way to explore the features of Oracle 23ai Database.
——————
SQL Harmony allows you to connect to your fusion instance and execute SQL Queries. Check out the igh level features of the tool.
——————
Data Pipeline enables you to orchestrate end to end processes in EPM. Learn how to invoke a Pipeline from Groovy.
——————
Dependent List of Values helps you to control the BI Publisher Report parameters based on value of another parameter while exeucuting the reports.
——————
Learn how to attach a list of values to a BI Publisher report parameter. This helps the user to select from a pre-defined list rather than type the value in.
——————
Data Pipeline enables you to perform cross pod file operations easily. There are in-built job types available to move, copy, unzip, rename and delete files.
——————
Latest Blogs
Check out the latest blogs on Oracle ERP, EPM and other related topics.
-
Display Oracle BI Folder Contents
There was a question in Oracle Cloud customer connect forum about fetching all the report names and report path in a given folder. It is rather cumbersome to manually list the report names and path for each and every report in a given folder. In this post I want to…
-
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…
-
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…
-
How to Pass Default Value to Date Parameters in BI Reports
Hey guys this is a quick post about how we can Set default value for date Parameter in the Data Model Pass a default value for the date Parameter while scheduling the BI Report Set Default Value for Date Parameter in BI Report Create a data model and add a…
-
Oracle SQL and PLSQL Beginner Resources
In this post lets take a look at few of the free Oracle SQL and PLSQL Beginner resources. These can also be used by Intermediate and advanced users!! Oracle Dev Gym Here is a great blog by Steven Feuerstein about Oracle Dev Gym. The portal has got 4 main sections:…
-
Apache Hive Deep Dive – Load Data from Local File System
Welcome to the first post of the series called “Apache Hive Deep Dive”. In this post we are going to explore what happens behind the scenes in HDFS when we issue the following commands in Hive: CREATE DATABASE CREATE TABLE LOAD DATA DROP TABLE DROP DATABASE In this exercise, the data will be…
-
Introduction To Apache Hive For SQL Programmers
I have always wondered how someone with SQL knowledge can work in a Big Data environment or to be more precise, in an HDFS environment. Can we use our SQL skills to analyze data? Do we have to learn Java or Map Reduce to do the analysis? After a few years…
-
Setup ActiveTunnel in webMethods Active Transfer
As per SoftwareAG Documentation Through the use of ActiveTunnel, ActiveTransfer provides the ability to conduct high-speed file transfer by dividing a single connection into many connections. Data is delivered in parallel through these tunnel connections and then reassembled and delivered to the intended destination. In this post we will cover…
-
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…
-
Test PBCS REST APIs Using SOAPUI
In this post, we will take a look at how to test Oracle Planning and Budgeting Cloud Service (PBCS) REST APIs using SoapUI. In the example below, we will test the List Files REST API. For more details on the APIs, check out the Oracle Help Center: REST API for…