It is common to need to query invoices generated by employees. However, the relationship between the AP_INVOICES_ALL and PER_ALL_PEOPLE_F tables is not straightforward. These tables are connected through the HZ...
Extract User Details from Oracle Fusion involves understanding key tables and their relationships. This guide explains how to Extract User Details from Oracle Fusion efficiently. Key Points to Note: ...
This is a question we often hear—especially from new managers working with Oracle Fusion technical teams. And it’s a great one! Let’s break it down into two simple parts: Part 1: Why Do We Need to Run SQL...
This is one of the most common questions developers ask when they start working with Oracle Cloud: Can they use SQL Developer with Oracle Fusion? Unfortunately, the answer is no. Oracle doesn’t provide di...
If you’re working with Oracle Fusion Cloud and want to run SQL queries directly on the database, you might find it a bit tricky at first. Oracle doesn’t provide direct database access like traditional systems. ...
At CloudSQL Online, our users have run millions of SQL queries. And while most of them fly through just fine, we’ve noticed that around 1 in 10 ends up throwing a syntax or runtime error. Surprising? Not ...
We recently posed a simple question to our most dedicated CloudSQL SQL Editor users: Are you using AI? The answer? No surprises there—everyone has tried ChatGPT or its equivalents at some point. But her...
Oracle BI SQL development plays a crucial role in generating reports and insights from Oracle ERP databases. As an Oracle BI developer, improving efficiency can save valuable time and optimize query performance...
Simplify Access with Single Sign-On (SSO) for Oracle Fusion Cloud ERP and DataFusing CloudSQL Desktop Single Sign-On (SSO) with Oracle Fusion Cloud ERP enhances user convenience and security by allowing seam...
We’re excited to announce the September release of CloudSQL Desktop, packed with numerous improvements and bug fixes to enhance your SQL development experience. Here’s a quick overview of the latest...
We are thrilled to announce that bind variable support is now available in DataFusing CloudSQL Desktop! This new feature enhances your ability to run SQL queries against Oracle Cloud with greater efficiency and...