Davis Apps DBA

One day I found WFM Notification is down in one of my server. When i try to start that component again it failed with the same issue. Below are the sequence of steps I followed to rectify that issue. Navigate to Site Map > Administration > Generic Services and press View All button Select Generic Service Component Container and start the Workflow Mailer Service. Once it is started successfully, try to start the WF Notification Mailer service component. Most of the time, it will be started without any issue. If still facing the same issue, check the appropriate log file for the issue and take necessary steps to solve the issue. Here I worked on my issue. If you face the same exact issue, then follow the remaining steps. Checked the recent Workflow Mailer and Agent Listener services log file and found the below issue. You can find the log file using the command 'ls -lrt $APPLCSF/APPLLOG/FNDCPGSC*.txt...

I faced this error while cloning R12.2.5 in my environment. Below are the step by step process, I followed to overcome this issue. The above issue might occur if still there is some reference to the source system, or the cloning script is unable to change it to appropriate environment during the cloning process for some reasons. This is one such case, where this issue might occur. There are many other reasons which will throw the above same issue but the reason might be different. Need to drill down on the log files for exact cause for the issue. Take backup of AD_APPL_TOPS table Remove the entries for prod reference On db tier connect with apps Run "exec fnd_conc_clone.setup_clean;" Run autoconfig on database tier On application tier rerun "perl adcfgclone.pl appsTier" Verify Clone complete successfully or not. ****************************நன்றி****************************

Below query can be used to find the workflow mailer log location and the file name. SELECT fcp.logfile_name FROM fnd_concurrent_queues fcq, fnd_concurrent_processes fcp, fnd_lookups flkup WHERE concurrent_queue_name in ('WFMLRSVC') AND fcq.concurrent_queue_id = fcp.concurrent_queue_id AND fcq.application_id = fcp.queue_application_id AND flkup.lookup_code=fcp.process_status_code AND lookup_type ='CP_PROCESS_STATUS_CODE' AND meaning='Active'; ****************************நன்றி****************************

Let us see how to generate explain plan for a SQL Query and SQL ID. Pre-Req: Create the plan table if not created already @$ORACLE_HOME/rdbms/admin/utlxplan.sql CREATE PUBLIC SYNONYM plan_table FOR sys.plan_table; GRANT ALL ON sys.plan_table TO public; Explain Plan for SQL Query: 1. First identify the query for which you want to generate the plan. 2. Create explain plan for the desired query. 3. Display the explain plan generated for your selected query. 1. I have chosen to generate explain plan for the query 'SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process 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 = &Request_ID AND a.phase_code = 'R';' 2. Create explain plan for the above query 3. Display the above generated explain plan. Explain Plan for SQL ID...

Pre-Reqs: Check the below parameters having proper values according to your environment before over-riding, otherwise issue will occur. Masking Email Address uname -n hostname grep -ie s_webhost $CONTEXT_FILE grep -ie s_domainname $CONTEXT_FILE grep -ie s_webport $CONTEXT_FILE For e-mail address masking  Click Here Use the below query to check the details of Framework and Web agents. select PROFILE_OPTION_NAME, PROFILE_OPTION_VALUE from fnd_profile_options a , fnd_profile_option_values b where a.APPLICATION_ID = b.APPLICATION_ID and a.PROFILE_OPTION_ID = b.PROFILE_OPTION_ID and a.PROFILE_OPTION_NAME in ( 'APPS_FRAMEWORK_AGENT', 'WF_MAIL_WEB_AGENT') and b.level_value = 0; Values of both the agents should be same, otherwise you will receive notification for only one test notification(PL/SQL) out of two. Suppose if 'WEB_AGENT' is having a different value means, follow either   Doc ID 1943176.1  or  Doc ID 736898.1  to fix that(F...