-- Change SYSADMIN to whatever you need
select distinct u.user_name, r.responsibility_name, g.start_date, g.end_date
from fnd_responsibility_tl r,
fnd_user_resp_groups g,
fnd_user u
where u.user_id = g.user_id
and r.application_id = g.responsibility_application_id
and r.responsibility_id = g.responsibility_id
and r.language = 'US'
and (sysdate between g.start_date and g.end_date or g.end_date is null)
and u.user_name = 'SYSADMIN'
order by r.responsibility_name;
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
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
/* 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