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 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 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
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 very powerful feature of Custom Objects. The feature allows creation of fields, triggers, actions and pages by using… Read More »Create instance independent Custom Object SQL queries in Oracle Fusion SaaS
Business Scenario Oracle Fusion Cloud ERP user needs an option to upload a CSV file from his desktop and perform a custom processing on it… Read More »Allow Fusion Cloud ERP users to upload an input file and process it by an OIC integration
