how to call BI report in OIC | OIC integration to call BI report

[@sayeed321in]

You have explained the concepts so clear like a Pro.. Thank you for sharing the knowledge.

[@foxoracleappssolutions]

Thanks,
You can visit latest video for more

[@dhirajsinha4869]

Good explanation. Keep it up and make more video with LOV Parameter.

[@foxoracleappssolutions]

Sure

[@foxoracleappssolutions]

Yes, we will create video on that soon.

[@CR1985-mb1]

Good explanation. Keep it up.

[@foxoracleappssolutions]

Thanks 🙏👍

[@SOUMIKGHOSHsoghosh4]

By any change can you please share the resources you used as prerequisites. This will help us to build the similar hands-on.

[@foxoracleappssolutions]

Sure

[@Chandreshsharma1]

Nice videos Sir.

[@foxoracleappssolutions]

Thanks for your support.

[@vasutota1431]

Excellent , Nice end to end video

[@foxoracleappssolutions]

Thanks 👍

[@Aishwarya-hq2bx]

what is the need of REST service you can directly use soap adapter only to call the report and map the data right?

[@safar70]

Thanks for this video👍

[@foxoracleappssolutions]

Thanks for your support.

[@JohnPhilipEspia]

Thank you!

[@foxoracleappssolutions]

You're welcome!
Keep you support

[@omarmcf]

Hello i didn't understand how you create the WSDL URL for the SOAP connection, can you please make more light on that ?

[@foxoracleappssolutions]

For calling the BI report, we required SOAp webseries.
So that WSDL link is the SOAP API to call bi report.

[@chandrakanth1335]

Hi sir, thankyou for your explanation.
I have two queries.
First regarding the output paylod. why did add the columns twice ??
Second one I have added the WSDL link to the fusion URL but it is not working

[@foxoracleappssolutions]

Thanks,
To make is arrays,
check the url again.

[@atchutapss4341]

I didn't see any explains the concepts. I need concepts, please share any video if you have

[@foxoracleappssolutions]

Please check
th-cam.com/play/PL3X62LScvI_L6y1_Vyu4apFyaYbH3tLbY.html

[@VibeTribe786]

Is that WSDL link same for every soap invoke connection , and second question is:
you added that Googled WSDL to your fusion URL right, so we have to add the WSDL to the URL of the instance we use, in your case it's fusion. Am I right 🤔 plz give clear explanation

[@foxoracleappssolutions]

Yes, its true that on which fusion instance you have to perform operation you need to add that url only.
Yes, for BI Report call, WSDL is same.
for different-different transaction, WSDL will be different, like for creating purchase order we have different WSDL.

[@TM-rc5xb]

@@foxoracleappssolutions can you explain how to fix this error? I followed same steps n when I add write/read stage steps into my integration, I get this error - "Error Message
Error while translating message to the mentioned format.
,detail=: XML-20108: (Fatal Error) Start of root element expected.}
cause: {: XML-20108: (Fatal Error) Start of root element expected.}"
Without read/write stage, if I just generate encoded base64 output, Integration succeeds but not this way when I try to decode n get the output

[@AlanaHarmon-s6u]

I don't have a SCHEDULE on the MORE dropdown for the location.

[@459naren]

Nice

[@foxoracleappssolutions]

Thanks

[@Aishwarya-hq2bx]

How do you decide when to use soap and when to use rest servives?

[@romanticvideos9134]

hi what is use of
"sizeOfdatachunkDownload" "-1" ?
can you explain Sir.

[@MuddasserQureshi-hu5hu]

can you plz mention the link of header, line and propertise file

[@foxoracleappssolutions]

Sure

[@memories139]

Is it possible to call invoice data BIP report using oic and create in fusion again

[@foxoracleappssolutions]

Yes,
Call bi report to get data, and then use REST api to create invoice.

[@siddheshtawde4410]

@@foxoracleappssolutions do you have any video or tutorials for same requirements..

[@foxoracleappssolutions]

Please check this for creating AP invoice using REST api
th-cam.com/video/QubRuWVk2oY/w-d-xo.html

[@aarifful]

I am having below error on readstage file action : ,detail=<Line 1, Column 1>: XML-20108: (Fatal Error) Start of root element expected.}
cause: {: XML-20108: (Fatal Error) Start of root element expected.}
I am stuck please help. I configure filename and directory was you mention in your video and use reference in readfile activity. and add xsd file. Please guide

[@foxoracleappssolutions]

Hope you got the solution

[@coooolchick]

I am facing the same error. Can you please help? How did you resolve it ?

[@TM-rc5xb]

Anyone explain how to fix this error? I followed same steps n when I add write/read stage steps into my integration, I get this error - "Error Message
Error while translating message to the mentioned format.
,detail=<Line 1, Column 1>: XML-20108: (Fatal Error) Start of root element expected.}
cause: {: XML-20108: (Fatal Error) Start of root element expected.}"

[@gopilinga9705]

how to access more than 10 mb data from bip reports in oic

[@foxoracleappssolutions]

Use Read in segment stage file instead of read entire file

[@soumyamallick80]

how to invoke bi report with no parameters from oic

[@webdevtutorials6579]

i dont understand why did you use POST for the rest connection, why not GET, you said we're going to use POST as we're going to post data, idk what you mean by that

[@foxoracleappssolutions]

We used PoST so that we can configure requests and response payload

[@webdevtutorials6579]

ah ok, the parameters

[@5c11neelabhkarthikganti2]

what if i dont have any parameters and directly call the bI report .. can we use get