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:
Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.23.01.0 and laterInformation in this document applies to any platform.
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
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 |
Cause |
Solution |
References |