1. Call BI Report and Send CSV or PDF data over email | How to call Bi report in OIC
Vložit
- čas přidán 5. 09. 2024
- 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 - xyz.xml
File path - /xyzfilepath
Upload 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
Join WhatsApp group for more updates and queries :
chat.whatsapp....
Join for more update:
WhatsApp:
chat.whatsapp....
Telegram:
t.me/oic_oracl...
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
=================================
1. Create BI Report in Oracle Cloud (Without Parameter)
• How to create BI repor...
2. Create BI Report in Oracle Fusion with Parameter
• How to create BI repor...
3. Create BI Report in Oracle Fusion Application with LOV Parameter
• How to create BI repor...
#OIC #integration #oracleintegration #integrationReport