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')

　

　

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='17-AUG-2018'

where USER_NAME like '%T';

901

　

　

update fnd_user

set END_DATE='17-AUG-2018'

where USER_NAME like '%C';

　

　

　

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

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

　

　

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

　

　

　

update fnd_user

set END_DATE=''

where USER_NAME like '%TC'

　

select * from fnd_user where USER_NAME like '12J';

　

update fnd_user

set END_DATE=''

where USER_NAME like '17J'

　

　

update fnd_user

set END_DATE=''

where USER_NAME in (J');

　

select email_address,user_name from fnd_user where USER_NAME in ('J');

　

　

update fnd_user

set email_address = 'aminali.shamsuddin@toshiba-tjps.in'

where user_name='17J';

　

　

　

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

　

　

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:

　

XXTJ_NNR_PENDING_MAIL_ALERT_G

　

alter trigger XXTJ_NNR_PENDING_MAIL_ALERT_G disable;

　

　

drop procedure XXTJ_NNR_PENDING_MAIL_ALERT

　

drop procedure XXTJ_NNR_PENDING_MAIL_ALERT_G