Oracle® Transportation Management Administration Guide Release 6.3 Part No. E38415-08 January 2015
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. x Preface This document contains information regarding the post-install con
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-24 The valid values are: none – No optimization so all domains are u
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-25 Functional Security CheckAccess Cache Sizes Oracle Transportation Man
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-26 Report Transformation. BI Publisher transforms the data XML stream
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-27 Note: These properties have no impact on scheduled reports: they alwa
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-28 Property Holds Default glog.bipreports.cleanup.<type>.frequency
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 14-1 14. Troubleshooting Known Issues Installation There are known problem
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 14-2
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. xi Date Document Revision Summary of Changes 12/2013 -05 Reference to Enabl
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. xii Date Document Revision Summary of Changes 1/2015 -08 Added section on H
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 1-1 1. Architecture Overview Oracle Transportation Management is built for
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 1-2 The Oracle Transportation Management web server uses the Oracle HTTP Se
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 1-3 The Integration server and the application server communicate to the ap
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 2-1 2. Configuring Optional Components These components include: Replica
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 2-2 following lines, setting the values on the right as appropriate (see th
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 2-3 2. Create a POP3 mailbox within your mail server that can be accessed
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. ii Oracle Transportation Management Administration Guide, Release 6.3 Part
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 2-4 2. Test the modem to ensure that it gets a dial tone and can access an
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 2-5 firstName lastName company phone rawPhone (punctuation
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 2-6 pcmiler.host=pcmiler.company.com pcmiler.port=8145 Uncomment and modify
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 2-7 lines, setting the values on the right as appropriate (see the relevant
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 2-8 Configuring Kewill FlagShip Install the Kewill FlagShip server as descr
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 3-1 3. Starting and Stopping the Oracle Transportation Management Servers S
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 3-2 INFO | 2012/11/12 10:38:16 | <Nov 12, 2012 10:38:16 AM PST> <N
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 4-1 4. Advanced Configuration: Custom Properties Much of the configuration
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 4-2 The resulting list of values for a.property is now value1 and value3. W
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 4-3 #-------------------------------------------------------------------- #
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. iii Contents CONTENTS ...
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 4-4 rather than in a file. Property sets can be modified via the Property S
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 4-5 !include glog.webserver.properties 2. Edit the glog.properties file fo
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 5-1 5. Advanced Configuration: Application Server Note: Default paths are u
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 6-1 6. Advanced Configuration: UI/Web Server Note: Default paths are used b
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 6-2 Installing Multiple Web Servers Multiple web servers can be utilized to
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 6-3 web server of all potential web servers. To do this you will need to ad
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 6-4 After <Connector address="localhost" port="8009&
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 6-5 Fusion Transportation Intelligence Translations Oracle Fusion Transpor
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. iv DISABLING PROPERTY SETS ...
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 7-1 7. Advanced Configuration: Database Note: Default paths are used below
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 7-2 Note that these properties are reserved and cannot be set as properties
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 7-3 Features/Limitations: Simple and straightforward. There is no need t
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 7-4 Domain Copy Oracle Transportation Management provides utilities to copy
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 7-5 insert into data_source (data_source_gid,data_source_xid,data_database_
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 7-6 Multiple Oracle Transportation Management Application Server Instances
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 8-1 8. Configuring Fusion Transportation Intelligence Configuring Oracle Tr
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 8-2 Setting the Status for New Objects: Oracle Transportation Management sh
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 8-3 Oracle Fusion Transportation Intelligence offers additional external pr
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. v CONFIGURING FUSION TRANSPORTATION INTELLIGENCE WITH OAM (SSO) ...
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 8-4 Creating Indexes First, you create indexes as follow: 1. Connect to th
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 8-5 f. Log out of Oracle Transportation Management. 3. Log back into Orac
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 9-1 9. Configuring Global Trade Intelligence Configuring Oracle Transportat
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 9-2 GTI_DEFAULT: This VPD profile is applicable for all Oracle Global Tr
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 10-1 10. Advanced Configuration: General Note: Default paths are used belo
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 10-2 7. Run 6.3 migration scripts according to the latest Migration Guide
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 10-3 Note that any preference directory not referenced explicitly in this m
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 10-4 UI Branding – CSS Files As part of the 6.3 installation, customized UI
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 10-5 Changing Notification Settings The Oracle Transportation Management se
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. vi MICROSOFT WINDOWS ...
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 10-6 Data > General > Unit of Measure. This page is only available wh
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 10-7 2. Set your currency storage default by running the following insert
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 10-8 Country Code Conversion from ISO Alpha-3 Code to Alpha-2 Code 1. Orac
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 10-9 Process Flow APIs for Compiling pkg_user_exit UserExitCompiler Class
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 10-10 Pkg_SQL_executor Package Class UserExitCompiler connects database thr
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 10-11 Your line would look like this: !include ebs.properties Once this cha
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 11-1 11. Advanced Configuration: LDAP This information has been moved to t
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 12-1 12. Performance Monitoring Performance monitoring is a necessary part
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. vii HASH PARTITIONING INDEXES ON RAC DATABASES ...
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 12-2 Force Garbage Collection: This will force the JVM to free up all un
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 12-3 system or iowait columns it could be an indication of other internal p
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 12-4 Oracle Transportation Management Tools Configuration Data Collection T
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 12-5 JVM Tools Console Logs For the web and application servers, system mon
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 12-6 <OTM_INSTALL_DIR>/jdk/bin/jrcmd <PID> jrarecording time=30
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 12-7 Are agents and integrations not processing? Record the exact tim
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-1 13. Performance Tuning JVM The JVMs supported by Oracle Transportatio
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-2 Web Server Simultaneous Users If your installation is going to have a
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-3 Application Server Logging Although logging is a vital function in Ora
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-4 Business Number Generator (BNG) Contention The Business Number Generat
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-5 DirectSQLUpdate DirectSQLUpdate is an agent action which allows you to
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-6 glog.workflow.topic.group.glog.server.agent.business.shipment.SlowTopi
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-7 Oracle Database also has automatic statistics gathering job GATHER_STA
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-8 Checking for Stale and Partial Oracle Database Statistics The followin
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-9 temporarily enable SQL logging in Oracle Transportation Management and
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-10 Statement Type Use Case Description Default, in seconds update direct
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-11 To use these services, users need to configure new connect strings in
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-12 7. Also query data dictionary to ensure that hash partitoned indexes
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-13 Parameters These parameters should be passed to the procedure in the
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. ix Send Us Your Comments Oracle Transportation Management Administration Gu
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-14 The transmission purge process accepts the following arguments: Age i
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-15 Range Partitioning Here is an example of partitioning, or segmenting,
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-16 Quarterly Monthly Weekly Daily IE_SHIPMENTSTATUS I_LOG (mobile) IE
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-17 If the table is monthly, then the data is segmented as follows: Mont
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-18 Note: I_TRANSACTION table’s OUTBOUND5 partition stores tender data. O
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-19 Purged partition 2 for table I_TRANSACTION_DETAIL Pur
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-20 It is recommended that, in an Oracle Transportation Management produc
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-21 performance. For example, that the Finder Page Size is set to 500. As
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-22 Inbound Integration Options Large Transmission Servlet The LargeTrans
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved. 13-23 Active Table Oracle Transportation Management implements data securit
Komentarze do niniejszej Instrukcji