Strategy for Loading High Volume Data for Item On Hand Serial Numbers > 20 Million
Summary:
Strategy for Loading High Volume Data for Item On Hand Serial Numbers > 20 Million
Content (please ensure you mask any confidential information):
Hi,
We have 23 Million Serial Numbers as part of our Data Load for Inventory On Hand Serial Numbers
Some Item and Stock Locator combinations have more than 200K Serial Numbers.
Can you advise on how we can load this high volume?
1) What is the max volume we can use in one Batch for Inventory On Hand Serial Number?
2) Can we do parallel loads?
3) How can we perform recon via BIP in this scenario?
4) What is the recommendation from Oracle in such cases?