Oracle Transportation Management (OTM) installation on Solaris 10

We got a new project which uses OTM. Here are the high level steps for installation of OTM:

1. Go to edelivery.oracle.com, enter your information and login.
2. Select E-Business Suite in dropdown
3. Scroll Down to Oracle Transportation Management
4. Download OTM and Weblogic Server
5. Download RDBMS 11gR2 Server and Client from Oracle Technology Network
6. Install 11gR2 Database and create a blank database
7. Install Weblogic Server
8. Install OTM
9. Execute the file $OTM_HOME/install/gc3env.sh
10. Go to $OTM_HOME/glog/oracle/script8 and edit a file called create_all.sql modify the line which reads:
41 SELECT DECODE(UPPER(nvl('&&4','Y')),'Y','./import_content.sh','N','imp
ort_content.cmd') ws_content_import

Change ./import_content.sh to . ./import_content.sh

If you don't do this, this script fails. This issue is documented in My Oracle Support Articles:
Installation or Oracle Transportation Management 6.0 on Solaris [ID 974412.1]
Cannot Log on to a new OTM 6.0 Installation [ID 975529.1]

No fields appear after username in Workflow configuration page

I got a mail about an issue after April 2010 CPU patches. Nothing was appearing after the user field in Workflow Configuration page in Oracle Applications Manager

Solution was given by Imran:

"NOTE: - Execute the steps given in 1082747.1 - defective share.zip After applying this patch"

The issue was related to the missing class files under $JAVA_TOP/oracle/bali/share/nls folder, after restoring them the issue was fixed.

dbms_utility.port_string

While going through a trace file I came across this SQL:

SELECT DBMS_UTILITY.PORT_STRING FROM DUAL;

Dbms_utility.port_string allows to find out what hardware and OS an Oracle instance runs on:

SQL> SELECT DBMS_UTILITY.PORT_STRING FROM DUAL

PORT_STRING
--------------------------------------------------------------------------------
SVR4-be-64bit-8.1.0

This was run on a Solaris box which has Solaris 10 64-bit OS with 64-bit SPARC processors.

Oracle July 2010 CPU Article ID

While searching for something else on My Oracle Support I found this:

ORACLE CRITICAL PATCH UPDATE ADVISORY - JULY 2010 [ID 1127913.1]

Purpose

NOTE: THIS IS NOT AN OFFICIAL DOCUMENT - PLACEHOLDER ONLY

ORACLE CRITICAL PATCH UPDATE ADVISORY - JULY 2010

NOTE: THIS IS NOT AN OFFICIAL DOCUMENT - PLACEHOLDER ONLY

Gather Schema Statistics

Gurtej asked this question: While submitting gather schema stats for APPS ...what should be the estimate percent and degree should be ? How should GSS be scheduled in Production. Currently it is scheduled like this:
APPS, 10, 8, NOBACKUP, , LASTRUN, GATHER, , Y

Here's the answer gleaned from various articles in My Oracle Support:

There is no set schedule for gathering schema statistics. On some systems the program should be run weekly. On other systems once per month will be often enough. The schedule will vary greatly depending on the amount and nature of the data and how often the data changes.

It will be necessary to try different schedules over time and monitor performance to determine the most effective schedule.

As a general rule, run Gather Schema Statistics under the following circumstances:

1. After there has been a significant change in data in either content or volume.

2. After importing data.

3. Any time end-users notice a deterioration in performance in routine day-to-day business transactions or when running concurrent programs.

Estimate Percentage / Modification threshold defines the percentage which should be used to initiate gather stats for those objects which have actually changed beyond the threshold. The default is 10% (i.e. meaning any table which has changed via DML more than 10%, stats will be collected, otherwise it will be skipped

Further Reading: Tuning All layers of E-Business Suite:

OracleNavigate.Responsibility was not found on this server

We got this error in one of the instances cloned freshly on clicking on the
System Administration responsibility:

Not Found
The requested URL /pls/$ORACLE_SID/OracleNavigate.Responsibility was not found on this server.

Fix:

Change Self Service Personal Home Page mode profile option on site level to Framework Only