Supplier Import Performance Issue – Request for Feedback

Dear Team,

We are experiencing long processing times for Supplier Import jobs and would like to gather insights from anyone who has faced similar performance issues.

Summary:

• The DEV database size is the same as PROD.
• Supplier header file processing (40k batch for 420k total records) – all 40k batches submitted in parallel and taking over 12 hours.
• Address processing (680k records, 60k batch size) – parallel jobs completed in 14 hours.
• Site processing (680k records, 100k batch size) – parallel jobs completed in 5 hours.
• Site assignment processing (680k records, 100k batch size) – parallel jobs completed in 5 hours.

Oracle's Recommendation: Reduce batch size to 25k for optimization, but this requires submitting multiple jobs.