Fusion SaaS: Perform efficient SQL validation for incoming files by using Custom Object CLOB fields, OIC and BIP
General Importing external files into Oracle Fusion SaaS is a common requirement. Oracle provides HDL and FBDI that perform efficient…
Visual Builder Extension for Fusion SaaS: speed up development process by using generic REST SQL query utility
General Following the post showing the method of running BIP SQL reports from Visual Builder Extension described here, we have…
Visual Builder Extension for Fusion SaaS: utilize BIP SQL queries by using Groovy and OIC
General Using of OIC for exposing BIP reports to Visual Builder Application is a quite common approach. However when we…
OIC: minimize impact for online users by utilization of ESS job for running BIP queries
Business Need Using SQL queries executed by BI Publisher engine against Fusion SaaS database is a common practice in integration…
Allow Fusion Cloud ERP users to upload an input file and process it by an OIC integration
Business Scenario Oracle Fusion Cloud ERP user needs an option to upload a CSV file from his desktop and perform…