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 Oracle Visual Builder Studio allows us to extend existing Visual Builder screens or create new App UIs. The automatically provisioned backends allow convenient access… Read More »Visual Builder Extension for Fusion SaaS: submit ESS jobs directly from Visual Builder
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
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
