As part of the data migration process, when you are moving financial data from your legacy system to Oracle ERP Cloud, you might need to import journals in bulk. We often use File-Based Data Import (FBDI) for this purpose. In is blog I’ll discuss how the process of importing journals into Oracle Fusion using FBDI. On a high-level, the following
Read more
I have been thinking of writing a series of blogs about Integrating Oracle APEX with Oracle E-Business Suite, for quiet a while now. When I saw the following post from Tim Hall couple of weeks ago, I said to myself that there is no better way to pay tribute to the great man, #JoelKallman, by writing something about the application
Read more
In one of my previous posts, I showed how to install Oracle Database 21c on Linux 7. In this post, I will show the step-by-step process of how to install and set up an Oracle Database 19c on Oracle Linux 8. For most of my installs, I use Linux 7. This is the first time I used Oracle Linux 8.
Read more
Oracle have released Oracle Database 21c Express Edition on Linux. Oracle Express Edition or XE is the free to use version of the database. You can download it from the following link: https://www.oracle.com/database/technologies/xe-downloads.html In one of my previous posts, I demonstrated how to install Oracle Database 21c on Linux 7. In this post, I will show a step-by-step process of
Read more
Very often, there is a requirement to change the corporate branding, from the standard Oracle logo to the logo of the company or customer. How do we do this? In this post, I’ll show you how. The corporate branding image is visible at two places. On the top-left corner of the Home Page after you login into an E-Business Suite
Read more
In my previous post, I showed how to rotate rows into column using the PIVOT operation in Oracle. I pivoted a single measure and dimension. But wait! When we create a PIVOT Table in spreadsheet, we get additional aggregated columns, a. showing the total quantity of items ordered across all organizations in each quarter, and b. showing the total quantity
Read more
Creating a “Pivot Table” using a spreadsheet is pretty straight forward, and it enables you to transpose rows into columns. But, can we do the same operation using Oracle SQL? Yes, it can be done, indeed. The pivot_clause of the Select statement serves this purpose. It enables us to rotate rows into columns, aggregate the data in the process of
Read more
Oracle has released the On-Premise version of Oracle Database 21c ( only on Linux for now ), last week. You can download it from either MOS or Oracle edelivery: https://www.oracle.com/database/technologies/oracle-database-software-downloads.html https://edelivery.oracle.com This release is an “Innovation Release”, which means it comes with only 2 years of Premier Support and no extended support, as opposed to a “Long Term Release” which
Read more
RishOraDev's Oracle Blogs 