Get Started with Redwood: Oracle Cloud SCM and Purchasing
What is Oracle’s recommendation for handling large BPA data volumes (230 million+ records)?
Summary:
Large BPA volume (230 million records) and its potential impact on system performance. What is Oracle’s recommendation for handling such large data volumes? What are the best practices for loading large volumes of data?
Content (please ensure you mask any confidential information):
We are planning to convert legacy BPA pricing data into Oracle, which is currently stored at the supplier-branch-item level and totals 46 million records. To meet Oracle requirements and accommodate new business scenarios, we need to migrate this data to store BPAs at the supplier site level. If each supplier has an average of five purchasing sites, this will increase our record count to approximately 230 million.
0