top of page
Search

Running EBS concurrent requests

Writer's picture: mdvorkinmdvorkin

select fpro.os_process_id pid,

fcr.request_id,

to_char(fcr.actual_start_date, 'DD/MM/YYYY HH24:MI:SS') start_date,

fcp.user_concurrent_program_name program_name,

fcq.concurrent_queue_name queue_name,

f.user_name

from fnd_user f,

fnd_concurrent_queues fcq,

fnd_concurrent_requests fcr,

fnd_concurrent_programs_tl fcp,

fnd_concurrent_processes fpro

where fcr.phase_code = 'R'

and fcr.status_code = 'R'

and fcr.controlling_manager = fpro.concurrent_process_id

and(fcq.concurrent_queue_id = fpro.concurrent_queue_id

and fcq.application_id = fpro.queue_application_id )

and(fcr.concurrent_program_id = fcp.concurrent_program_id

and fcr.program_application_id = fcp.application_id )

and fcr.requested_by = f.user_id

and fcp.language = 'US';


15 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...

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...

Foreign key constraint violation

/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...

Comments


bottom of page