Admin Induction - Async Process Taking Long Time (Doc ID 2904139.1)

Last updated on MARCH 20, 2024

Applies to:

Symptoms

Admin induction - Async process taking long time

When trying to load fif_gl_cross_ref via template upload, the spreadsheet has 0.8 million records, it has been 7+ hours, the process shows 'New' in tracker and 'I' status in async job status. No records are loaded into staging table nor any errors.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into MFCS
2. Tasks - Foundation Data > Upload Foundation Data.
3. Upload a spreadsheet with high volume of records
Note: The records are set to process Async

As the initial process was not moving, they retried loading in chunks, 1st chunk loaded, 2nd chunk is stuck again and 3rd chunk not even showing in the process list.
1st chunk processid - 200045 - loaded with errors - We will retry the failed records - No issue
2nd chunk processid - 200046 - It loaded the records into staging table, but no processing past 2 hours it is showing in 'N' status,
3rd chunk - no process id generated.

Note: each of the chunks are around 0.25 million.

After a time the data loaded but it took a while, here are the statistics,

Name Total Records Loaded Error Time
GLSet-1.ods(200045 ) 249999 249989 10 09/30/2022 - 3:55 AM - 09/30/22 4:31 AM
GLSet-2.ods(200046) 251840 251833 7 09/30/2022 - 4:54 AM - 09/30/22 10:25 PM - >> **
GLSet-3.ods(195028) 317156 317141 15 09/30/2022 - 8:20 AM - 10/01/22 3:51 AM -->> **

As you see not much difference between first and other sets of data, but a huge difference in the time it took to load.

Cause

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