Data Limit/size when we use BIP Report by calling SOAP Web Service in Fusion OIC layer

Question

We are planning to Use BIP query to get the data from Fusion Order Management and Receivables by Sales order within OIC integration.

We are storing batch number in ATTRIBUT4 column of Invoice line table, for example 2000 AR lines will have the same batch number and  If we pass Batch number from OIC so we are expecting single call will fetch 2000 lines. just wanted to know if there is any data limit or if this much data can be retrieved by that BIP call in one go or it will create the issue ? any documentation link or answer would be highly appreciated.

Thanks in advance for your help !

Regards,

MandeepGupta · Answer

Hi Bala,

I would suggest you to raise this query on customer connect → integration forum to hear from integration experts or people who may have faced a similar challenge:

Integration — Cloud Customer Connect

Thanks.

Hassan El Bouihi-Oracle · Answer

Hello Bala,

The BIP webservice calls are not meant for large data retrieval. If the report is rendering a large data set, you may have to schedule the report and then use the chunking feature.

Refer to the following document for further information:

https://www.oracle.com/technetwork/middleware/bi-publisher/bipublisher-oracleforms11g-intg-1954401.pdf