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.
-
ChatGPT for Advanced SQL Queries
In my previous article, I shared my experience with ChatGPT and described how I was able to generate working SQL queries using the tool. If you missed it, you could read the article to learn more about my journey exploring ChatGPT. In today’s article I want to show you how you can…
-
ChatGPT for SQL Queries
You might have already tried out ChatGPT. So have I. Today I wanted to share some of my experiences using ChatGPT. For this post, I will share the results of the questions that I had regarding SQL Queries. I was curious to know if I can get accurate SQL statements.…
-
Connecting OIC ATP Adapter to ATP Database
Connecting OIC ATP Adapter to ATP Database is required to insert data into the ATP Database tables from OIC. In this post I will show you the step-by-step process to configure the adapter. There are two main steps involved in configuring the ATP Adapter in OIC to connect to the…
-
BI Publisher Tutorial Series
Hey everyone. Just a heads-up that I will be creating a new tutorial series on BI Publisher. The tutorial will cover the following: BI Publisher vs OTBI Data Model Create simple Data Model Create Data Model with Parameters Easy way to create an RTF Template e-Text Format Tips and Tricks…
-
Switch Between Views in OTBI
Today’s post is based on a question I received on my YouTube channel. I want to show you how to If you have not checked out the OTBI tutorial video on YouTube, please do. Check out the Part 9 of the tutorial series to understand how to create different views.…
-
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.…
-
Invoke BI Report with Multiple Parameters Using Web Service
Learn how to invoke a BI Report using Web Service and pass multiple parameter values using the ExternalReportWSSService web service.
-
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…
-
Bursting FR Report in Oracle Cloud ERP – Part 2
In the last post, we looked at how to create a new FR Batch. This is needed to schedule the FR Batch. Before reading this post, I highly recommend you read the previous post on how to create a FR Batch. Alright lets go ahead and schedule the batch. Select…
-
Bursting FR Report in Cloud ERP – Part 1
If you have been working with Oracle EPM you may already know that there is an option to perform bursting of FR reports. If you work in ERP, you may already know that you can perform bursting of BI Reports. In the next few blog posts I will try to…