OTM Auto-Complete Feature

OTM Provides a Auto Complete Feature which is very helpful while filling data into fields of OTM. It could while you are searching for something, or for adding new objects, this feature is very handy. 


To Enable this feature, you need to edit glog.web.properties file in your servers. It'll be located in <OTM_Installation_Path>/glog/config folder. 


Below are the 3 lines to be added

glog.ui.autocomplete=true
glog.ui.autocomplete.start=3
glog.ui.autocomplete.limit=5

First setting is to set the feature ON

Second setting defines, when to start showing the list of matching values. In the above example, the value is 3. So if you are entering Russia in a country field, when you finish 3 characters (Rus), OTM will show you Russia in the list. 

Third line (limit) defines how many matching records should be shown in the auto complete list. 

For eg: You are entering a user id - Johnston, and if there are 10 names starting with John, After you type 3 characters, instead of all matching records(10names), OTM will show only 5. You need to type more characters to see more refined list. 

OTM User Preference

OTM User Preference is a combination of different preferences and settings for a user or a user role or an entire domain. 


To Create a User Preference:

1. Navigate to Configuration and Administration > Preferences > User Preferences
2. Click on 'New' Button
3. Enter a unique User Preference ID
4. Choose the appropriate domain
5. Choose a preference name from the drop down list and its value. click on save button
6. Repeat step 5 to set up different types of preferences.

Commonly used preference settings:

Name	Details	Values	Default
Ask OTM State	Controls the display of Ask OTM wizard tool bar	Show or Hide	Show
Business Monitor	Defines which BM should be visible for a user	Valid Business Monitors available	None
Country	Related to language settings	Canada, China, France, Germany, GB, Italy , USA etc	United States
Currency	Unit of Currency	Around 75 currencies	USD
Date Format	Defines how the date should appear to the user	Various options
Day-of-Week Start	The day to be considered as the start of the week	Sunday or Monday	Sunday
Distance	The unit of measure for distance data.	Miles, Nautical Miles, KMs	Miles
Duration	The unit of time measurement	Seconds, Minutes, Hours, Days, Weeks	Hours
Length	The Unit of measure for lengths	Centimetres, Inches, Feet, yards, Meters	Feet
Finder Click Action	Controls how to open objects when selected from search results	Always open in same window Always open in new window Replace current window	Replace Current Window
Finder Page size	Controls the max no. records appear per page on a screen set results tab	Optimal is between 25 and 100	25
Language	Language of the application labels, screens etc	Chinese, English, French, German, Italian etc	English
Results Query Line State	Controls the display of query section that appears by default at the bottom of every results page	Hidden Visible	Visible
Speed	The unit of measure for distance/time	Miles per Hour Kilometres per Hour	Miles per hour
Stylesheet Location	This is for branding purposes. We can specify a location from which webserver has to pick style sheets.	Value representing the location.	Default
Temperature	The scale of measurement for temperature	Fahrenheit , Kelvin, Celsius	Fahrenheit
Time Format	The format of time	hh:mm a z: 11:59 p.m. EST hh:mm a: 11:59 p.m. hh:mm: 23:59 hh:mm z: 23:59 EST	hh:mm a z: 11:59 p.m. EST
Time Zone	Time Zone used to calculate time records	World Time Zones	EST
Volume	The unit of measure for volume.	Cubic Feet Litres Cubic Meters Gallons Canadian Gallon Cubic Yards Cubic Inches	Cubic Feet
Weight	The unit of measure for weight.	Pound Kilogram Metric Ton Ton Kilopound	Pound

Database Table Names:

------------------------

USER_PREFERENCE table stores the data of all user preferences

USER_PREFERENCE_D table stores the individual preference details of each User Preference. 

For Eg: If we create a User Preference TEST_PREF with 2 settings

Volume - Litres

Language - French

USER_PREFERENCE will contain a single record for TEST_PREF details

where as USER_PREFERENCE_D will have 2 records

TEST_PREF | Volume | Litres

TEST_PREF | Language | French

User Management

User Management is an important part in OTM Setup. 


Below are the list of setup's required as part of User Management. 
1. VPD Contexts
2. VPD Profile
3. User Role
4. User Preferences
5. User Menu
6. Creating Users
7. Assigning Preferences & Menus to users. 


VPD stands for Virtual private database. These are used to restrict the user access to a particular section of the actual database. Many VPD contexts and profiles can be created based on the business requirement. 
For Eg: A Logistics Manager should be able to view all orders where as a merchandiser should be able to see only orders with Destination Country 'USA'. 


User role can be created by linking the VPD Context and Profile to it. 


User Preferences can be created an linked to a individual user or a user role. Preferences usually contain the options like Business Monitor, Date format, language, etc.,


User Menu's can be created by the admin and assign to a user based on the requirement. 


We'll look into each module separately in subsequent posts. 

OTM - Login Remember

OTM does provide an option to enable 'Remember password' option with which users can save user id and password on the OTM login page. 


To Enable this feature, modify the file glog.webserver.properties in webserver. 
File is available at folder <OTM_installation_path>/glog/config/


Change the below to property to disable
glog.webserver.login.remember=false
and to enable
glog.webserver.login.remember=true


Application need  to be restarted/bounced for these changes to take effect. 

When the feature is enabled, you will see a 'Remember Me' check box. Once you select it and login , user id/password will be auto filled every time login page is accessed. 

After you logout, if you select 'Login as a different user' , OTM will take you to login page and the saved password details will be erased. 

Oracle Transportation Management

Oracle Transportation Management delivers robust transportation planning and execution capabilities to shippers and third party logistics providers. It integrates and streamlines transportation planning, execution, freight payment, and business process automation on a single application across all modes of transportation, from full truckload to complex multileg air, ocean, and rail shipments.


Oracle Transportation Management lowers transportation costs, improves customer service and asset utilization, and provides flexible, global fulfillment options.


Regardless of the size or volume of your business, Oracle Transportation Management delivers the capabilities you need in an open, standards-based architecture that allows you to start with a single component or a mix of components. It also provides the flexibility to grow easily, without installing or reinstalling added functionality.


Oracle Transportation Management can be used with an enterprise resource planning or legacy order management system, as well as any commercial best-of-breed or legacy warehouse management system.


Oracle Transportation Management integrates with Oracle E-Business suite, Oracle Order Management, JD Edwards Enterprise One, Siebel CRM and Oracle Warehouse Management.


Source