What is running in the database
https://ss64.com/orav/V$SQLAREA.html
R12 – Responsibility assigned to user cannot be accessed/seen by users
It is often experienced in Oracle Applications R12 that user has been assigned a responsibility…
How to stop/start Cost Manager
1. Go to View All Concurrent Requests form System Administrator: (N) Requests > View 2.…
HOW TO SET THE OVERRIDE ADDRESS in WORKFLOW MAILER
–Set the override address to ‘xyz@abc.com’ , using the following script: –Login to the application…
Troubleshooting Queries
Oracle Current Activity Given below is a small query that provides the following information about…
Current workflow mailer log file location
select fl.meaning,fcp.process_status_code, decode(fcq.concurrent_queue_name,’WFMLRSVC’,’maile r container’,’WFALSNRSVC’,’listener container’,fcq.concurrent_queue_name), fcp.concurrent_process_id,os_process_id, fcp.logfile_name from fnd_concurrent_queues fcq, fnd_concurrent_processes fcp , fnd_lookups…
EBS R12.2.7 of adcfgclone.pl appsTier failed with “Invalid APPS database user credentials. No updates Performed”
After running autoconfig on DB node.. the issue got resolved
Unable to start managed server in R12.2
It could be lock issue, rename below files cd $EBS_DOMAIN_HOME/servers/oacore_server1/data/store/diagnostics WLS_DIAGNOSTICS000000.DAT mv WLS_DIAGNOSTICS000000.DAT WLS_DIAGNOSTICS000000.DAT_old You can now…
AWR Hourly
https://oracleracdba1.wordpress.com/2012/09/18/script-to-generate-awr-reports-for-all-snap_ids-between-2-given-dates/ gen_batch.sql set echo off heading off feedback off verify off select ‘Please enter dates…
Identify sessions of an user in Oracle EBS
SELECT DISTINCT * FROM ( select usr.user_name user_name ,ses.sid||’,’||ses.serial# sid_serial from apps.icx_sessions i ,apps.fnd_logins l…