D2-IDEWT Batch Job Runs Continuously When Running Daily Consumption Extract Jobs (DataConnect) (Doc ID 2410134.1)

Last updated on JUNE 05, 2024

Applies to:

Goal

When running daily consumption extract jobs (DataConnect), the D2-IDEWT job normally runs continuously each minute from the time F1-SUBRQ starts until the last consumption extract job completes.

Under some condition(s), the D2-IDEWT job runs continuously and does not stop when the consumption extract jobs complete. This happened when one of the historical correction consumption extracts threw an exception (which may or may not have been a coincidence). When the exception was thrown, the bo_status_cd on the f1_req record for the request did not transition to a status of 'COMPLETE', but instead stayed in a status of 'WAIT_FOR_RUN' in one case or 'ERROR' in another case. In both cases, setting the BO_STATUS_CD to 'COMPLETE' caused the D2-IDEWT process to stop, although it did not stop until after nightly batch when the batch business day is updated and threadpool workers are restarted.

Please provide detailed information regarding the functionality of D2-IDEWT with respect to DataConnect consumption extracts so that we may more effectively troubleshoot this issue.
 

Solution

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