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 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 has a pre-configured backends for REST API available in Fusion Apps.Not all business entities that allow attachment management in UI… Read More »Visual Builder Extension for Fusion SaaS: upload an attachment without existing REST API endpoint
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
Business Need Using SQL queries executed by BI Publisher engine against Fusion SaaS database is a common practice in integration development, however it should be… Read More »OIC: minimize impact for online users by utilization of ESS job for running BIP queries
Business Requirement and Challenges Oracle BICC is a powerful tool allowing extraction of full or incremental data from SaaS public ViewObjects for subsequent loads to… Read More »Trigger BICC Extract from an OIC integration
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
