STEPS TO ENABLE TRACE FOR CONCURRENT PROGRAMS IN ORACLE EBS APPS R12

As we know that tracing the Concurrent program is very mendatory option to Debug any issue while running the concurrent program long.

Purpose :

To enable the Trace for Concurrent Programs

To Debug the issues in Concurrent Programs or its dependent objects.

Follow the below steps to enable the trace file for concurrent request program.

Login in EBS :-

1. Goto Concurrent Program Definition

Application Developer –> Concurrent –> Program –> check Enable Trace

Query your concurrent program and check the Enable Trace check box at the bottom of the screen.

2. Set the Profile Concurrent: Allow Debugging to YES.

3. Navigate to the Responsibility from where you are running the program.

4. Before Submitting the Concurrent Program in Submit Request screen there will be an option like Debug Options just click on that button.

5. In the Debug Options select the SQL Trace and enable Trace with binds.

6. Submit the Concurrent Program.

7.Trace file name will always be post fixed with oracle_process_id. 

To find out the oracle_process_id use the below SQL

SQL>Select oracle_process_id from fnd_concurrent_requests where request_id= &Request_id;

8.Trace file path can be derived using the below SQL

SQL>Select * from v$parameter where name=’user_dump_dest’;

9. Get the trace file to your local machine.

10. Open the Command Prompt and run the below command to generate tkprof.

TKPROF < Trace File_Name.trc> <Output_File_Name.tkprf> SORT=fchela

11. After that new output file will be generated with the name given in the above command. Analyse the Output file to know the answers for your problem.

Use below Sql queries to find the log files by Request id

SQL>select req.oracle_process_id trace_name, req.request_id, req.requested_by,usr.user_name, prog.user_concurrent_program_name, req.request_date, req.phase_code, req.status_code, req.logfile_name , req.outfile_name, dest.value as user_dump_dest from apps. fnd_concurrent_requests req, gv$parameter dest, apps.fnd_concurrent_programs_vl prog, apps.fnd_user usr where  req. concurrent_program_id = prog.concurrent_program_id and req.requested_by = usr.user_id  –and request_id like '9876567' and dest.name= ‘user_dump_dest’ and request_id like & Request_id;

Sql query find the log files by username

SQL>select req.oracle_process_id tracename, req.request_id, req.requested_by,usr.user_name, prog.user_concurrent_program_name, req.request_date,  req.phase_code, req.status_code, req.logfile_name , req.outfile_name, dest.value as user_dump_dest  from apps. fnd_concurrent_requests req, gv$parameter dest, apps.fnd_concurrent_programs_vl prog, apps.fnd_user usr where  req.concurrent_program_id = prog.concurrent_program_id and req.requested_by = usr.user_id –and request_id like ‘6013239’ and dest.name= ‘user_dump_dest’ and usr.user_name like ‘squamer%G%’ order by request_date desc;

SQL query to find process id.

SQL>Select oracle_process_id from fnd_concurrent_requests where request_id = &Request_id;

SQL>select * from apps. fnd_concurrent_requests req,gv$parameter dest , apps.fnd_concurrent_programs_vl prog where  req. concurrent_program_id = prog.concurrent_program_id and request_id like ‘9876567%’ and dest.name= ‘user_dump_dest’;

Hope this will help to enable trace for your running concurrent request.

Login Fails With Error Oacore Logs Shows oracle.apps.fnd.common.EBSLoggerHandler

 Login Fails With Error Failure of Web Server bridge:

/data02/EBS_r12.2.5/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/oacore_server1/logs

oacore_server1-diagnostic.log

[2021-07-19T14:14:39.112+05:30] [oacore_server1] [ERROR] [] [] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <WLS Kernel>] [ecid: 0000NexvzVb5i^WFLzVK8A1WxJhU000003,0] [APP: oacore#1.0.0] Failed to configure EBSLoggerHandler[[

java.lang.ClassNotFoundException: oracle.apps.fnd.common.EBSLoggerHandler

Oacore Logs Shows ClassNotFoundException: Oracle.apps.fnd.common.EBSLoggerHandler (Doc ID 2634796.1)

Steps to upgrade jre in r12.2

If you are facing warning regarding upgrade java . Pls follow the below mentioned steps to do so.

Steps to upgrade the version of the JRE Native Client Plug-in being used in Oracle E-Business Suite (EBS) Release 12 .You may download jre from Doc ID 393931.1. JRE  is available via a patch as listed in the JRE Parameter Settings table.

Here i am upgrading the jre from jre-6u27 to jre-7u321.

[applmgr@prdtest jre-7u331-linux-i586]$ cp jre-7u321-windows-i586.exe j2se17321.exe

[applmgr@prdtest jre-7u331-linux-i586]$ ll  $COMMON_TOP/webapps/oacore/util/javaplugin/

total 16508

-rwxrwxr-x 1 applmgr dba 16897824 Aug 24 01:53 j2se16027.exe

-rwxrwxr-x 1 applmgr dba      943 Aug 24 01:53 readme.html

[applmgr@prdtest jre-7u331-linux-i586]$ pwd

/prddata03/testinst/ETCC-MT/jre-7u331-linux-i586

[applmgr@prdtest jre-7u331-linux-i586]$ cp j2se17321.exe $COMMON_TOP/webapps/oacore/util/javaplugin/

[applmgr@prdtest jre-7u331-linux-i586]$ cd $COMMON_TOP/webapps/oacore/util/javaplugin/

[applmgr@prdtest javaplugin]$ ls

j2se16027.exe  j2se17321.exe  readme.html

[applmgr@prdtest javaplugin]$ ls -ltr

total 35400

-rwxrwxr-x 1 applmgr dba      943 Aug 24 01:53 readme.html

-rwxrwxr-x 1 applmgr dba 16897824 Aug 24 01:53 j2se16027.exe

-rwxr-xr-x 1 applmgr dba 19342680 Jan 28 11:56 j2se17321.exe

[applmgr@prdtest javaplugin]$ mv j2se16027.exe j2se16027.exe_orig

[applmgr@prdtest javaplugin]$ mv j2se17321.exe j2se170321.exe

[applmgr@prdtest javaplugin]$ ls -ltr

total 35400

-rwxrwxr-x 1 applmgr dba      943 Aug 24 01:53 readme.html

-rwxrwxr-x 1 applmgr dba 16897824 Aug 24 01:53 j2se16027.exe_orig

-rwxr-xr-x 1 applmgr dba 19342680 Jan 28 11:56 j2se170321.exe

[applmgr@prdtest javaplugin]$ ls /prddata03/testinst/fs1/EBSapps/appl/fnd/12.0.0/bin/txkSetPlugin.sh

/prddata03/testinst/fs1/EBSapps/appl/fnd/12.0.0/bin/txkSetPlugin.sh

[applmgr@prdtest javaplugin]$

[applmgr@prdtest javaplugin]$

[applmgr@prdtest javaplugin]$ /prddata03/testinst/fs1/EBSapps/appl/fnd/12.0.0/bin/txkSetPlugin.sh 170321

/prddata03/testinst/fs1/EBSapps/appl/fnd/12.0.0/bin

  Starting interoperability upgrade script...

Sending logfile output to:

        /prddata03/testinst/fs1/inst/apps/DEV_prdtest/logs/txkSetPlugin.log

Using the context file:

        /prddata03/testinst/fs1/inst/apps/DEV_prdtest/appl/admin/DEV_prdtest.xml

Using APPLSYS file:

        /prddata03/testinst/fs1/EBSapps/appl/APPSDEV_prdtest.env

  Using /prddata03/testinst/fs1/EBSapps/comn/util/jdk32/jre/bin/java to execute java programs

  Getting J2SE parameter values...

  Installing j2se170321 with Version clsid CAFEEFAC-0017-0000-0032-ABCDEFFEDCBA

  Copy oaj2se.exe to html dir...

Copying /prddata03/testinst/fs1/EBSapps/comn/webapps/oacore/util/javaplugin/j2se170321.exe to /prddata03/testinst/fs1/FMW_Home/Oracle_EBS-app1/applications/oacore/html/oaj2se.exe ...

  Backing up the Application Context File...

/prddata03/testinst/fs1/inst/apps/DEV_prdtest/appl/admin/DEV_prdtest.xml to /prddata03/testinst/fs1/inst/apps/DEV_prdtest/appl/admin/DEV_prdtest.xml.prej2se170321

Using APPSWEB file /prddata03/testinst/fs1/inst/apps/DEV_prdtest/ora/10.1.2/forms/server/appsweb.cfg

  Backing up the appsweb file...

Backing up /prddata03/testinst/fs1/inst/apps/DEV_prdtest/ora/10.1.2/forms/server/appsweb.cfg to /prddata03/testinst/fs1/inst/apps/DEV_prdtest/ora/10.1.2/forms/server/appsweb.cfg.prej2se170321

  Updating XML context file with new J2SE parameters...

Updated J2SE plugin to jdk

Updated J2SE mimetype to 1.7.0_032

Updated J2SE Classid to CAFEEFAC-0017-0000-0032-ABCDEFFEDCBA

Enter the APPS user password:

[applmgr@prdtest javaplugin]$ ls

j2se16027.exe_orig  j2se170321.exe  readme.html

[applmgr@prdtest javaplugin]$ mv j2se170321.exe j2se17321.exe

[applmgr@prdtest javaplugin]$ /prddata03/testinst/fs1/EBSapps/appl/fnd/12.0.0/bin/txkSetPlugin.sh 17321

/prddata03/testinst/fs1/EBSapps/appl/fnd/12.0.0/bin

  Starting interoperability upgrade script...

Sending logfile output to:

        /prddata03/testinst/fs1/inst/apps/DEV_prdtest/logs/txkSetPlugin.log

Using the context file:

        /prddata03/testinst/fs1/inst/apps/DEV_prdtest/appl/admin/DEV_prdtest.xml

Using APPLSYS file:

        /prddata03/testinst/fs1/EBSapps/appl/APPSDEV_prdtest.env

  Using /prddata03/testinst/fs1/EBSapps/comn/util/jdk32/jre/bin/java to execute java programs

  Getting J2SE parameter values...

  Installing j2se17321 with Version clsid CAFEEFAC-0017-0000-0321-ABCDEFFEDCBA

  Copy oaj2se.exe to html dir...

Copying /prddata03/testinst/fs1/EBSapps/comn/webapps/oacore/util/javaplugin/j2se17321.exe to /prddata03/testinst/fs1/FMW_Home/Oracle_EBS-app1/applications/oacore/html/oaj2se.exe ...

  Backing up the Application Context File...

/prddata03/testinst/fs1/inst/apps/DEV_prdtest/appl/admin/DEV_prdtest.xml to /prddata03/testinst/fs1/inst/apps/DEV_prdtest/appl/admin/DEV_prdtest.xml.prej2se17321

Using APPSWEB file /prddata03/testinst/fs1/inst/apps/DEV_prdtest/ora/10.1.2/forms/server/appsweb.cfg

  Backing up the appsweb file...

Backing up /prddata03/testinst/fs1/inst/apps/DEV_prdtest/ora/10.1.2/forms/server/appsweb.cfg to /prddata03/testinst/fs1/inst/apps/DEV_prdtest/ora/10.1.2/forms/server/appsweb.cfg.prej2se17321

  Updating XML context file with new J2SE parameters...

Updated J2SE plugin to jdk

Updated J2SE mimetype to 1.7.0_321

Updated J2SE Classid to CAFEEFAC-0017-0000-0321-ABCDEFFEDCBA

Enter the APPS user password:

The log file for this session is located at: /prddata03/testinst/fs1/inst/apps/DEV_prdtest/admin/log/01281200/adconfig.log

wlsDomainName: EBS_domain

WLS Domain Name is VALID.

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.

        Using CONFIG_HOME location     : /prddata03/testinst/fs1/inst/apps/DEV_prdtest

        Classpath                   : /prddata03/testinst/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/prddata03/testinst/fs1/EBSapps/comn/java/classes

        Using Context file          : /prddata03/testinst/fs1/inst/apps/DEV_prdtest/appl/admin/DEV_prdtest.xml

Context Value Management will now update the Context file

 Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...

        Configuring AD_TOP........COMPLETED

        Configuring FND_TOP.......COMPLETED

        Configuring ICX_TOP.......COMPLETED

        Configuring MSC_TOP.......COMPLETED

        Configuring IEO_TOP.......COMPLETED

        Configuring BIS_TOP.......COMPLETED

        Configuring CZ_TOP........COMPLETED

        Configuring SHT_TOP.......COMPLETED

        Configuring AMS_TOP.......COMPLETED

        Configuring CCT_TOP.......COMPLETED

        Configuring WSH_TOP.......COMPLETED

        Configuring CLN_TOP.......COMPLETED

        Configuring OKE_TOP.......COMPLETED

        Configuring OKL_TOP.......COMPLETED

        Configuring OKS_TOP.......COMPLETED

        Configuring CSF_TOP.......COMPLETED

        Configuring IBY_TOP.......COMPLETED

        Configuring JTF_TOP.......COMPLETED

        Configuring MWA_TOP.......COMPLETED

        Configuring CN_TOP........COMPLETED

        Configuring CSI_TOP.......COMPLETED

        Configuring WIP_TOP.......COMPLETED

        Configuring CSE_TOP.......COMPLETED

        Configuring EAM_TOP.......COMPLETED

        Configuring GMF_TOP.......COMPLETED

        Configuring PON_TOP.......COMPLETED

        Configuring FTE_TOP.......COMPLETED

        Configuring ONT_TOP.......COMPLETED

        Configuring AR_TOP........COMPLETED

        Configuring AHL_TOP.......COMPLETED

        Configuring IES_TOP.......COMPLETED

        Configuring OZF_TOP.......COMPLETED

        Configuring CSD_TOP.......COMPLETED

        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.

Done