My Oracle Support Banner

FBDI Item Import Performance Issue (Doc ID 2476390.1)

Last updated on JULY 03, 2019

Applies to:

Oracle Fusion Product Hub Cloud Service - Version and later
Information in this document applies to any platform.


FBDI Item Import performance issue
This takes a long time to run.....Running for more than 7 hours and still not completed.

The CSV generates withing seconds and better performance when importing records

The issue can be reproduced at will with the following steps:
1) Prepare the FBDI item template with 400,000 lines
2) Generate zip and csv file (size of zip file is 9MB)
3) Use ESS Job - Load Interface file for import --> Upload a new file --> use the zip file generated from the 2nd step. This process is very quick.
4) Once the above process completes successfully, I go to ESS Job --> Item Import --> Parameters
a)select the Batch Number
b) Delete Processed Rows = Yes
c) Reprocess Error = No


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

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