Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to extract bulk data from MSC_REGIONS table using BICC

Summary:

There are 81,03,282 records in MSC_REGIONS table which is not achievable to extract all the data in a single file using BIP reports due to the following error - "Report data size of 5368709556 bytes exceeds the maximum limit of 5368709120 bytes"

So, came to know that BICC is one of the alternative approaches for extracting Hugh amounts of data. As part of this approach referred below database lineage mapping spreadsheet for MSC_REGIONS table. Unfortunately, we could not find Business Intelligence View Object for MSC_REGIONS database table in the below link.

R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet i.e.,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!