PRC:SSP: Need To Improve Requisition Import Timing For A Load Of 100k Records
(Doc ID 2597083.1)
Last updated on JANUARY 07, 2020
Applies to:Oracle Fusion Self Service Procurement Cloud Service - Version 11.13.19.04.0 and later
Oracle Fusion Self Service Procurement - Version 11.13.18.05.0 and later
Information in this document applies to any platform.
On : 11.13.19.04.0 version, Create Requisition
Need a way to improve requisition import timing for a load of 100k records
We are currently seeing a business process where the users require to load around 100K lines in the system through FBDI process, the time taken to complete this is around 8 hours, we are looking for a way to lower this runtime and improve the performance, can you suggest us some way out here through which we can reduce this timing like using some parallel processing or increasing the batch size?
The current batch size which we are using for the import is 2500.
Expect import times to be faster
The issue can be reproduced at will with the following steps:
1. load around 100K lines in the system through FBDI process
2. observe import time takes around 8 hours,
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document