Oracle EBS R12.1.3 - WebADI with 64bit Office

 

Issue 1: Users are unable to open WebADI Document in some of the PC with Office 2010.

Error: java.lang.NoSuchMethodError: oracle.apps.bne.utilities.oa.BneDFFStructure.setValType(Ljava/lang/String;)



Solution:
1. Apply Patch - 14209751:R12.BNE.B
2. Bounce Middle-tier

Change:
BneDFFStructure.java 120.1.12010000.2 2009/08/03 16:23:37
to
BneDFFStructure.java 120.1.12010000.4 2012/11/30 19:32:09

Install AWS Command Line Interface on Oracle Linux 5

1. Download Active Perl from below website
2. Download AWS CLI from the Amazon website


1. Install Active Perl

cd /tmpwget http://downloads.activestate.com/ActivePython/releases/2.7.8.10/ActivePython-2.7.8.10-linux-x86_64.tar.gztar -xzvf ActivePython-2.7.8.10-linux-x86_64.tar.gzcd ActivePython-2.7.8.10-linux-x86_64
[root@bastion ActivePython-2.7.8.10-linux-x86_64]# ./install.shEnter directory in which to install ActivePython. Leave blank andpress 'Enter' to use the default [/opt/ActivePython-2.7].Install directory:()Installing ActivePython to '/opt/ActivePython-2.7'...Relocating dir-dependent files...

2. Install AWS CLI

cd /tmp
export PATH=/opt/ActivePython-2.7/bin:$PATH
wget https://s3.amazonaws.com/aws-cli/awscli-bundle.zip
[root@bastion tmp]# export PATH=/opt/ActivePython-2.7/bin:$PATH
[root@bastion tmp]# ./awscli-bundle/install -i /usr/local/aws -b /usr/local/bin/aws
Running cmd: /opt/ActivePython-2.7/bin/python virtualenv.py --python /opt/ActivePython-2.7/bin/python /usr/local/aws
Running cmd: /usr/local/aws/bin/pip install --no-index --find-links file:///tmp/awscli-bundle/packages awscli-1.4.0.tar.gz
You can now run: /usr/local/bin/aws --version
[root@bastion tmp]# /usr/local/bin/aws --version
aws-cli/1.4.0 Python/2.7.8 Linux/2.6.18-194.0.0.0.3.el5xen
[root@bastion tmp]#

3. Configure AWS 

[root@sar12vis tmp]# aws configure

AWS Access Key ID [None]: xxxxxxxxxxxxxxxxxxxxxxAWS

Secret Access Key [None]: xxxxxxxxxxxxxxxxxxxxxx

Default region name [None]: ap-southeast-1

Default output format [None]:

[root@sar12vis tmp]#

4. Ready to use

[xxxx@bastion ~]$ aws ec2 help

Gather Schema Statistics

Gather Stats in Oracle E-Business Suite with improved (Auto sampling) features of Oracle Database 11gR2 

Schedule Concurrent Request:

Schema Name:
Estimate Percent:
Degree:
Backup Flag:
Restart Request ID:
History Mode: Backup existing statistics prior to gather new statistics
Gather Options: (GATHER_AUTO Option - gather statistics for tables based upon % change)
Modifications Threshold:
Invalidate Dependent Cursors:

Know Issue and fixes 

Error 1- ORA-20005: object statistics are locked
**Starts**24-JUN-2014 21:00:54
ORACLE error 20005 in FDPSTP
Cause: FDPSTP failed due to ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "APPS.FND_STATS", line 780
ORA-06512: at line 1
.
The SQL statement being executed at the time of the error was: SELECT R.Con
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag=
stats on table AQ$_WF_CONTROL_P is locked
stats on table FND_CP_GSM_IPC_AQTBL is locked
stats on table FND_SOA_JMS_IN is locked
stats on table FND_SOA_JMS_OUT is locked
ORA-20005: object statistics are locked (stattype = ALL)
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

Solution:

Unlock object statistics:

exec dbms_stats.unlock_table_stats('APPLSYS','AQ$_WF_CONTROL_P');
exec dbms_stats.unlock_table_stats('APPLSYS','FND_CP_GSM_IPC_AQTBL');
exec dbms_stats.unlock_table_stats('APPLSYS','FND_SOA_JMS_IN');
exec dbms_stats.unlock_table_stats('APPLSYS','FND_SOA_JMS_OUT');

Error 2- ORA-20005: object statistics are locked

**Starts**24-JUN-2014 21:11:03

ORACLE error 20001 in FDPSTP

Cause: FDPSTP failed due to ORA-20001: SYS_NT8GWEU//JUHJGQKJAFGGSUG== is an invalid identifier

ORA-06512: at "APPS.FND_STATS", line 774

ORA-06512: at line 1

.

The SQL statement being executed at the time of the error was: SE

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

Start of log messages from FND_FILE

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

In GATHER_SCHEMA_STATS , schema_name= ALL percent= 10 degree = 8 internal_flag=

ORA-20001: SYS_NT8GWEU//JUHJGQKJAFGGSUG== is an invalid identifier

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

End of log messages from FND_FILE

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

Solution:

apply patch - 9542112 [ERROR IN R12 FOR GATHER SCHEMA STATS WITH GATHER AUTO OPTION to a non critical environment]

Reference:
When Using Gather Auto Option Errors - Is an Invalid Identifier (Doc ID 1363044.1)

Before - Overall Average Age in Days

How configure X11 Forwarding in CentOS/RHEL 6/7

X11 forwarding refers to executing such a program remotely through an SSH (Secure Shell) connection. It’s mean the executable file itself is hosted on a different machine than where the graphical interface is being displayed. The graphical windows are forwarded to your local machine through the SSH connection

# Install Required Packages
yum install -y xorg-x11-server-Xorg xorg-x11-xauth xorg-x11-apps


# Enable X11 Fowarding

cp -p  /etc/ssh/sshd_config /etc/ssh/sshd_config.orig
vim /etc/ssh/sshd_config

#Change these 2.

X11Forwarding yes
X11UserForwarding yes


# Restart SSH Service

systemctl restart sshd
service sshd restart

#Install xmin software
Download it from here

# Test Connection

run xclock

Oracle EBS compile APPS schema without running adadmin

Script to check the invalid objects:

select count(*), object_type 
from dba_objects 
where STATUS='INVALID' 
group by object_type;



SQL> @invobj

  COUNT(*) OBJECT_TYPE
---------- -----------------------
         2 PROCEDURE
      5137 VIEW
        57 TRIGGER
       157 FUNCTION
         3 MATERIALIZED VIEW
        13 SYNONYM
     13749 PACKAGE BODY
      2993 PACKAGE

compile objects via script:

APPS_PASS=apps

SYSTEM_PASS=manager

sqlplus -s APPS/$APPS_PASS @$AD_TOP/sql/adutlrcmp.sql APPLSYS $APPS_PASS APPS $APPS_PASS $SYSTEM_PASS 0 0 NONE FALSE

Oracle EBS Profile Option Values

Reference

Note: 201945.1 – How To List E-Business Suite Profile Option Values For All Levels Using SQLPlus
Note: 470102.1 – How To Check If a Profile Option Is Set In Oracle Application
Note: 367926.1 – How To Find All Users With A Particular Profile Option Set?
Note: 282382.1 – How to Search all of the Profile Options for a Specific Value
Note: 803587.1 – Script To List The Values Of A Profile Option At All Levels
Note: 364503.1 – How To Set A System Profile Value Without Logging In To The Applications
Note: 943710.1 – How to Change Profile Option Value Without Forms

SQL Query to select profile option from the database


set long 10000
set pagesize 500
set linesize 160
column SHORT_NAME format a30
column NAME format a40
column LEVEL_SET format a15
column CONTEXT format a30
column VALUE format a40
select p.profile_option_name SHORT_NAME,
n.user_profile_option_name NAME,
decode(v.level_id,
10001, 'Site',
10002, 'Application',
10003, 'Responsibility',
10004, 'User',
10005, 'Server',
10006, 'Org',
10007, decode(to_char(v.level_value2), '-1', 'Responsibility',
decode(to_char(v.level_value), '-1', 'Server',
'Server+Resp')),
'UnDef') LEVEL_SET,
decode(to_char(v.level_id),
'10001', '',
'10002', app.application_short_name,
'10003', rsp.responsibility_key,
'10004', usr.user_name,
'10005', svr.node_name,
'10006', org.name,
'10007', decode(to_char(v.level_value2), '-1', rsp.responsibility_key,
decode(to_char(v.level_value), '-1',
(select node_name from fnd_nodes
where node_id = v.level_value2),
(select node_name from fnd_nodes
where node_id = v.level_value2)||'-'||rsp.responsibility_key)),
'UnDef') "CONTEXT",
v.profile_option_value VALUE
from fnd_profile_options p,
fnd_profile_option_values v,
fnd_profile_options_tl n,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
where p.profile_option_id = v.profile_option_id (+)
and p.profile_option_name = n.profile_option_name
and upper(p.profile_option_name) in ( select profile_option_name
from fnd_profile_options_tl 
where upper(user_profile_option_name) 
like upper('%&user_profile_name%'))
and usr.user_id (+) = v.level_value
and rsp.application_id (+) = v.level_value_application_id
and rsp.responsibility_id (+) = v.level_value
and app.application_id (+) = v.level_value
and svr.node_id (+) = v.level_value
and org.organization_id (+) = v.level_value
order by short_name, user_profile_option_name, level_id, level_set;
/

Update profile value from the apps user.

set serveroutput on 

DECLARE 

stat BOOLEAN; 

BEGIN 

stat := FND_PROFILE.SAVE('APPS_SSO_LINK_SAME_NAMES','Y','SITE'); 

IF stat THEN 

dbms_output.put_line( 'Profile APPS_SSO_LINK_SAME_NAMES updated with Enabled' ); 

ELSE 

dbms_output.put_line( 'Profile APPS_SSO_LINK_SAME_NAMES could NOT be updated with Enabled' ); 

commit; 

END IF; 

END; 

/

Oracle EBS Concurrent Mangers logs files

Concurrent Managers log files are located in the $APPLCSF/$APPLLOG location



cd $APPLCSF/$APPLLOG
For ICM Log                     –> ls -lrt *$TWO_TASK*
For Standard manager Log        –> ls -lrt w*.mgr
For Conflict Resolution manager Log –> ls -lrt c*.mgr

SQL Query to get ICM manager log file location

SELECT 'ICM_LOG_NAME=' || fcp.logfile_name

FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq

WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id

AND fcp.queue_application_id = fcq.application_id

AND fcq.manager_type = '0'

AND fcp.process_status_code = 'A';