Error When Running Two Parallel Run All Transaction Processes Jobs : Child Import Transactions Didnt Succeed (Doc ID 2950253.1)

Last updated on MAY 19, 2023

Applies to:

Symptoms

Error when running two parallel Run All Transaction Processes jobset.

ERROR
Request processing resulted in error with the below message.
Error:Child Import Transactions didnt succeed. Child Job Id :62156938 No records are imported to transactions table



STEPS
The issue can be reproduced at will with the following steps:

1. Upload multiple zip data data files to UCM server ( each associated to different business unit )

2. Submit Run All Transaction Processes ( request_id 62156934 ) -- Succeeded status , Processing Start 4/12/23 3:34:27 AM UTC , Run time 00:07:41.637
    Parameters : 300013658789084, 2022-12-01 to 2023-04-30 , CoClCaSt
          Child Request ID                                    Status       Start Processing Time        Run Time       End Processing Time
          62156950 Import Transactions to Staging Succeeded 4/12/23 3:35:03 AM UTC   00:00:03.56    4/12/23 3:35:07 AM UTC
          62156949 Import Transactions to Staging Succeeded 4/12/23 3:34:55 AM UTC   00:00:06.456  4/12/23 3:35:01 AM UTC
          62156948 Import Transactions to Staging Succeeded 4/12/23 3:34:46 AM UTC   00:00:06.746  4/12/23 3:34:56 AM UTC
          62156941 Import Transactions to Staging Succeeded 4/12/23 3:34:38 AM UTC   00:00:07.78    4/12/23 3:34:47 AM UTC
          62156935 Import Transactions to Staging Succeeded 4/12/23 3:34:29 AM UTC   00:00:06.861  4/12/23 3:34:38 AM UTC

3. Submit Run All Transaction Processes ( request_id 62156936 ) -- Error status , Processing Start 4/12/23 3:34:31 AM UTC , Run Time 00:00:08.834
    Parameters : 300013658789164, 2022-12-01 to 2023-04-30 , CoClCaSt
          Child Request ID                                    Status       Processing Start Time        RunTime        End Processing Time
          62156938 Import Transactions to Staging Error         4/12/23 3:34:33 AM UTC   00:00:05.96    4/12/23 3:34:38 AM UTC

Cause

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