Supplier Import Performance Issue – Request for Feedback — Cloud Customer Connect
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

Supplier Import Performance Issue – Request for Feedback

in Supplier Management 1 comment

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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