Oracle Transportation and Global Trade Management Version 6.x Recommended Patch List (Doc ID 1081306.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Oracle Transportation Management
Information in this document applies to any platform.

Details

This note provides a list of key fixes available in 6.x's enhancement releases and roll-ups. In some cases, a MOS note number is provided that contains additional information.

Actions

You should review this list when considering what version to upgrade to and also when experiencing performance/stability issues.

Release 6.0

Oracle Transportation Management Version 6.0 Is Now Available - See MOS <Note 797263.1> for additional information

Release 6.0.7

This patch includes the following critical fixes
<Patch 9020042> - Materialized Views Cannot Be Created ON OTM ROD in Version 6.X - See MOS Note 978023.1 for additional information
<Patch 9215195> - Invoice Match Hangs When Using More Than One Refnum Qual Payment Match Rule
<Patch 9381418> - Clean Up Orphaned S_SHIP_UNIT Created From ActualShipment Integration
<Patch 9469321> - Issue With WebService Transmission
<Patch 10036430> - City Name Cutoff When Sent To Kewill

Release 6.1

Oracle Transportation Management Version 6.1 Is Now Available - See MOS <Note 980767.1> for additional information

Release 6.1.7

Oracle Transportation Management and Global Trade Management 6.1.7 Are Now Available MOS Note 1494239.1
This patch includes the following critical fixes
<Patch 9321330> - Can not Include "=" in Direct SQL Update Action in V6.1
<Patch 9347496> - update_onecsv_gtm.sh and update_onecsv_gtm.cmd Files are Missing
<Patch 9439275> - update_content.sh (CSVUTIL) Fails Intermittently During the Data Load in 6.1
<Patch 9447766> - Updated JDK Needed For OTM For CPUJAN2010
<Patch 9462751> - Locks Not Releasing and Timing Out
<Patch 9487105> - Full Installer is Missing Files For Installing FTI
<Patch 9400203> - Allocation Stopped To Prevent Endless Loop
<Patch 9500034> - Clean Up Orphaned S_SHIP_UNIT Created From ActualShipment Integration
<Patch 9673132> - ORA-01461 Generated Writing CLOB Data to the Database
<Patch 9673563> - "DBA.ADMIN, failed to be authenticated" Error In User Manager
<Patch 9483356> - Error missing entity saver ShipmentSEquipmentJoinData and ShipmentStopData
<Patch 9951033> - Kewill Requires Canadian Postal Code Formatting
<Patch 10051510> - City Name Cutoff When Sent To Kewill
<Patch 10069236> - Kewill Error "The Packing Group is required"
<Patch 10110189> - Kewill Shipments With Hazmat and Non-Hazmat Packages Fail to Rate
<Patch 10175242> - Kewill Send Hazmat Info Only When Line is Marked as Hazardous: Yes
<Patch 10080176> - Additional Language Support for FTI Reports
<Patch 12661164> - Deadlock Issue java.util.LinkedList.remove(LinkedList.java:225)
<Patch 13532928> - Prevent Deletion of a User Having Recurring Processes Associated
<Patch 13720318> - StackOverflowError In BindVariableExtractor
<Patch 13727704> - HashMap Race Condition Causes Infinite Loop in the Bean Update JMS Topic
<Patch 13945109> - Deadlock With Mediator Diag Release Action

Release 6.2

Oracle Transportation Management Version 6.2 Is Now Available - MOS <Note 1265208.1>

Release 6.2.10

Oracle Transportation Management and Global Trade Management 6.2.10 Are Now Available <Note 1677049.1>
This patch includes the following critical fixes
<Patch 10421699> - Agent Loader Chocked on Error in a Single Action
<Patch 10329036> - Errors Migrating to 6.2 When Running dbpatch_60 on a 6.1 Instance
<Patch 12701575> - OBJECTLOCK.TRYLOCK NullPointerException Causing Orphanded Object Locks
<Patch 12999578> - Exclude Primary Key Update From PN Triggers
<Patch 13915818> - Correct Conflict Between Keep Alive Ping and Data Queue Cleanup
<Patch 13727571> - Prevent Deletion of a User Having Recurring Processes Associated
<Patch 13727573> - StackOverflowError In BindVariableExtractor
<Patch 13738623> - HashMap Race Condition Causes Infinite Loop in the Bean Update JMS Topic
<Patch 13976265> - Deadlock With Mediator Diag Release Action
<Patch 14162498> - Export Saved Query Results Error: allocLargeObjectOrArray
<Patch 14270630> - Default Property For GtmTransactionLineQuery
<Patch 14660020> - Some Changes in 13717967 are Causing UI Performance Problems
<Patch 15991899> - Load Default User Role on Login
<Patch 16312158> - Dash Causing Application Server to Crash During Bulk Plan
<Patch 16298853> - Shipment Stops Counter Results in "ORA-01438: ERROR" When Over 500 Ship Units
<Patch 16661836> - Performance Issue on Search Screens
<Patch 16670012> - Intermittent Write_Record_Failure in OrderMovementRecalcHelper
<Patch 10184849> - EventHandler.getAllListeners Synchronization Causing Thread Contention
<Patch 17736504> - GTM License Service Request Causing a Memory Leak - Java.lang.OutOfMemoryError
<Patch 18268063> - Direct SQL Update Cache Refresh Cursor Leak
<Patch 18541236> - EJB Bean Locks Related to the BM Reference Number Qualifier
<Patch 18352273> - Performance Improvement for Purge Process
<Patch 17307924> - glog.util.persistence.PersistenceException: No_Record_Found for glog.ejb.execution.db.ShipmentRemarkPK

Release 6.3.0

Oracle Transportation Management and Global Trade Management Version 6.3 Are Now Available <Note 1506479.1>
<Patch 17943658> - GTM License Service Request Causing a Memory Leak - Java.lang.OutOfMemoryError
<Patch 15892739> - List of Responsible Parties Empty on New Tracking Event
<Patch 16433035> - OTM Database Schema Installation Fails on RAC

Release 6.3.1

Oracle Transportation Management and Global Trade Management 6.3.1 Are Now Available <Note 1533374.1>
<Patch 17943662> - GTM License Service Request Causing a Memory Leak - Java.lang.OutOfMemoryError
<Patch 17980144> - Adjust GLUserInfoImpl Serialization to Ensure Synchronization of WebLogic Data
<Patch 18015391> - Deadlock Between PublishWait Timeout and Normal Process Completion
<Patch 16828099> - Performance Issue on Search Screens - A one off patch is available for this fix that can be applied on 6.3.1
<Patch 17767570> - EventHandler.getAllListeners Synchronization Causing Thread Contention
<Patch 18056319> - NPE In App to App Serialization GLUserInfoImpl
<Patch 18236733> - Direct SQL Update Cache Refresh Cursor Leak
<Patch 18449257> - Fix the tOrderMovementCache for Possible Memory Leak
<Patch 18443427> - java.lang.NullPointerException in PersistenceHelper.getPkInstance
<Patch 19153025> - Test on Reserve Bottleneck Under High Load
<Patch 19016959> - Problem Overridding Single Value Multi-Key Properties
<Patch 19920414> - ORA-04025: maximum allowed library object lock allocated
<Patch 21983140> - Performance Improvement for Purge Process
<Patch 22198943> - glog.util.persistence.PersistenceException: No_Record_Found for glog.ejb.execution.db.ShipmentRemarkPK
<Patch 17514586> - Intermittent Write_Record_Failure In OrderMOvementRecalc

Release 6.3.2

Oracle Transportation Management and Global Trade Management 6.3.2 Are Now Available <Note 1568072.1>
<Patch 17943663> - GTM License Service Request Causing a Memory Leak - Java.lang.OutOfMemoryError
<Patch 17985986> - Adjust GLUserInfoImpl Serialization to Ensure Synchronization of WebLogic Data
<Patch 17767571> - EventHandler.getAllListeners Synchronization Causing Thread Contention
<Patch 18023973> - Deadlock Between PublishWait Timeout and Normal Process Completion
<Patch 18062801> - NPE In App to App Serialization GLUserInfoImpl
<Patch 18234480> - Direct SQL Update Cache Refresh Cursor Leak
<Patch 18449893> - Fix the tOrderMovementCache for Possible Memory Leak - Note: This also requires <Patch 18046084> be installed before installing this patch.
<Patch 18520216> - java.lang.NullPointerException in PersistenceHelper.getPkInstance - Note: This also requires <Patch 18234480> be installed before installing this patch.
<Patch 18771863> - Parent Invoice Object Lock Not Released During Invoice Match
<Patch 18397870> - Test on Reserve Bottleneck Under High Load
<Patch 17236021> - Excessive Memory Use in Large Bulkplans Due to Process Infrastructure
<Patch 17715252> - FTI Dashboard ODBC Driver Error Returned - Note: This also requires <Patch 17661769> be installed before installing this patch.
<Patch 18472094> - GTM Fails to Receive Huge XMLS from Oracle EBIZ
<Patch 18316354> - Shadow Bug for 18291577
<Patch 19028626> - Infinite Loop in TSShipUnit.getSplitCounts Causing Bulk Plan to not Complete
<Patch 20555987> - Stuck Threads Consuming 100% of CPU
<Patch 19442173> - APP Server No Response and Timed Out is Occurred
<Patch 21272490> - Performance Improvement for Purge Process
<Patch 19973376> - glog.util.persistence.PersistenceException: No_Record_Found for glog.ejb.execution.db.ShipmentRemarkPK
<Patch 21247157> - Deadlock in RPLS

Release 6.3.3

Oracle Transportation Management and Global Trade Management 6.3.3 Are Now Available <Note 1596782.1>
<Patch 18237907> - Direct SQL Update Cache Refresh Cursor Leak
<Patch 18196990> - Fix the tOrderMovementCache for Possible Memory Leak
<Patch 18520218> - java.lang.NullPointerException in PersistenceHelper.getPkInstance - Note: This also requires <Patch 18237907> be installed before installing this patch.
<Patch 18772229> - Parent Invoice Object Lock Not Released During Invoice Match
<Patch 17980471> - Enhanced Configuration of App-To-App Keep Alives
<Patch 19637687> - SimplePoller Not Closing Statement For Queue of Event
<Patch 18895645> - GTM Fails to Receive Huge XMLS from Oracle EBIZ
<Patch 19072206> - Infinite Loop in TSShipUnit.getSplitCounts Causing Bulk Plan to not Complete
<Patch 18316355> - Shadow Bug for 18291577
<Patch 19476231> - APP Server No Response and Timed Out is Occurred
<Patch 21129568> - Unsynchronized Hashmap Access Endless Loop
<Patch 21642941> - Connection leak error (java.lang.Throwable: Connection leak found: created statck)
<Patch 21288809> - Deadlock in RPLS
<Patch 24482600> - Exception java.lang.Throwable: Connection leak found: created statck - Note: The following patch needs to be installed <Patch 24598114> - Null Pointer Caused by Recent Connection Leak Patch after installing 24482600
<Patch 26534380> - ORA-04025 When Sending Invoice Into OTM via Integration

Release 6.3.4

Oracle Transportation Management and Global Trade Management 6.3.4 Are Now Available <Note 1632910.1>
<Patch 18772230> - Parent Invoice Object Lock Not Released During Invoice Match
<Patch 19913257> - GTM Memory Issue Due to Wide Open GtmClassCodeAttribute Query
<Patch 19983051> - LOCAL_JTS Connection Reuse
<Patch 19957822> - Connection Pool Ping Deadlock
<Patch 18865069> - Large Orders With Multiple Lines Does Not Reach OTM and Errors
<Patch 18895648> - GTM Fails to Receive Huge XMLS from Oracle EBIZ Note: EBS <Patch 19941134> is also required
<Patch 19072207> - Infinite Loop in TSShipUnit.getSplitCounts Causing Bulk Plan to not Complete
<Patch 20372615> - java.lang.Throwable: Connection leak found Note: This patch also requires the following patches also be installed: 19152774, 19306133, 19812654, 20003074 and 20372615
<Patch 19476232> - APP Server No Response and Timed Out is Occurred
<Patch 20122001> - Ensure All Staged Data Sources Remain Property Driven
<Patch 22457504> - Connection leak error (java.lang.Throwable: Connection leak found: created statck)
<Patch 21288811>- Deadlock in RPLS

Release 6.3.5

Oracle Transportation Management and Global Trade Management 6.3.5 Are Now Available <Note 1677781.1>
<Patch 19976182> - Connection Pool Ping Deadlock
<Patch 19988700> - LOCAL_JTS Connection Reuse
<Patch 19920020> - GTM Memory Issue Due to Wide Open GtmClassCodeAttribute Query
<Patch 19476234> - APP Server No Response and Timed Out is Occurred
<Patch 20123501> - Ensure All Staged Data Sources Remain Property Driven
<Patch 22457505> - Connection leak error (java.lang.Throwable: Connection leak found: created statck)
<Patch 22236351> - ORA-28113 or ORA-28115 may occur in Oracle Transportation
<Patch 21288813> - Deadlock in RPLS

Release 6.3.6

Oracle Transportation Management and Global Trade Management 6.3.6 Are Now Available <Note 1936222.1>
<Patch 22071391> - Line ID Data Prepared for Transaction Parent Line ID Field
<Patch 22072019> - The "Where" Clause Should Use SqlUtils.buildInClause to Avoid
<Patch 22120223> - ORA-28113 and ORA-28115 in Oracle Transportation Management
<Patch 22457506> - Connection leak error (java.lang.Throwable: Connection leak found: created statck)
<Patch 21288815> - Deadlock in RPLS
<Patch 24832246> - Add Shipment Tracking Event Uses the Domain Parameter Rather than Shipment

Release 6.3.7

Oracle Transportation Management and Global Trade Management 6.3.7 Are Now Available <Note 1963606.1>
<Patch 22081146> - Line ID Data Prepared for Transaction Parent Line ID Field
<Patch 22457507> - Connection leak error (java.lang.Throwable: Connection leak found: created statck)
<Patch 23261969> - ORA-04025 When Sending Invoice Into OTM via Integration
<Patch 21288817> - Deadlock in RPLS
<Patch 22127336> - ORA-28113: policy predicate has error and ORA-28115: policy with check option violation Generated In Oracle Transportation Management
<Patch 22997809> - Add Shipment Tracking Event Uses the Domain Parameter Rather than Shipment
<Patch 26316363> - ActualShipment Transmission Fails with RC Transaction Code on Object
<Patch 27311217> - Automatically Creating New Restricted Party Data Version
<Patch 29778220> - Decouple RatewareXL CarrierConnect combined call using CarrierConnect3.0 (SOAP) and RatewareXL - Review <Note > Carrier Connect XL 1.0 is coming to End of Life in 2019

Release 6.4.1

Oracle Transportation Management and Global Trade Management Release 6.4.1 Are Now Available <Note 2044367.1>
<Patch 24565232> - ORA-00933: SQL Command Not Property Ended - Broken by 18268271
<Patch 22549523> - Line ID Data Prepared for Transaction Parent Line ID Field
<Patch 22314865> - Prevent Rapid Clicking of FinderResults
<Patch 22549456> - Connection leak error (java.lang.Throwable: Connection leak found: created statck)
<Patch 22577160> - Error when Editing Ship Group with Upgraded Manager Layout
<Patch 22933125> - IE_SHIPMENTSTATUS and SHIPMENT_TRACKING_EVENT Manager Layout Issues
<Patch 22933132> - Manager Layout Query on Droplists when Copying/Editing a Manager Layout
<Patch 23092582> - Internal Server Error Creating User After First Login
<Patch 23262067> - ORA-04025: maximum allowed library object lock Generated when Sending Invoices Into OTM Via Integration
<Patch 23070228> - Add Shipment Tracking Event Uses the Domain Parameter Rather than Shipment
<Patch 24844195> - In a Non-Sca Environment, Currency Exchange Update Creates a Loss of Web Threads
<Patch 24682291> - Possible Cursor Leak Issue
<Patch 25248366> - Update the AD_HOC_PARTY_SCREENING_SERV_PREF Seeded with GTM
<Patch 26307866> - ActualShipment Transmission Fails with RC Transaction Code on Object
<Patch 26500975> - Create Transaction Line RefNums Insertion Poor Performance - Requires the following patches also be installed. 24749350 - Poor Performance for Create Trade Transaction with Many Lines and 25254626 - Create Transaction Line RefNums Insertion Poor Performance
<Patch 26558549> - Connection Leak in GTM
<Patch 26599198> - Queries Need to be Optimized
<Patch 27350615> - Automatically Creating New Restricted Party Data Version
<Patch 25518750> - Undefined Error Uploading XML File to Document
<Patch 26150231> - Automation Agent on Create Item Returns java.lang.NullPointerException
<Patch 28664412> - Preload GTM Transaction and GTM Shipment Query Classes to Prevent Dead Lock
<Patch 30184123> - Decouple RatewareXL CarrierConnect combined call using CarrierConnect3.0 (SOAP) and RatewareXL - Review <Note > Carrier Connect XL 1.0 is coming to End of Life in 2019

Release 6.4.2

Oracle Transportation Management and Global Trade Management Release 6.4.2 Are Now Available <Note 2089777.1>
<Patch 24905520> - In a Non-SCA Environment, Currency Exchange Update Creates Loss of Web Threads
<Patch 25360362> - Lite SCA Base Configuration is not Listening to the Refactored Realm Messages
<Patch 26174861> - Long Recursion Causing the App Server Crash
<Patch 25752096> - OTM 6.4.2 Requires OutXML Profile Attached Explicitly to the External System
<Patch 26316636> - ActualShipment Transmission Fails with RC Transaction Code on Object
<Patch 25860377> - OutXML Profile not Excluding Data
<Patch 26094111> - TenderOffer XML has Additional Fields no in the XML Template - Note: Requires the following patches also be installed. <Patch 25870193> - Outbound Tender, Withdraw Tender have Transaction Code of NP <Patch 25860377> - OutXML Profile not Excluding Data
<Patch 27193558> - BulkPlan Long Running Query Against Accessorial Cost - Note: The following fix should be applied after 27193558 has been installed - <Patch 27349048> - Accessorials Being Applied and Charged Incorrectly
<Patch 26599200> - Queries Need to be Optimized
<Patch 27901091> - Performance of RPLS is Slow is Performed Delat Screening on Contacts
<Patch 25520110> - Undefined Error Uploading XML File to Document
<Patch 26150232> - Automation Agent on Create Item Returns java.lang.NullPointerException
<Patch 27350616> - Automatically Creating New Restricted Party Data Version
<Patch 27922541> - Diagnostics.logEnd API Does Not Actually Ever Close the Log File
<Patch 28506563> - Queue Thread Property Value Not Honored After Restart
<Patch 28687718> - Preload GTM Transaction and GTM Shipment Query Classes to Prevent Dead Lock
<Patch 26599212> - Connection Leak in GTM
<Patch 29778224> - Decouple RatewareXL CarrierConnect combined call using CarrierConnect3.0 (SOAP) and RatewareXL - Review <Note > Carrier Connect XL 1.0 is coming to End of Life in 2019
<Patch 30217716> - Editing Connection Pool Changes Password Value in Database

Release 6.4.3

Oracle Transportation Management and Global Trade Management Release 6.4.3 Are Now Available <Note 2226920.1>
<Patch 27785876> - Translation of all OTM Supported Languages with 6.4.3
<Patch 27350617> - Automatically Creating New Restricted Party Data Version
<Patch 28101781> - Diagnostics.logEnd API Does Not Actually Ever Close the Log File
<Patch 28416216> - Preload GTM Transaction and GTM Shipment Query Classes to Prevent Dead Lock
<Patch 27933769> - Performance of RPLS is Slow if Performed Delta Screening on Contacts
<Patch 28698635> - java.sql.SQLException: ORA-04025: maximum allowed library object lock
<Patch 29133065> - Thread Count for Data Queue is Incorrect Based on Number of Threads Configured
<Patch 29134625> - Editing Connection Pool Changes Password Value in Database
<Patch 28271031> - Patch 26759498 is Causing Agents to Fail with 'java.lang.StackOverflowError' SCA
<Patch 29849763> - 'Accept Tender' Fails with 'ORA-04025: maximum allowed library object lock allocated
<Patch 29778225> - Decouple RatewareXL CarrierConnect combined call using CarrierConnect3.0 (SOAP) and RatewareXL - Review <Note > Carrier Connect XL 1.0 is coming to End of Life in 2019
<Patch 27396928> - Accessorials being Applied and Charged Incorrectly
<Patch 29278788> - java.sql.SQLException: ORA-04025 Generated When Using Any Action That Creates/Modify Documents
<Patch 30965259> - Add Tracking Event Throws an Error ORA-04025
<Patch 30283175> - Connection Pool LOCAL_JTS is Exhausted
<Patch 31043425> - SqlSessionBean Select Doesn't Close The SqlQuery Object
<Patch 27275333> - Default Wait Time Needs to be Added to LOCAL_JTS
<Patch 30377641> - Cursor Leak in glog.server.workflow.notify.XMLTransmissionHelper.RetrieveServprovAlias
<Patch 28754471> - Extreme Slowness, High CPU Usage on APPTIER
<Patch 28719019> - java.util.ConcurrentModificationException When Running Multiple Bulkplans in Multi-Threading Environment
<Patch 27816870> - Depreciate VIEW_SHIPMENT_RELEASE_LOC
Be sure and review <Note 2006049.1> regarding properties that can be added to help troubleshoot open cursor errors

Database Upgrades: Clients Upgrading their OTM instance to 11.2.0.4 should review the instructions in the following MOS note to enable the additional grants required for this release.

<Note 1945137.1> - ORA-29532 - "the Permission (java.lang.RuntimePermission accessClassInPackage.sun.misc) has not been granted to GLOGOWNER" Error Being Generated After Upgrading the Database to 11.2.0.4

12c Database

If you encounter problems creating materialized view or if PL/SQL exhibit issues with VPD or data visibility, please install the following database patches.

Bug 20290182 - ORA-12033: Cannot Use Filter Columns From Materialized View Log - Note: This issue would likely be reported when upgrading an FTI instance.
Bug 19013183 - Wrong Results with Context Sensitive VPD Policy in PL/SQL Block

19c Database - Only Supported on 6.4.3

The following error has been reported when trying to log into OTM 6.4.3 after moving to the latest Roll Up Patch available for the 19C database.

java.sql.SQLException: ORA-42804: The operation can disclose rows protected by VPD policy

Review the following note for information on how to resolve this error.

<Note 2695259.1> "ORA-42804: The operation can disclose rows protected by VPD policy" Error Generated Logging Into OTM 6.4.3 After Moving the Database to 19C