Call BI Report in OIC and Send File on email | Notification in OIC | Integration to Call BI report
Join WhatsApp Group :
https://chat.whatsapp.com/BQiZrZ8w5Mr...
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. opaque.xsd schema file
5. xsd schema of report xml output
=================================
Steps :
1. Create REST Adapter Connection to starte Intergration
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 decored it into this stage file
File name - xyz.xml
File path - /xyzfilepath
Uplod opacque.xsd 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 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
1. Create BI Report in Oracle Cloud (Without Parameter)
• How to create BI report | BI Report i...
2. Create BI Report in Oracle Fusion with Parameter
• How to create BI report with paramete...
3. Create BI Report in Oracle Fusion Application with LOV Parameter
• How to create BI report with LOV para...
#OIC #integration #oracleintegration #integrationReport
