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
Utilize Application Composer for creation of complex queries invoked from VBCS Extension for Fusion SaaS
Business Need In previous post https://cidsolutions.co.il/2023/07/18/create-instance-independent-custom-object-sql-queries-in-oracle-fusion-saas/ we described the method to overcome the issue of different mapping between logical custom field name to its mapped… Read More »Improved method for writing instance independent SQL queries over custom objects in Fusion SaaS
Business Need Oracle Fusion SaaS provides a powerful option of creating custom objects to to satisfy various customer business requirement. Requirement example: In the lifecycle… Read More »Create efficient update screens for Fusion SaaS custom objects by using VBCS and Groovy formulas
