Oracle Integration Cloud (OIC) Tutorial: Invoke BIP Report and Write Output to FTP Server

[@bgmiorwot5012]

You're the best OIC teacher out here on the internet for sure!

[@atarunraj]

Thank you. Appreciate the kind words.

[@sirajahmad8194]

fantastic video for experienced guys

[@OzieeMate]

Another great video. Your videos made a technical consultant..used to be a functional guy with bit of sql knowledge

[@atarunraj]

I’m humbled

[@prashantciitm]

Really a nice way to explain even for beginners like me in OIC. Thanks Arun.

[@atarunraj]

Thanks for the feedback

[@RAO27197]

Thank You Arun for your detailed explanation

[@sxchau]

very nice and clear explanation. Really this helped a lot

[@vinodkumarkandati2115]

Thank you Arun once again for the very good session.. your videos always effective

[@BudoAmar77]

Top Demo Arun 10/10

[@JenniferOng-h8c]

I am very excited to see videos that I can understand phonetically well for once. The voice volume is very low and tired sounding but I think the content overall is great! I wish I can see more on the mapping since I cannot figure out how to make more modes appear on the Target side to the Source side.

[@atarunraj]

Thank you for the feedback. On the target side you should be able to expand the nodes to reveal more.

[@JenniferOng-h8c]

@@atarunraj I have tried but it's empty and i don't have the option to add target nodes.

[@p51mustang31]

Awesome video! Your instructions are very clear/easy to understand, and you don't rush through the tutorial. I was wondering if Oracle has any official community forums for OIC customers to interact and ask questions? Keep up the great work!

[@atarunraj]

Thanks for the feedback. I will share the link.

[@prasadsupplychain6668]

Hi Raj, Thank you very much. very helpful...

[@atarunraj]

Thanks for the feedback

[@VNTHOTA]

Excellent video

[@krishnachaitanya284]

Thank You, Arun for your detailed explanation, Please create videos on the inbound interface and outbound interface integrations. also, prepare Oracle Integration Cloud Interview Questions questions videos.

[@atarunraj]

Thanks for the feedback. I will create one more video on BIP and then will focus on Inbound integrations.

[@vivekpathak03]

Thanks Arun. Very helpful !

[@atarunraj]

Appreciate the feedback

[@preethivaidhi2815]

Very good explanation - Good work

[@atarunraj]

Thanks for the feedback

[@shopolovers]

Very useful and clear explanation. Could you please make a video for below usecase: Reading a File (csv or other) from a SFTP location or a local file server and performing any actions with the data such as passing it on to Oracle Fusion (SaaS) or transform the data and place it at any destination.

[@atarunraj]

Thank you. Will do more videos on OIC soon.

[@jamalfarooq78]

Hi Arun, thanks again for publishing these video's, it's really give concept for a some one who just started OIC. Could you please publish more video's with complex reports with multiple layout and parameters. Also, some more video's for FBDI step by step with real time example i.e invoice, suppliers, GL etc.

[@atarunraj]

Thanks for the feedback and sure.

[@ninadsharma6151]

Great work Arun! This is gold. I would appreciate if you could elaborate about different kinds of integration styles with examples. It would definitely help beginners like me :). Thank you

[@atarunraj]

Glad you find this helpful. Thank you for the feedback. In the future, I will have a video explaining the different integration types.

[@ganeshwattamwar9268]

Really great video

[@atarunraj]

Glad you enjoyed it. Thanks for the feedback

[@leewook4601]

thanks for such videos.!!! I have a question on js libraries in oic Can we use a csv file as input in the library..... like can we import any file which is created by write stage operation in oic and then do the transformation to that file and return the file as a output? thanks in advance!!

[@vamsikreddy]

Hi Raj, Can you please create a video with invoking a BI report with Parameters and writing to a table in a different server. Also how to massage the data in OIC before it is written to the database.Thank you

[@atarunraj]

sure. This is in the works.

[@Pritamdas-bg7fp]

Hi Arun.. Thanks you for your hard work...please make a video having multiple format

[@atarunraj]

Sure. I can create a video sometime soon.

[@saikumarpadakanti4522]

Hi Arun Thanks for creating video and it is really helpful for beginners like me. Could you pls make one more video with multiple parameters and different formats.

[@atarunraj]

Sure. I will have something up on the channel soon. Thanks for the feedback

[@oraclecloudfusiontechnolog1825]

Nice

[@brightstar1927]

Best Video

[@richardgibson3397]

Hi, great tutorial. At the end of the process I want to call a GL Web Service not the file output, but the mapper doesn't show me the fields to map from BI. Is this because it is a CSV output BI report ? Do have an example of a BI report being called and then a Web service being called ?

[@atarunraj]

Can you provide the high level functionality you are trying to achieve?

[@richardgibson3397]

I want to run a BI Report which extracts journal debit and credit data (at the moment this is CSV output but can be any that works) then decode and call the SOAP API Payload service that creates journals in the GL Open Interface. Example : Sample Payload For Journal Import Service (Doc ID 2181608.1) In the OIC mapper is see the GL API fields to map TO but FROM the BI report no tags to map from the report in reportbytes ? I guess it is to with the BI report output format ? The formats I have available are :- Interactive, HTML, PDF, RTF, Word, Excel (mhtml), Excel (html), Excel (*.xls), powerpoint, MHTML, PDF/A, PDF/X, Zipped PDFs, FO Formatted XML and Data (XML). Any help really appreciated @@atarunraj

[@shakthik1172]

Great Video, From BIP we will be able to submit the report to UCM directly , can we do the same using integration with submit report operation of SOAP request ?

[@sowmyar9228]

Hi Arun, thanks for the video. Is there any way to write to SFTP location without the decodebase64toFileReference

[@anupsingh-mw6cc]

while creating SOAP adapter connection, where do we get the WSDL url from?

[@cristopherriverarodriguez211]

Hello, your videos are really very good, I wanted to ask you if you have any video on how to load data, metadata to EPM Cloud (Planning) using OIC

[@atarunraj]

Sure I can make a video for data load and metadata load.

[@cristopherriverarodriguez211]

@@atarunraj Thank you very much, I will be waiting for that video

[@navyaindu4009]

Hi Arun.Thank you for this video. Nice explanation. Where did you get the WSDL, can we use REST instead of SOAP in this case and why the sizeofdatachunkdownload is '-1'?

[@atarunraj]

Hi Navya. The WSDL can be generated in a few clicks. I don’t believe there is a way to invoke a ERP cloud BI Publisher report using a REST API. Hence SOAP. I have noticed that if you the value as -1 it will generate the entire report output.

[@hrshtptl611]

Can we read the excel file from FTP/SFTP and input as a parameter values then invoke the report? @Arun Raj

[@denislanglois-externe6286]

Hi Arun, do you have sample for big report output receive from SOAP I got this error CASDK-0059: Unable to process the response received from the client application. The response received by the OIC integration flow is rejected The response received has been rejected since the content received of length 14486590 bytes exceeds the maximum allowed threshold of 10485760 bytes (10 MB)

[@atarunraj]

Great question. It’s a known limitation. Using this process you cannot process files larger than 10 MB. You may want to look at other options. Here is a great tutorial on Bulk Data Extract. I may make a video later on this. Let me know if this helps. antonyjr.github.io/Hands-On-Labs/ERP-Integration-Patterns/html/erp-cloud-extracts-simple.html

[@romanticvideos9134]

Hi Arun, ESS job integration can we call through SOAP adapter?

[@atarunraj]

Can you expand on your question?

[@dharmender82]

Hi Arun- where did you get that WSDL from which you used in Soa Adaptor.

[@atarunraj]

Great question. If you have access to a SaaS instance you should be able to generate a WSDL. Connect with me on Twitter / LinkedIn / Slack and I can share more details.

[@prasantharavindramesh1078]

Awesome Video sir.Just one question.Why we are using Soap adapter to fetch bip report from erp?

[@atarunraj]

Thanks for the feedback. At this moment the only way to invoke a BIP report is using Web Services. To invoke the web services we need to use the SOAP Adapter.

[@nitheshg2082]

Can we use rest adapter also instead of this ?

[@kattasrihari7332]

Waiting for next video, how to bi report which is having parameters

[@atarunraj]

In the making. Should be live next week

[@dhanalakshmigundlapalli6405]

Thanks Arun, It is very helpful., I have one question, that can we generate output in pdf format. I need to send output in pdf format through email. is it possible, please suggest.

[@atarunraj]

Thanks for the feedback. You can generate the pdf output. I might create another tutorial on that soon.

[@jayanth9664]

How to handle the exception ?

[@PMule21]

How to call Bi report greater than 10 MB from oic...How to handle the situtation where report byte size is greater than 10 MB?

[@atarunraj]

Hi Pooja. Here is a great step by step tutorial on extracting bulk data. I may make a video later on this. Let me know if this helps. antonyjr.github.io/Hands-On-Labs/ERP-Integration-Patterns/html/erp-cloud-extracts-simple.html

[@nitheshg2082]

If the data is more than 10 mb ,u can use DOWNLOAD FILE option or even u can use READ FILE BY SEGMENTS

[@min1232]

Please show with multiple parameters

[@Shreyan_reddy]

Excellent 👍

[@TheGgah]

Nice