My Oracle Support Banner

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.

Symptoms

On : 11.13.19.04.0 version, Create Requisition

ACTUAL BEHAVIOR
---------------
 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.


 

EXPECTED BEHAVIOR
-----------------------
Expect import times to be faster

STEPS
-----------------------
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,

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.