Monday, June 16, 2014

How to enable back space in putty?

Login into Putty

Don't login into sql plus

type following command


stty erase <press back space after space and hit enter>

Monday, June 9, 2014

How to get the Trace ID with Request ID


SELECT request_id, oracle_process_id trace_id
FROM fnd_concurrent_requests
WHERE request_id = &requestid; 

Tuesday, June 3, 2014

Check Whether a Patch is applied or not

 select *
from ad_bugs ab
where ab.bug_number = '&PatchNumber';

or

select bug_number from ad_bugs where bug_number='&PatchNumber';