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

Подписаться 4,1 тыс.

Просмотров 16 тыс.

50% 1

We will cover the following topics:
- Create FTP Adapter Connection
- Create SOAP Adapter connection
- Create Integration
- Invoke BI Publisher Report
- Base64 Decode
- Write File to FTP Server
- Test the Integration
#oic #oracle #integrations
Medium Articles on BI Publisher Web Services:
- tinyurl.com/2dbfu7t2
- tinyurl.com/u85p6pb8
- tinyurl.com/9xj98khz
- tinyurl.com/37kavy4v
-------------------------------------------------------------------------------------------------------------------
Let me know your suggestions and feedback!!
Listen to My Podcast:
-----------------------------------
Google Podcast: bit.ly/2RD7VIt
Spotify: spoti.fi/3wr1IhE
Connect with me
--------------------------
LinkedIn - bit.ly/3eFhI6V
Twitter - bit.ly/3dC2rCz
My Blog - quest4apps.com
Medium - bit.ly/3dFhQSX

Опубликовано:

22 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 72

@bgmiorwot5012 2 года назад

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

@atarunraj 2 года назад

Thank you. Appreciate the kind words.

@prasadsupplychain6668 Год назад

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

@atarunraj Год назад

Thanks for the feedback

@RAO27197 2 года назад

Thank You Arun for your detailed explanation

@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

@BudoAmar77 2 года назад

Top Demo Arun 10/10

@prashantciitm Год назад

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

@atarunraj Год назад

Thanks for the feedback

@user-zz3ge2jd5k 9 месяцев назад

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 9 месяцев назад

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

@user-zz3ge2jd5k 9 месяцев назад

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

@sirajahmad8194 Год назад

fantastic video for experienced guys

@sxchau 2 года назад

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

@TheGgah Год назад

Nice

@VNTHOTA 2 года назад

Excellent video

@Shreyan_reddy Год назад

Excellent 👍

@vivekpathak03 2 года назад

Thanks Arun. Very helpful !

@atarunraj 2 года назад

Appreciate the feedback

@brightstar1927 2 года назад

Best Video

@preethivaidhi2815 2 года назад

Very good explanation - Good work

@atarunraj 2 года назад

Thanks for the feedback

@krishnachaitanya284 2 года назад

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 2 года назад

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

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

@ninadsharma6151 2 года назад

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 2 года назад

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

@ganeshwattamwar9268 2 года назад

Really great video

@atarunraj 2 года назад

Glad you enjoyed it. Thanks for the feedback

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

@shopolovers 2 года назад

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 2 года назад

Thank you. Will do more videos on OIC soon.

@saikumarpadakanti4522 2 года назад

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 2 года назад

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

@Pritamdas-bg7fp 2 года назад

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

@atarunraj 2 года назад

Sure. I can create a video sometime soon.

@leewook4601 2 года назад

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

@sowmyar9228 2 года назад

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

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

@shakthik1172 2 года назад

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 ?

@anupsingh-mw6cc Год назад

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

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

@denislanglois-externe6286 2 года назад

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 2 года назад

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

@richardgibson3397 5 месяцев назад

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 5 месяцев назад

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

@richardgibson3397 5 месяцев назад

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

@dharmender82 2 года назад

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

@atarunraj 2 года назад

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.

@hrshtptl611 2 года назад

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

@cristopherriverarodriguez211 2 года назад

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 2 года назад

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

@cristopherriverarodriguez211 2 года назад

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

@prasantharavindramesh1078 2 года назад

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

@atarunraj 2 года назад

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 2 года назад

Can we use rest adapter also instead of this ?

@kattasrihari7332 2 года назад

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

@atarunraj 2 года назад

In the making. Should be live next week

@dhanalakshmigundlapalli6405 2 года назад

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 2 года назад

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 2 года назад

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 2 года назад

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 2 года назад

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