Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
133
Views
2
Comments
Balasubramanian Chidambaram01
Balasubramanian Chidambaram01 Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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,

Answers

  • Hassan El Bouihi-Oracle
    Hassan El Bouihi-Oracle Rank 6 - Analytics Lead

    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

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    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.