post clone

update fnd_concurrent_requests
set phase_code = 'C', status_code = 'X'
where status_code in ('Q','I')
and requested_start_date > SYSDATE
and hold_flag = 'N';

MOS
170107.1
152209.1
Toatl No of Scheduled Jobs:
select count(*)
from fnd_concurrent_requests
where status_code in ('Q','I');
3.Purge all data with manager age 1
update fnd_concurrent_requests
set phase_code = 'C', status_code = 'X'
where status_code in ('Q','I')
and requested_start_date > SYSDATE
and hold_flag = 'N';
commit;
select *
from fnd_concurrent_requests
where status_code in ('Q','I')
11519636
SELECT 'Request id: '||request_id ,
'SID Serial: '||ses.sid||','|| ses.serial#,
'Module : '||ses.module
from apps.fnd_concurrent_requests req, v$session ses, v$process proc,
v$parameter dest, v$parameter dbnm, apps.fnd_concurrent_programs_vl prog,
apps.fnd_executables execname where
req.oracle_process_id=proc.spid(+)
and proc.addr = ses.paddr(+)
and dest.name='user_dump_dest'
and dbnm.name='db_name'
and req.concurrent_program_id = prog.concurrent_program_id
and req.program_application_id = prog.application_id
and prog.application_id = execname.application_id and prog.executable_id=execname.executable_id
and request_id='11519636';
SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_processes b,
v$process c,
v$session d
WHERE a.controlling_manager = b.concurrent_process_id
AND c.pid = b.oracle_process_id
AND b.session_id=d.audsid
AND a.request_id = '8407158';
alter system kill session 'SID,Serial#';
alter system kill session '155,12403';

SELECT fcr.request_id
, fcpt.user_concurrent_program_name|| NVL2(fcr.description, ' (' || fcr.description || ')', NULL) conc_prog
, fu.user_name requestor
, fu.description requested_by
, fu.email_address
, frt.responsibility_name requested_by_resp
, trim(fl.meaning) status
, fcr.phase_code
, fcr.status_code
, fcr.argument_text "PARAMETERS"
, TO_CHAR(fcr.request_date, 'DD-MON-YYYY HH24:MI:SS') requested
, TO_CHAR(fcr.requested_start_date, 'DD-MON-YYYY HH24:MI:SS') requested_start
, TO_CHAR((fcr.requested_start_date), 'HH24:MI:SS') start_time
, DECODE(fcr.hold_flag, 'Y', 'Yes', 'N', 'No') on_hold
, CASE
WHEN fcr.hold_flag = 'Y'
Then Substr(
fu.description
, 0
, 40
)
END last_update_by
, CASE
WHEN fcr.hold_flag = 'Y'
THEN fcr.last_update_date
END last_update_date
, fcr.increment_dates
, CASE WHEN fcrc.CLASS_INFO IS NULL THEN
'Yes: ' || TO_CHAR(fcr.requested_start_date, 'DD-MON-YYYY HH24:MI:SS')
ELSE
'n/a'
END run_once
, CASE WHEN fcrc.class_type = 'P' THEN
'Repeat every ' ||
substr(fcrc.class_info, 1, instr(fcrc.class_info, ':') - 1) ||
decode(substr(fcrc.class_info, instr(fcrc.class_info, ':', 1, 1) + 1, 1),
'N', ' minutes',
'M', ' months',
'H', ' hours',
'D', ' days') ||
decode(substr(fcrc.class_info, instr(fcrc.class_info, ':', 1, 2) + 1, 1),
'S', ' from the start of the prior run',
'C', ' from the completion of the prior run')
ELSE
'n/a'
END set_days_of_week
, CASE WHEN fcrc.class_type = 'S' AND instr(substr(fcrc.class_info, 33),'1',1) > 0 THEN
'Days of week: ' ||
decode(substr(fcrc.class_info, 33, 1), '1', 'Sun, ') ||
decode(substr(fcrc.class_info, 34, 1), '1', 'Mon, ') ||
decode(substr(fcrc.class_info, 35, 1), '1', 'Tue, ') ||
decode(substr(fcrc.class_info, 36, 1), '1', 'Wed, ') ||
decode(substr(fcrc.class_info, 37, 1), '1', 'Thu, ') ||
decode(substr(fcrc.class_info, 38, 1), '1', 'Fri, ') ||
decode(substr(fcrc.class_info, 39, 1), '1', 'Sat ')
ELSE
'n/a'
end days_of_week
FROM fnd_concurrent_requests fcr
, fnd_user fu
, fnd_concurrent_programs fcp
, fnd_concurrent_programs_tl fcpt
, fnd_printer_styles_tl fpst
, fnd_conc_release_classes fcrc
, fnd_responsibility_tl frt
, fnd_lookups fl
WHERE fcp.application_id = fcpt.application_id
AND fcr.requested_by = fu.user_id
AND fcr.concurrent_program_id = fcp.concurrent_program_id
AND fcr.program_application_id = fcp.application_id
AND fcr.concurrent_program_id = fcpt.concurrent_program_id
AND fcr.responsibility_id = frt.responsibility_id
AND fcr.print_style = fpst.printer_style_name(+)
AND fcr.release_class_id = fcrc.release_class_id(+)
AND fcr.status_code = fl.lookup_code
AND fl.lookup_type = 'CP_STATUS_CODE'
AND fcr.phase_code = 'P'
AND 1=1
Order By Fu.Description, Fcr.Requested_Start_Date Asc

select * from fnd_user;
update fnd_user
set END_DATE='15-MAY-2018'
where USER_NAME like '%';
901

update fnd_user
set END_DATE='15-MAY-2018'
where USER_NAME like '%C';
18
update fnd_user
set END_DATE='15-MAY-2018'
where USER_NAME like '00%';
24
update fnd_user
set END_DATE='15-MAY-2018'
where USER_NAME like '%';
5
update fnd_user
set END_DATE='15-MAY-2018'
where USER_NAME like 'L-%';
8
update fnd_user
set END_DATE='15-MAY-2018'
where USER_NAME in
(
'771',
'926',

);
17
update fnd_user
set END_DATE='15-MAY-2018'
where USER_NAME like 'ORACLE%';
10
update fnd_user
set END_DATE='15-MAY-2018'
where USER_NAME=;
1


sysadmin
sysinterface
update fnd_user
set END_DATE=''
where USER_NAME like '12'
select * from fnd_user where USER_NAME like '%T';
select * from fnd_user where USER_NAME like '%T%';

select * from fnd_user where USER_NAME like '%%';

update fnd_user
set END_DATE=''
where USER_NAME like '%'
select * from fnd_user where USER_NAME like '1';
update fnd_user
set END_DATE=''
where USER_NAME like '1'


update fnd_user
set END_DATE=''
where USER_NAME in ();

select USER_NAME,DESCRIPTION from fnd_user where description like '%%'

SELECT usr.user_name,
       get_pwd.decrypt
          ((SELECT (SELECT get_pwd.decrypt
                              (fnd_web_sec.get_guest_username_pwd,
                               usertable.encrypted_foundation_password
                              )
                      FROM DUAL) AS apps_password
              FROM fnd_user usertable
             WHERE usertable.user_name =
                      (SELECT SUBSTR
                                  (fnd_web_sec.get_guest_username_pwd,
                                   1,
                                     INSTR
                                          (fnd_web_sec.get_guest_username_pwd,
                                           '/'
                                          )
                                   - 1
                                  )
                         FROM DUAL)),
           usr.encrypted_user_password
          ) PASSWORD
  FROM fnd_user usr
WHERE usr.user_name = '2653';

need to disable/rename this Trigger:
PENDING_MAIL_ALERT_G
alter trigger PENDING_MAIL_ALERT_G disable;