My Oracle Support Banner

FBDI Item Import Performance Issue (Doc ID 2476390.1)

Last updated on NOVEMBER 21, 2019

Applies to:

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

Symptoms

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

EXPECTED BEHAVIOR
The CSV generates withing seconds and better performance when importing records

STEPS
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


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.