1. Call BI Report and Send CSV or PDF data over email | How to call Bi report in OIC

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 path - /xyzfilepath
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 XML.xsd 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 :
Join for more update:
WhatsApp:
Telegram:

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
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

[pammu_soul]

Hey Aeron,
Your videos are really helping to learn the Oracle Fusion and Oracle Integration.

Do you have previously created Oracle BI Report which is associated to this Integration?? I tried to create this Integration BIP report is showing me CSV format however when I am invoking from OIC its giving me HTML format.

In BIP Report, CSV is the only default output format and
In OIC, attributeFormat value is CSV


Not sure, what went wrong.

[soumyamallick]

how to build oic invoke bip report with no parametrs

[VibeTribe]

So just giving filename as .CSV we get in that file format, we don't need to do read file operation by using xsd schema as said in some call bi report,
Or is there anything i missed in that video 🤔???

[ramyas]

In case we didn't get any data from the bip report that's the case on how to handle it in oic

[estephanybonilla]

Hello, question... Would I have to create a second SOAP with pdf if I want both a pdf and csv file?