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>

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; 

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

How to find Trace file location when you are given Trace ID

select name,value from v$parameter where name='user_dump_dest';


SELECT 'Request id: '||request_id ,
'Trace id: '||oracle_Process_id,
'Trace Flag: '||req.enable_trace,
'Trace Name:
'||dest.value||'/'||lower(dbnm.value)||'_ora_'||oracle_process_id||'.trc',
'Prog. Name: '||prog.user_concurrent_program_name,
'File Name: '||execname.execution_file_name|| execname.subroutine_name ,
'Status : '||decode(phase_code,'R','Running')
||'-'||decode(status_code,'R','Normal'),
'SID Serial: '||ses.sid||','|| ses.serial#,
'Module : '||ses.module
from fnd_concurrent_requests req, v$session ses, v$process proc,
v$parameter dest, v$parameter dbnm, fnd_concurrent_programs_vl prog,
fnd_executables execname
where req.request_id = 65791130
and 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;

Replace Trace ID with your trace ID and find the location of trace file and extract

How to set profile options to enable personalization?

System Administrator -->Profile-->System-


Ensure to set system profile 'Hide Diagnostics menu entry' to 'No' and 'Utilities:Diagnostics' to 'Yes' at the user level

Full Forms

EBS - E - Business Suite
ERP - Enterprise Resource Planning
P2P - Procure to Pay
TNS - Transparent Network Substrate
OM - Order Management
CRM - Customer Relationship Management
ASL - Approved Suppliers List
DFF - Descriptive Flex Fields
KFF- Key Flex Fields
PO - Purchase Order
SO - Sales Order
PLL - Program Link Library
COA - Chart of Accounts
MRP - Material Requirement Planning
SR - Service Request
WIP - Work in Progress
WMS - Warehouse Management Systems
RMA - Return Material Authorization
AFF - Accounting Flex Fields
PLL - PL/SQL Link Module Library
FMB - Form Module Binary
MMB - Menu Module Binary

How to Find UTL File Directory in Apps

Type the following command in SQLDeveloper or TOAD or SQL*Plus

show parameter UTL_FILE_DIR;

It displays UTL_FILE_DIR in apps