Search

Cancelled scheduled concurrent requests

This SQL query returns all concurrent requests that were scheduled in the past and are not scheduled currently. It can be used for identifying scheduled requests that failed to be resubmitted.


select r.request_id, p.user_concurrent_program_name, r.resubmit_interval, r.resubmit_interval_unit_code, c.class_info, r.phase_code, r.status_code

from fnd_concurrent_requests r,

fnd_concurrent_programs_tl p,

fnd_conc_release_classes c

where r.concurrent_program_id = p.concurrent_program_id

and c.release_class_id = r.release_class_id

and p.language = 'US'

and r.phase_code != 'P'

and r.status_code not in ('I', 'Q')

and nvl(r.request_type, 'X') != 'S'

and not exists

(select 1

from fnd_concurrent_requests r1,

fnd_conc_release_classes c1

where c1.release_class_id = r1.release_class_id

and r1.phase_code = 'P'

and r1.status_code in ('I', 'Q')

and nvl(r1.request_type, 'X') != 'S'

and r.concurrent_program_id = r1.concurrent_program_id)

and r.request_id =

(select max(r2.request_id)

from fnd_concurrent_requests r2

where r.concurrent_program_id = r2.concurrent_program_id);

3 views0 comments

Recent Posts

See All

Get DDL for Oracle object

set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set serveroutput on format wrapped set def off set tab off exec dbms_metad

Foreign key constraint violation

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id numeric(10) not null, supplier_name varchar2(50) not null, contact_na

From Concurrent to Trace

-- Find running concurrent request's database session SELECT fcr.request_id, ftl.user_concurrent_program_name program_name, v.meaning phase, vs.sid, vs.serial#, v1.meaning status, fu.user_name usernam