HOW TO GET SQL_ID FOR A PARTICULAR REQUEST

 col oracle_process_id format a5 head OSPID

col inst_name format a10

col sql_text format a30

col outfile_tmp format a30

col logfile_tmp format a30

select /*+ ordered */

fcr.request_id,

fcp.user_concurrent_program_name

,      round(24*60*( sysdate - actual_start_date )) elapsed

,      fcr.oracle_process_id

,      sess.sid

,      sess.serial#

,      inst.inst_name

,      sa.SQL_ID

from   apps.fnd_concurrent_requests fcr

,      apps.fnd_concurrent_programs_tl fcp

,      apps.fnd_concurrent_processes cp

,      apps.fnd_user fu

,      gv$process pro

,      gv$session sess

,      gv$sqlarea sa

,      sys.v_$active_instances inst

where  fcp.concurrent_program_id = fcr.concurrent_program_id

and    fcp.application_id = fcr.program_application_id

and    fcr.controlling_manager = cp.concurrent_process_id

and    fcr.requested_by = fu.user_id (+)

and    fcr.oracle_process_id = pro.spid (+)

and    pro.addr = sess.paddr (+)

and    sess.sql_address = sa.address (+)

and    sess.sql_hash_value = sa.hash_value (+)

and    sess.inst_id = inst.inst_number (+)

and    request_id='&req_id';

How to Generate fmx from fmb in R12

 1) Login to application server.

2) Go to the directory $AU_TOP/forms/US

3) Place “.fmb” file in binary mode or search for existing --> ls -ltrh *.fmb

4) Execute the below command to generate “.fmx”.

frmcmp_batch userid=apps/<apps_paswd> module=<Form_Name>.fmb output_file=<Form_Name>.fmx module_type=form batch=no compile_all=special

EBS R12.2 Log file locations

EBS R12.2 Log file locations

$INST_TOP/logs/appl/admin/log-------Start/Stop Logfiles

$IAS_ORACLE_HOME/ instances//diagnostics/logs-------Log files for OPMN and OHS processes

$FMW_HOME/wlserver_10.3/common/nodemanager/nmHome1/nodemanager.log --------Weblogic Nodemanager

$IAS_ORACLE_HOME/instances//diagnostics/logs/OHS/EBS_web_/*log------Apache Logs

$IAS_ORACLE_HOME/instances//diagnostics/logs/OPMN/opmn/----OPMN Logs

$IAS_ORACLE_HOME/../wlserver_10.3/common/nodemanager

$EBS_DOMAIN_HOME/servers/oa/logs/

$EBS_DOMAIN_HOME/servers/forms/logs/

$EBS_DOMAIN_HOME/servers/AdminServer/logs/*

$EBS_DOMAIN_HOME/sysman/log/*         -------------------Weblogic Logs

How to get weblogic url in EBS R 12.2

 [oracle@Ranesh logs]$ grep -i "wls_admin" $CONTEXT_FILE

         <s_wls_admin_console_access_nodes oa_var="s_wls_admin_console_access_nodes">0.0.0.0/0</s_wls_admin_console_access_nodes>

         <wls_admin_host oa_var="s_wls_admin_host">Ranesh</wls_admin_host>

         <wls_admin_sslEnabled oa_var="s_wls_admin_sslEnabled">false</wls_admin_sslEnabled>

         <wls_admin_domain oa_var="s_wls_admin_domain">ranesh.oraclevcn.com</wls_admin_domain>

         <wls_admin_user oa_var="s_wls_admin_user">weblogic</wls_admin_user>

         <wls_adminport oa_var="s_wls_adminport" oa_type="PORT" base="7001" step="1" range="-1" label="WLS Admin Server Port">7001</wls_adminport>

         <wls_admin_sslport oa_var="s_wls_admin_sslport" oa_type="PORT" base="17001" step="1" range="-1" label="WLS Admin Server SSL Port">17001</wls_admin_sslport>

We can also find out the url using command

[oracle@Ranesh logs]$ echo "http://"$(cat $CONTEXT_FILE | grep s_webhost | cut -d '>' -f2 | cut -d '<' -f1)"."$(cat $CONTEXT_FILE | grep s_wls_admin_domain | cut -d '>' -f2 | cut -d '<' -f1)":"$(cat $CONTEXT_FILE | grep s_wls_adminport | cut -d '>' -f2 | cut -d '<' -f1)"/console"

http://Ranesh.ranesh.oraclevcn.com:7001/console

Upload to oracle Support

 cURL is a command-line tool and application library used to transfer data to or from a server.

curl -T  /u01/app/oracle/ranesh.zip -o output.log  -u "ranesh@oracle.com" "https://transport.oracle.com/upload/issue/SR NUMBER/"

 curl -T AdminServer.log -o xplorer -u "ranesh@oracle.com" "https://transport.oracle.com/upload/issue/3-26712853041/"

generate an dblink

 SELECT DBMS_METADATA.GET_DDL('DB_LINK',db.db_link,db.owner) from dba_db_links db;

Steps to start/stop Workflow Notification Mailer--backend

 

Steps to start/stop Workflow Notification Mailer

 

·         Check workflow mailer service current status

 

SQL> select running_processes from fnd_concurrent_queues

 where concurrent_queue_name = 'WFMLRSVC';  

 

RUNNING_PROCESSES

-----------------

                1

Number of running processes should be greater than 0

 

·         Find current mailer status

 

SQL> select component_status

 from fnd_svc_components

 where component_id =

 (select component_id

 from fnd_svc_components

 where component_name = 'Workflow Notification Mailer'); 

 

COMPONENT_STATUS

------------------------------

DEACTIVATED_USER

 

 

Possible values are :

RUNNING STARTING,

STOPPED_ERROR,

DEACTIVATED_USER

DEACTIVATED_SYSTEM.

 

·         Stop Workflow mailer

 

declare

p_retcode number;

p_errbuf varchar2(100);

m_mailerid fnd_svc_components.component_id%TYPE;

begin

select component_id

into m_mailerid

from fnd_svc_components

where component_name = 'Workflow Notification Mailer';

fnd_svc_component.stop_component(m_mailerid, p_retcode, p_errbuf);

commit;

end;

/

 

·         Start the Notification Mailer

 

declare

p_retcode number;

p_errbuf varchar2(100);

m_mailerid fnd_svc_components.component_id%TYPE;

begin

select component_id

into m_mailerid

from fnd_svc_components

where component_name = 'Workflow Notification Mailer';

fnd_svc_component.start_component(m_mailerid, p_retcode, p_errbuf);

commit;

end;

/