SQL

CID Fusion Query v3.0.0 — Free Chrome Extension for Oracle Fusion Developers and Business Analysts

🚀 Version 3.0.0 ✨ Key Highlights 🛠️ Improvements & Fixes Improved UI responsiveness. Significant performance overhead reduction.

Difficulty: Advanced TL;DR We brought the full power of SQL into Fusion AI Agent Studio. Once the action below is in place, a business analyst… Read More »Fusion AI Agent Studio: Run SQL directly from an agent by using an Application Composer Business Object Function

🚀 Version 2.8.0 – Large Query Support! 📊 Large Query Support: Execute queries up to 320K characters – 10x larger than the previous 32K limit! We… Read More »CID Fusion Query v2.8.0 — Free Chrome Extension for Oracle Fusion Developers and Business Analysts

General According to Oracle documentation, the objects developers can access inside Order Management (OM) extensions are limited. The full accessible list is described in this… Read More »Overcome newly introduced limitation of using SQL inside OM Extensions by using BIP and OIC

Business Challenge Oracle Fusion provides a very powerful framework for executing custom Groovy functions via scheduled ESS jobs.However, according to official documentation, you cannot pass… Read More »Create Parametrized Custom ESS Jobs Running Scheduled Custom Groovy Function

🚀 Version 2.7.0 – Enhanced Explain Plan with Download! ✨ New Features: 🔍 Generate Explain Plans: Ability to generate explain plan to allow analysis and… Read More »CID Fusion Query v2.7.0 — Free Chrome Extension for Oracle Fusion Developers and Business Analysts

Introduction Oracle Fusion Applications provide robust reporting capabilities through Oracle BI Publisher (BIP). Often, organizations require sending report outputs directly to the user who triggered… Read More »Fusion Apps: Send Report Output to Currently Running User by Using BIP Bursting Engine

Introduction Oracle Fusion Applications provide robust customization capabilities, allowing implementors and developers to create Custom Objects within CRM Cloud, ERP, and SCM Cloud using the… Read More »Fusion Apps: Identify & Troubleshoot Slow Access to Custom Objects

New Version Announcement We are glad to share that a new version of our free Chrome extension for querying the Fusion SaaS database has been… Read More »New version of our free Chrome extension for querying Fusion SaaS DB

General In the previous post we have improved the solution allowing running SQL queries from VB AppUIs by utilizing BIP lexicals.The solution was based on… Read More »Fusion SaaS: Implement P2T hassle-free generic SQL query REST utility for VB AppUIs by using BIP and App Composer