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]

8 comments:

Aseem said...

Hi
We are not able to see the OTM S/w from E-Delivery, can you kindly explain me which product we need to select

Vikram Das said...

Hi Aseem,

Go to edelivery.oracle.com and login:

Select a Product Pack: E-Business Suite
Platform: Your operating system
Click on Go
Scroll down on the new page which appears

You'll find "Oracle Transportation Management 6.2" towards the end.

- Vikram

Jhansi said...

Hi,

Where do we get to know the database requirements specific to OTM like

What kind of db are we talking about (OLTP, date warehouse)?

What are the best practices in a RAC infrastructure?

How many users?

Size of db ?

Any special db parameter setting?

Thanks,
Jhansi

Jhansi said...

Hi,

How do we get to know the database environment requirements specific to OTM like

What kind of db are we talking about (OLTP, date warehouse)?

What are the best practices in a RAC infrastructure?

How many users?

Size of db ?

Any special db parameter setting ?

Thanks,
Jhansi

Jhansi said...

Hi,

How do we get to know the database environment requirements specific to OTM like

What kind of db are we talking about (OLTP, date warehouse)?

What are the best practices in a RAC infrastructure?

How many users?

Size of db ?

Any special db parameter setting ?

Thanks,
Jhansi

Pawan Singh said...

Hi Vikram Sir,

Can you tell us if there where any steps that you took outside the Administrative Guide for 6.2 Installation.

Regards
Pawan Deep Singh

Sunil Goswami said...

Sir,
I m not able to see the otm s/w in the list ...and will it be useful to a small firm

Adil Vohra said...

It is oltp system and a logistic application

Thanks,
Mohammed Hussain