How to change status of a OAE job in Warning to FINISHED using a condition

Document ID : KB000090121
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
How to change status of a OAE job in Warning to FINISHED using a condition
Resolution:
Detailed Description and Symptoms
In earlier versions of Applications Manager OAE jobs would show the Oracle applications status of C-RUNNING, C-NORMAL, C-ERROR, and C-WARNING in the backlog. In 8.0 they now show as ABORTED.

Investigation
This was a change in functionality in 7.1, and 8.0. The OAE jobs status is now shown in the so_application_status column in the so_job_queue table.

Solution
You can create a subvar with the following sql statement in it.
 
 select so_application_status from so_job_queue where so_jobid={jobid} ( {jobid} is a replaement value)
 
 Then put an after condition on the job.
 
 AFTER ONCE {<subvar>} = Warning SET FINISHED STATUS FINISHED
 
 You can add the so_application_status field to the backlog by Clicking on Options > Tables > Backlog .