Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Tuesday, November 17, 2009

See Legacy SR# in new Metalink

I found this from Migration FAQ of Classic Metalink available on
http://www.oracle.com/us/support/040368

How do I view the old Service Request number on my Service Request?
As part of Oracle's move to a single system for tracking SRs, SR numbers were changed.

You can view the Classic MetaLink SR number in the Legacy SR Number field in the SR views on My Oracle Support. To add the Legacy SR Number field to the Service Request list region click the table icon in the upper left hand corner of the list view. Select Columns > Legacy SR. You may sort on this field by clicking the column header.

Monday, November 16, 2009

Notes from the field: Issues after going live with Sun JRE plugin

We went live with Sun JRE plugin on our first instance in the weekend. As expected, we got lot of calls for issues. Here's a list:

1. Proxy issues: All our ERPs are configured with load balancers. However, whenever a JVM like Jinitiator / Sun JRE is used, the connection is always between the forms server port and the user's PC directly. This is blocked by proxies. Being an internal site, we have configured IE to exclude the internal site's name in exclusion list. We also configured Java Control Panel applet to connect directly instead of using Browser Settings.

2. Popup windows don't popup but appear minimized: Described in Metalink Note 864861.1:

Cause
This issue is caused by a new 'feature' in Java 1.6.0_10 and above
More details of the feature can be found at:
http://www.java.com/en/download/help/new_plugin.xml?jre=6.0

Solution
To implement the solution, please execute the following steps:
Note - this is a client machine specific solution:
1. Click Start.
2. Click Control Panel.
3. Double click on Java Control Panel.
4. Click Advance tab in Java Control Panel.
5. Scroll to Java Plug-in entry.
6. Uncheck the check box for Enable next-generation Java Plug-in

3. JRE refuses to install : This was a weird one as nothing happened when we clicked on the Sun JRE executable downloaded to local disk. It turns out that the user's PC had issues and many other executables could not be installed as well. I have suggested to install this after booting Windows in Safe Mode.

Will update as I learn more.

Are there any standards / templates for development forms that are pure jsp within Oracle ERP?

Steve asked me this question today. Many months back Srinivas Reddy had asked me a similar question and I had found out about the existance of Oracle Applications Framework Developer's Guide. So I searched My Oracle Support for this and landed up with two metalink notes:

Note 269138.1 Oracle Applications Framework Developer's Guide 11.5.10 RUP5

Note 858398.1 Oracle Applications Framework Developer's Guide 11.5.10 RUP7

Unfortunately, I was unable to locate a version for RUP6.

Thursday, November 12, 2009

How to start trace of an existing session in 10g

10g has a new package called DBMS_MONITOR

EXECUTE DBMS_MONITOR.SESSION_TRACE_ENABLE(&sid,&serial,waits=>true, binds=>false);

To disable
EXECUTE DBMS_MONITOR.SESSION_TRACE_DISABLE(&sid,&serial)

My old article on tracing

http://oracleappstechnology.blogspot.com/2007/07/activate-extended-sql-trace-for-given.html

Tuesday, November 10, 2009

Account setup is still in progress. Please come back later.

We were informed by Oracle that Classic Metalink will retire this weekend and everyone has to start using the new metalink or My Oracle Support. They sneaked in Oracle SSO (OTN user id) integration sometime back. I set up the relationship between my metalink id and existing Oracle SSO (OTN id). During the weekend, we had some issues and I was not able to login with my Oracle SSO (OTN id). It gave this message:

Account setup is still in progress. Please come back later.

I tested with different browsers:

IE6 gives this error:

My Oracle Support Serivces Error

A server connection error occurred.

IO Error Error #2032

Please Try again later.

Firefox, Chrome and Opera give this error:
Account setup is still in progress. Please come back later.

After googling for sometime I found that the new site has an html interface which can be accessed through

http://supporthtml.oracle.com

I tried logging in through this and was successful.

I called Oracle Support and they have logged in an SR on my behalf for this issue. They told me that it is a known issue and a lot of users are facing this. They will inform me via email, when this gets resolved.

Sunday, November 8, 2009

How to install lsof version 4.8

In Solaris 10, lsof version 4.7 and lower gives incorrect results. To get correct results from lsof you must install lsof version 4.8 or higher.

First download lsof version 4.8 from sunfreeware
ftp://ftp.sunfreeware.com/pub/freeware/sparc/10/lsof_1106-4.80-sol10-sparc-local.gz

Login as root

Remove the existing lsof version which is lower than 4.8

# pkgrm SMClsof

# pkgadd -d lsof_1106-4.80-sol10-sparc-local

The following packages are available:
1 SMClsof lsof
(sparc) 4.80

Select package(s) you wish to process (or 'all' to process
all packages). (default: all) [?,??,q]: all

Processing package instance from

lsof(sparc) 4.80
Vic Abell
Using as the package base directory.
## Processing package information.
## Processing system information.
3 package pathnames are already properly installed.
## Verifying disk space requirements.
## Checking for conflicts with packages already installed.

The following files are already installed on the system and are being
used by another package:
/usr/local/doc
/usr/local/man
/usr/local/man/man8

Do you want to install these conflicting files [y,n,?,q] y
## Checking for setuid/setgid programs.

The following files are being installed with setuid and/or setgid
permissions:
/usr/local/bin/lsof
/usr/local/bin/sparcv7/lsof
/usr/local/bin/sparcv9/lsof

Do you want to install these as setuid/setgid files [y,n,?,q] y

Installing lsof as

## Installing part 1 of 1.
/usr/local/bin/lsof
/usr/local/bin/sparcv7/lsof
/usr/local/bin/sparcv9/lsof
/usr/local/doc/lsof/00.README.FIRST
/usr/local/doc/lsof/00CREDITS
/usr/local/doc/lsof/00DCACHE
/usr/local/doc/lsof/00DIALECTS
/usr/local/doc/lsof/00DIST
/usr/local/doc/lsof/00FAQ
/usr/local/doc/lsof/00LSOF-L
/usr/local/doc/lsof/00MANIFEST
/usr/local/doc/lsof/00PORTING
/usr/local/doc/lsof/00QUICKSTART
/usr/local/doc/lsof/00README
/usr/local/doc/lsof/00TEST
/usr/local/doc/lsof/00XCONFIG
/usr/local/doc/lsof/lsof.man
/usr/local/man/man8/lsof.8
[ verifying class ]

Installation of was successful.
# lsof -v
lsof version information:
revision: 4.80
latest revision: ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/
latest FAQ: ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/FAQ
latest man page: ftp://lsof.itap.purdue.edu/pub/tools/unix/lsof/lsof_man
configuration info: 64 bit kernel
constructed: Thu Jul 10 20:12:17 EDT 2008
constructed by and on: steve@v480
compiler: gcc
compiler version: 3.4.3 (csl-sol210-3_4-branch+sol_rpath)
compiler flags: -Dsolaris=100000 -DHASPR_GWINDOWS -m64 -DHASIPv6 -DHASSOUXSOUA -DHAS_IPCLASSIFIER_H -DHAS_CRED_IMPL_H -DHAS_V_PATH -DHASZONES -DHAS_ZFS=1 -DHASUTMPX -DHAS_VSOCK -DHAS_STRFTIME -DLSOF_VSTR="5.10" -O
loader flags: -L./lib -llsof -lkvm -lelf -lsocket -lnsl
system info: SunOS v480 5.10 Generic_118833-33 sun4u sparc SUNW,Sun-Fire-480R Solaris
Anyone can list all files.
/dev warnings are enabled.
Kernel ID check is enabled.
WARNING: privately defined ZFS structures may be incorrect.
Device cache file read-only paths:
Named via -D: none
Named in environment variable LSOFDEVCACHE: none
Personal path format (HASPERSDC): "%h/%p.lsof_%L"
Modified personal path environment variable: LSOFPERSDCPATH
LSOFPERSDCPATH value: none
Personal path: /.lsof_server1000
Device cache file write paths:
Named via -D: none
Named in environment variable LSOFDEVCACHE: none
Personal path format (HASPERSDC): "%h/%p.lsof_%L"
Modified personal path environment variable: LSOFPERSDCPATH
LSOFPERSDCPATH value: none
Personal path: /.lsof_server1000

Friday, November 6, 2009

Configurator performance issue in Order Entry

Today, Bimal pinged me about a performance issue with Configurator in Order Entry. He told me that the page CZInitialize.jsp was taking 7 minutes to appear. In a different instance on the same server it was taking 30 seconds. I asked him whether he had collected statistics for ONT. He said he had collected for ONT and APPLSYS.

I searched in Metalink with keywords Configurator performance Order Entry and came across Note 130511.1 which gives this suggestion:

The first step in troubleshooting performance problems is to ensure that the customer has recently gathered statistics and that it was done correctly. The following schemas may impact performance in the OM product suite: ONT, WSH, QP, INV, AK, MRP, HZ, CZ, APPLSYS.

I told Bimal about this and he executed the following commands:

exec fnd_stats.gather_schema_statistics('ONT') ;
exec fnd_stats.gather_schema_statistics('WSH') ;
exec fnd_stats.gather_schema_statistics('QP') ;
exec fnd_stats.gather_schema_statistics('INV') ;
exec fnd_stats.gather_schema_statistics('AK') ;
exec fnd_stats.gather_schema_statistics('MRP') ;
exec fnd_stats.gather_schema_statistics('HZ') ;
exec fnd_stats.gather_schema_statistics('CZ') ;
exec fnd_stats.gather_schema_statistics('APPLSYS') ;

The issue was resolved immediately. Always check for statistics as a cause for performance problems in a CBO world.