My Oracle Support Banner

EDLC- 250K Import File Submission Through EDL Takes 2Hrs (Doc ID 2528004.1)

Last updated on DECEMBER 22, 2020

Applies to:

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

Symptoms

On  : 11.13.19.01.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
EDLC- 250K import file submission through EDL takes 2Hrs

Import activity identifier is not getting created after EDL command is submitted through command prompt.It took approximately 2Hrs to create import activity identifier.

  You are trying to submit address file through EDL command which contains 250K records in file. After EDL command is submitted , the process contentiously says "Reading Import File" in command prompt as shown in snapshot. This would remain same for more than 2 Hrs . After 2Hrs it would create an import identifier.

  You are submitting 250K file as single job .During this time there are no other jobs running in parallel in import management.

This issue is occurring for 250K Contact, Address and relationship file.

 

EXPECTED BEHAVIOR
-----------------------
Import activity should be created right away.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit an import job using EDLC command for 250k records in one file
2. The process keeps saying Reading From File for 2hrs
3. Then import is started

BUSINESS IMPACT
-----------------------
There is no business impact mentioned however, the issue is causing performance degradation while importing records.

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.