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

Wednesday, July 28, 2010

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]

Monday, July 19, 2010

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.

Wednesday, July 14, 2010

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.

Wednesday, July 7, 2010

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