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.
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!
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.
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.
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
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.
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!!
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
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 ?
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'?
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.
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 ?
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
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.
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.
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.
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)
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
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
You're the best OIC teacher out here on the internet for sure!
Thank you. Appreciate the kind words.
Another great video.
Your videos made a technical consultant..used to be a functional guy with bit of sql knowledge
I’m humbled
fantastic video for experienced guys
Really a nice way to explain even for beginners like me in OIC. Thanks Arun.
Thanks for the feedback
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.
Thank you for the feedback. On the target side you should be able to expand the nodes to reveal more.
@@atarunraj I have tried but it's empty and i don't have the option to add target nodes.
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!
Thanks for the feedback. I will share the link.
Thank you Arun once again for the very good session.. your videos always effective
Thank You Arun for your detailed explanation
Top Demo Arun 10/10
very nice and clear explanation. Really this helped a lot
Excellent video
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.
Thanks for the feedback. I will create one more video on BIP and then will focus on Inbound integrations.
Hi Raj, Thank you very much. very helpful...
Thanks for the feedback
Very good explanation - Good work
Thanks for the feedback
Thanks Arun. Very helpful !
Appreciate the feedback
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.
Thanks for the feedback and sure.
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.
Thank you. Will do more videos on OIC soon.
Really great video
Glad you enjoyed it. Thanks for the feedback
Nice
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
Glad you find this helpful. Thank you for the feedback. In the future, I will have a video explaining the different integration types.
Best Video
Hi Arun.. Thanks you for your hard work...please make a video having multiple format
Sure. I can create a video sometime soon.
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.
Sure. I will have something up on the channel soon. Thanks for the feedback
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!!
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
sure. This is in the works.
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 ?
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'?
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.
while creating SOAP adapter connection, where do we get the WSDL url from?
Hi Arun, thanks for the video. Is there any way to write to SFTP location without the decodebase64toFileReference
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 ?
Can you provide the high level functionality you are trying to achieve?
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
Can we read the excel file from FTP/SFTP and input as a parameter values then invoke the report? @Arun Raj
Awesome Video sir.Just one question.Why we are using Soap adapter to fetch bip report from erp?
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.
Can we use rest adapter also instead of this ?
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
Sure I can make a video for data load and metadata load.
@@atarunraj Thank you very much, I will be waiting for that video
Hi Arun,
ESS job integration can we call through SOAP adapter?
Can you expand on your question?
Hi Arun- where did you get that WSDL from which you used in Soa Adaptor.
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.
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.
Thanks for the feedback. You can generate the pdf output. I might create another tutorial on that soon.
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)
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
Waiting for next video, how to bi report which is having parameters
In the making. Should be live next week
How to handle the exception ?
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?
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
If the data is more than 10 mb ,u can use DOWNLOAD FILE option or even u can use READ FILE BY SEGMENTS
Please show with multiple parameters
Excellent 👍
Nice