Steps to create integration to call BI Report : 1. Create REST Adapter Connection to start Integration 2. Create SOAP Adapter Connection to Call BI Report 3. Create Integration 4. Add REST Adapter Connection Add jSON Request format Add jSON Response format 5. Add SOAP Adapter Connection (Between start 6. Start Mapping for SAOP Adapter Connection and set the path and parameters of report 7. Create Write Stage File It will write the report output data and decoded it into this stage file File name - File path - /xyzfilepath Upload file. 8. Map write stage file with SOAP adapter mapper map report byte or SOAP response with opaque 9. Create Read Stage File (from ICS file reference) It will read the data from first stage file which the decoded data. Add file reference from write stage file (ICS file reference) Upload file 10. Map read staging file with end point (last Right Side) Here we are mapping each column with end point Bi report response Join WhatsApp group for more updates and queries : Prerequisite ========== 1. BI Report path 2. Report xml output (to convert in xsd schema) 2. WSDL to call BI Report 3. UserId password of oracle fusion application 4. schema file 5. xsd schema of report xml output ================================= 1. Create BI Report in Oracle Cloud (Without Parameter) 2. Create BI Report in Oracle Fusion with Parameter 3. Create BI Report in Oracle Fusion Application with LOV Parameter #OIC #integration #oracleintegration #integrationReport











