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
General In the previous post we have presented a generic OIC integration that can receive an SQL parameter and return JSON array result,The solution presented… Read More »Fusion SaaS: improved method for running SQL queries by using generic OIC integration and BIP lexicals
General Custom Objects in Fusion SaaS are very useful feature allowing customers to add their own data and use it together with existing Oracle provided… Read More »Fusion SaaS BIP: Utilize lexical feature to improve Custom Object SQL access
General Oracle Fusion SaaS provides seeded BIP reports which can be customized by using the Customize option in BIP catalog.This option allows to use standard… Read More »Fusion SaaS: Add additional parameter to standard report without duplicating the ESS job
General Importing external files into Oracle Fusion SaaS is a common requirement. Oracle provides HDL and FBDI that perform efficient pre-validations on input files before… Read More »Fusion SaaS: Perform efficient SQL validation for incoming files by using Custom Object CLOB fields, OIC and BIP
General Oracle BI Publisher allows generation of PDF outputs with dynamically embedded images. This post will demonstrate how OIC can be used inside a BIP… Read More »Procurement SaaS: Display Buyer’s Signature From Document of Records in a PO PDF Report
General Following the post showing the method of running BIP SQL reports from Visual Builder Extension described here, we have built a generic solution that… Read More »Visual Builder Extension for Fusion SaaS: speed up development process by using generic REST SQL query utility
General Using of OIC for exposing BIP reports to Visual Builder Application is a quite common approach. However when we develop SaaS extensions we have… Read More »Visual Builder Extension for Fusion SaaS: utilize BIP SQL queries by using Groovy and OIC
Check out the new free chrome extension we have just published! https://chromewebstore.google.com/detail/cid-fusion-query/dpcoolkekdoenbgfdfglcljcpddhihfd To use this extension, follow the next steps: 1. Install the extension and… Read More »Oracle Fusion SaaS free SQL query tool
Business Need There are cases when Oracle Fusion SaaS user would like to invoke a BIP report, pass it user file as a parameter and… Read More »Oracle Fusion SaaS BIP Report: Combine SQL reports with user’s manually uploaded files
