Find TLS Version in Linux

openssl s_client -connect google.com:443 -tls1_2

If you get the certificate chain and the handshake ok. It supports TLS 1.2. If you don’t see the certificate chain, and something similar to “handshake error” you know it does not support TLS 1.2. You can also test for TLS 1 or TLS 1.1 with -tls1 or tls1_1 respectively.

Debug or Trace option enabled in profiles

Some profile options may be required to be set to Y, but others should be N.

select  distinct
        a.application_short_name app_short,
        user_profile_option_name optname,
        decode(level_id,
        10001,'SITE',
        10002,'APP : '||a2.application_short_name,
        10003,'RESP: '||r.responsibility_key,
        10004,'USER: '||u.user_name,
        'Unknown') d_level,
        profile_option_value optval,
        v.last_update_date updated
from fnd_profile_options_vl o,
        fnd_profile_option_values v,
        fnd_application a,
        fnd_application a2,
        fnd_responsibility r,
        fnd_user u
where (
        o.user_profile_option_name like '%Debug%' or
        o.user_profile_option_name like '%DEBUG%' or
        o.user_profile_option_name like '%Trace%' or
        o.user_profile_option_name like '%TRACE%'
        )
and a.application_id = v.application_id
and o.application_id = v.application_id
and o.profile_option_id = v.profile_option_id
-- Find the associate level for profile
and r.application_id (+) = v.level_value_application_id
and r.responsibility_id (+) = v.level_value
and a2.application_id (+) = v.level_value
and u.user_id (+) = v.level_value
and profile_option_value = 'Y'
order by 2,1,3,4;

Avarage time for completed Concurrent Requests

It provides the average time taken by requests to run.

SELECT /*+ index(r FND_CONCURRENT_REQUESTS_N6) */ f.application_short_name apps, p.concurrent_program_name, 
   p.user_concurrent_program_name description, COUNT(*) COUNT,
   DECODE(TRUNC(AVG(actual_completion_date - actual_start_date)), 0, NULL, TRUNC(AVG(actual_completion_date - actual_start_date)) || ' Days' || ' + ') || 
   TO_CHAR(TO_DATE(TRUNC(MOD(AVG(actual_completion_date - actual_start_date),1) * 86400), 'SSSSS'), 'HH24:MI:SS') average,
   DECODE(TRUNC(MAX(actual_completion_date - actual_start_date)), 0, NULL, TRUNC(MAX(actual_completion_date - actual_start_date)) || ' Days' || ' + ') || 
   TO_CHAR(TO_DATE(TRUNC(MOD(MAX(actual_completion_date - actual_start_date),1) * 86400), 'SSSSS'), 'HH24:MI:SS') MAX,
   DECODE(TRUNC(MIN(actual_completion_date - actual_start_date)), 0, NULL, TRUNC(MIN(actual_completion_date - actual_start_date)) || ' Days' || ' + ') || 
   TO_CHAR(TO_DATE(TRUNC(MOD(MIN(actual_completion_date - actual_start_date),1) * 86400), 'SSSSS'), 'HH24:MI:SS') MIN
FROM applsys.fnd_concurrent_request_class c,
     applsys.fnd_application f,
     apps.fnd_concurrent_programs_vl p,
     applsys.fnd_concurrent_requests r
WHERE r.program_application_id = p.application_id
   AND r.concurrent_program_id = p.concurrent_program_id
   AND r.phase_code='C' AND r.status_code = 'C' 
   AND actual_completion_date BETWEEN SYSDATE-2 AND SYSDATE
   AND p.application_id = f.application_id
   AND r.program_application_id = f.application_id
   AND r.request_class_application_id = c.application_id(+)
   AND r.concurrent_request_class_id = c.request_class_id(+)
-- AND p.concurrent_program_name LIKE '%XXCUST%'
-- AND p.user_concurrent_program_name like '%SSO%'
GROUP BY c.request_class_name, f.application_short_name,
   p.concurrent_program_name, p.user_concurrent_program_name, r.priority
ORDER BY average DESC, APPS ASC;

Find Concurrent Programs with trace enabled

It shows which programs are defined with Trace enabled. Generally, you should enable trace for a program while you are debugging, but then you should turn it off when you're done.

SELECT A.CONCURRENT_PROGRAM_NAME "Program Name",
SUBSTR(A.USER_CONCURRENT_PROGRAM_NAME,1,40) "User Program Name",
SUBSTR(B.USER_NAME,1,15) "Last Updated By",
SUBSTR(B.DESCRIPTION,1,25) DESCRIPTION
FROM APPS.FND_CONCURRENT_PROGRAMS_VL A, APPLSYS.FND_USER B
WHERE A.ENABLE_TRACE='Y'
AND A.LAST_UPDATED_BY=B.USER_ID;

Weblogic Patch - BSU Commands

To apply the patch:

./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=AAAA prod_dir=$FMW_HOME/wlserver_10.3

To remove/rollback the patch:

./bsu.sh -remove -patchlist=BBBB -prod_dir=$FMW_HOME/wlserver_10.3

To find the applied patch:

./bdu.sh -prod_dir=$FMW_HOME/wlserver_10.3 -status=applied -verbose -view

To find the downloaded patch:

./bsu.sh prod_dir=$FMW_HOME/wlserver_10.3 -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -status=downloaded -view -verbose 

Oacore Service Not Starting

Error: While starting oacore service we are getting below error

Caused By: javax.security.auth.login.FailedLoginException: [Security:090303]Authentication Failed: User weblogic weblogic.security.providers.authentication.LDAPAtnDelegateException: [Security:090295]caught unexpected exception

Solution:

Remove the ldap folder from below location

                       

$DOMAIN_HOME/servers/oacore_server1/data

Retry the issue

Password Changing Steps for Operations User

How to change the password for operations user in Oracle EBS.

When we are trying to change the operations user password using FNDCPASS command, we will get the below error notifications.

$FNDCPASS apps/apps 0 Y system/manager USER operations  password
Log filename : L7746964.log

Report filename : O7746964.out

$cat L7746964.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

 module:
+---------------------------------------------------------------------------+

Current system time is 09-OCT-2018 15:04:42

+---------------------------------------------------------------------------+

This password is not managed by Oracle Applications so it can not be changed here.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 09-OCT-2018 15:04:42

+---------------------------------------------------------------------------+

Solution:

We have to change the operations user password through EBS Application url. 
System Administrator -> User -> Define

EBS 12.1.3 Login Page not working

Issue:

On : 12.1.3 version:

When attempting to login to ebs application, the following error occurs:

Error:

You have encountered an unexpected error. Please contact the System Administrator for assistance.

The Error Detail page displays:

Exception Details. 
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: select /*+ ORDERED PUSH_SUBQ USE_NL (WN WL WIT) index(WN WF_NOTIFICATIONS_N1)*/ WN.NOTIFICATION_ID,

## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904: "WN"."SENT_DATE": invalid identifier

Solution:

Follow the below steps to fix the issue.

1. Stop the application tier services.

2. Use adodfcmp utility to alert the table:

cd $FND_TOP/patch/115/odf

adodfcmp odffile=afwf.odf mode=tables changedb=Yes \

userid=applsys/apps touser=apps/apps priv_schema=SYSTEM/manager

3. Restart the application tier services.
4. Retest the issue.

Recreate the appsutil/scripts directory

Issue: The $ORACLE_HOME/appsutil directory or subdirectories of appsutil are missing.

Solution:

To implement the solution, please update the RDBMS ORACLE_HOME file system with AutoConfig files from the AppsTier by performing the following steps exactly:

1. On the Application Tier (as the APPLMGR user):

2. Log in to the APPL_TOP environment and source the environment file

3. Create appsutil.zip file: "perl /bin/admkappsutil.pl"
(This will create appsutil.zip in $APPL_TOP/admin/out/appsutil.zip)

4. Copy or FTP the appsutil.zip file to the RDBMS $ORACLE_HOME

5. On the Database Tier (as the ORACLE user):
$ cd $ORACLE_HOME

$ unzip -o appsutil.zip

6. Generate the Database Context File:

Context File Creation on Linux:

$ cd $ORACLE_HOME

$ *.env

$ cd $ORACLE_HOME/appsutil/bin

$ perl adbldxml.pl tier=db appsuser= appspasswd=

$ cd $ORACLE_HOME/appsutil/bin


$ adconfig.sh contextfile= appspass=

Find OPP Log File Using Concurrent Request ID

Select logfile_name from fnd_concurrent_requests where request_id = 11111111;


Select 
fcpp.concurrent_request_id req_id, 
fcp.node_name, 
fcp.logfile_name 
FROM 
fnd_conc_pp_actions fcpp, 
fnd_concurrent_processes fcp 
where 
fcpp.processor_id = fcp.concurrent_process_id 
AND 
fcpp.action_type = 6 
AND 
fcpp.concurrent_request_id = 1111111;