Cancelled session still holding on to a process, which had object lock (Doc ID 2622779.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

The problem : killing the main job and sub-jobs has not resolved the issue of the next submitted job becoming "stuck".

You have followed the steps from Note: How To Abort InForm Main/Sub Jobs (Doc ID 2603943.1) but the issue still occurs and the next submitted job doesn't complete.

You've followed the steps below:

-------
Steps executed:

1. Execute with apps user the dataloadsubjobs.sql script for the stuck job.
2. Identify all subjobs.
3. For the identified subjob, navigate from LSH application to "Administration"/"Job Execution".
4. Search for the identified job.
5. Open the job and click on "Cancel Job" button.
6. Repeat steps 4-5 until all required jobs/subjobs are canceled.
-------

Cause

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