GC3 5.0 Service Release: January 2006 (SR-#8: 01.06)

Installation Instructions | Database Changes | Integration Changes | Corrections | Enhancements | Updated Files | Next Service Release | Customer Support

This page describes the content of this Service Release and contains the following sections:

Service Release-Specific Installation Instructions

There are no service release-specific installation instructions for this release. Refer to the standard service release installation instructions.

Database Changes

New Tables

Table

Column

DataType

Nullable

OB_LEG_CONSTRAINT

ob_order_base_gid

VARCHAR2(101)

NOT NULL

 

leg_classification_gid

VARCHAR2(101)

NOT NULL

 

buy_rate_offering_gid

VARCHAR2(101)

 

 

sell_rate_offering_gid

VARCHAR2(101)

 

 

buy_rate_geo_gid

VARCHAR2(101)

 

 

sell_rate_geo_gid

VARCHAR2(101)

 

 

equipment_group_gid

VARCHAR2(101)

 

 

equipment_group_profile_gid

VARCHAR2(101)

 

 

transport_mode_gid

VARCHAR2(101)

 

 

servprov_gid

VARCHAR2(101)

 

 

servprov_profile_gid

VARCHAR2(101)

 

 

rate_service_profile_gid

VARCHAR2(101)

 

 

mode_profile_gid

VARCHAR2(101)

 

 

domain_name

VARCHAR2(50)

NOT NULL

 

insert_user

VARCHAR2(128)

NOT NULL

 

insert_date

DATE

NOT NULL

 

update_user

VARCHAR2(128)

 

 

update_date

DATE

 

 

 

 

 

OB_SHIP_UNIT_LOAD_CONFIG

ob_ship_unit_gid

VARCHAR2(101)

NOT NULL

 

leg_classification_gid

VARCHAR2(101)

NOT NULL

 

load_config_profile_gid

VARCHAR2(101)

 

 

domain_name

VARCHAR2(50)

NOT NULL

 

insert_user

VARCHAR2(128)

NOT NULL

 

insert_date

DATE

NOT NULL

 

update_user

VARCHAR2(128)

 

 

update_date

DATE

 

 

New Columns

Table

Column

DataType

Default

Nullable

OB_LINE

BUFFER_LOCATION_GID

VARCHAR2(101)

 

 

 

 

 

 

 

OB_ORDER_BASE

DEFAULT_STOWAGE_MODE_GID

VARCHAR2(101)

 

 

 

STUFF_LOCATION_GID

VARCHAR2(101)

 

 

 

DESTUFF_LOCATION_GID

VARCHAR2(101)

 

 

 

CUSTOMER_UNITIZATION_REQUEST

VARCHAR2(1)

DEFAULT 'N'

NOT NULL

 

UNITIZATION_CONDITION_NAME

VARCHAR2(50)

 

 

 

 

 

 

 

OB_RELEASE_INSTRUCTION

FLAGGED_FOR_DELETE

VARCHAR2(1)

DEFAULT 'N'

NOT NULL

 

OB_RELEASE_INSTR_GID

VARCHAR2(101)

 

 

 

OB_RELEASE_INSTR_XID

VARCHAR2(50)

NULL

NOT NULL

 

 

 

 

 

OB_SHIP_UNIT

BUFFER_LOCATION_GID

VARCHAR2(101)

 

 

 

 

 

 

 

OB_SU_RELEASE_INSTRUCTION

FLAGGED_FOR_DELETE

VARCHAR2(1)

DEFAULT 'N'

NOT NULL

 

OB_SU_RELEASE_INSTR_GID

VARCHAR2(101)

NULL

NOT NULL

 

OB_SU_RELEASE_INSTR_XID

VARCHAR2(50)

NULL

NOT NULL

 

 

 

 

 

OMR

OB_ORDER_BASE_GID

VARCHAR2(101)

 

 

 

PROCESS_TYPE

VARCHAR2(50)

DEFAULT 'ORDER_RELEASE'

NOT NULL

 

ORIGINAL_OMR_GID

VARCHAR2(101)

 

 

 

 

 

 

 

OMR_D

OB_LINE_GID

VARCHAR2(101)

 

 

 

OB_SHIP_UNIT_GID

VARCHAR2(101)

 

 

 

 

 

 

 

ORDER_RELEASE

BUFFER_TYPE

VARCHAR2(50)

 

 

 

 

 

 

 

RELEASE_METHOD

SINGLE_RELEASE_PER_INSTRUCTION

VARCHAR2(1)

DEFAULT 'N'

NOT NULL

 

PLAN_FROM_PLAN_TO_TYPE

VARCHAR2(50)

DEFAULT 'OVERRIDE SOURCE/DEST'

NOT NULL

 

IS_BUFFERING_SUPPORTED

VARCHAR2(1)

DEFAULT 'N'

NOT NULL

 

PERFORM_SERVICE_TIME_LOOKUP

VARCHAR2(1)

DEFAULT 'N'

NOT NULL

 

RATE_SERVICE_GID

VARCHAR2(101)

 

 

 

 

 

 

 

SHIP_UNIT

OB_SU_RELEASE_INSTR_SEQ

NUMBER(10)

 

 

 

 

 

 

 

SHIP_UNIT_LINE

OB_LINE_RELEASE_INSTR_SEQ

NUMBER(10)

 

 

 

 

 

 

 

DOCUMENT_DEF

SUPPORTS_PREVIEW

VARCHAR2(1)

DEFAULT 'Y'

NOT NULL

 

Modified Columns

Table

Column

Nullable

OMR

ORDER_RELEASE_GID

NULL

 

Integration Changes

Changes to the integration processing logic can be found below in their respected correction or enhancement description. Changes to the XML schema are as follows:

Corrections

G-Log Issue

Support Ticket

Issue Summary

Issue Resolution

39576.5.0

 

There is no help associated with the Integration manager upload and result page.

Help links now call the correct help topic.

50982.5.0

 

BM refnum on Online Booking + Tendering finder screen is incorrect for Timed Out Tenders

Add shipment refnum display to reflect the most updated refnum values.

53836.5.0

 

Add "Add Prebids" action to project action menu.

"Add Prebids" action has been added to the Project UI.

54380.5.0

1-11150

After selecting a buy shipment, if I do "related orders" from the Smartlinks, the screen that is displayed is the Order Release screen but the name of the screen is 'Freight Forwarding'.

Default Order Release UI has been changed back to ORDER_RELEASE.

54823.5.0

 

Need to select shipment start times such that the total wait time is minimized in Location Optimization for alternate optimal solutions

Added code that adds a small penalty for wait time of the shipment if that particular start time is chosen. That way if there are two solutions that have same target penalties, the optimizer would choose the one with smaller wait time.

55621.5.0

ISS00019053

What actions are allowed to be used for static/dynamic trips

If the actions are not allowed, a message now comes up when the user tries to use an action that is not available. Changed the specified shipment actions to show a message if the schedule type of the shipment is DYNAMIC TRIP/STATIC TRIP to indicate to the user that the actions are not allowed.

55724.5.0

 

Lane Summary Stat Edit Doesn't Work

We were trying to call the class directly, but actions must be called from the queryresponseservlet.

55726.5.0

ISS00019176

Planning parameter set item: PROVINCIAL VAT CONFIGURATION ID - cannot edit-save

Planning Parameter Sets which use planning parameters of type 'G' (which uses a picklist) will now work correctly.

55880.5.0

 

Improve "invitation" email to carrier

Bugs #53837.5.0 and #55880.5.0 were both checked in together since they were similar. Here is what was changed:
1. Added Contract Begin and End Dates (taken from the Project)
2. Added Open Date for the Bid Round
3. Changed all dates to be in the timezone of the Service Provider
4. Added a label "label.InvitationToBidEmailTitle" which can be used to change the Subject of the bid email. To change by default you can use the Domain/Variant field in the Label Manager.

55954.5.0

 

Log viewer skips the first line in the log file

Fixed JVM differences to properly account for the beginning of the log file.

55958.5.0

 

Copy Service provider from 1 domain to another. Should only write to target domain and not write back to source domain.

The required contact information is now being copied over correctly.

56022.5.0

 

FTP transmission process page does not call help

Added the link to call help.

56041.5.0

 

Schedule instance shipment does not have the orders on stop

The problem is caused by the error in constructShipmentGraph where shipmentNode's status was not set as modified for schedule instance shipment when the shipment is not on the first leg. This caused the schedule instance not being updated with the new order planned on and the new bulk plan id. It is fixed now.

56261.5.0

 

Re-sequence of stops fails when depot stops are involved.

Change UI to show non-DEPOT stops only.

56304.5.0

 

On Ready to Ship screen, click on the box that calculates volume. Receive HTTP 404 error.

Fixed the calculate volume box.

56340.5.0

ISS00019547

multistopFallBackDirectShipments doesn't use correct itinerary constraint

Itinerary constraints should apply to the multistopFallBackDirectShipments.

56361.5.0

 

CSV Export has no help links

Added support of the help link for the CSV Export page

56520.5.0

 

Second order added to ground schedule causes bad shipment.

The problem was caused by not passing the object OrderPlanner that contains shipment cache to RateServiceSession causing on order not being accounted for on the shared schedule instance.

56565.5.0

 

Change the help link for the Cyclical Calendar servlet.

Help link is corrected .

56601.5.0

 

Action Utility page needs context-sensitive help topic to be attached.

Help link has been added for the Action Utility UI.

56602.5.0

ISS00019644

Integration Logic throws error when an invoice that has been deleted is uploaded again

Dependent records are removed via bean deletions rather than direct SQL delete statements. This allows the bean caches to be cleared up correctly.

56661.5.0

ISS00019647

Order will not schedule on a shipment when check location capacity is on. Receive error - java.lang.NullPointerException

Added a check for null for the maximum capacity field when capacity type is shipment.

56684.5.0

 

Equipment group profile on commodity is not adhered to.

The current logic only looks at the constraints on the order itself. This has been changed so that the constraints on the order and on the commodities related to the order are all considered.

56701.5.0

ISS00019500

Auto Assign rule for assigning Job Involved Party is not working when job created via Book With Internal NVOCC (Non-Vessel Operating Common Carrier).

Fixed a problem where jobs created through business logic instead of via the UI or integration did not have auto assign rules run on them.

56702.5.0

ISS00019700

User favorite - cannot use the 'f' finder on favorite ID when certain tables are selected.

Added new variable "action" and used in generating URL for 'page' variable. Redir and page variables are updated with finder_set_gid as additional parameter. While adding new favorites, FINDER_SET not found error was coming for most of the tables. Query_name is changed for CALENDAR_PARENT and LANE_ATTRIBUTE_DEF as the package name was wrong.

56724.5.0

 

Refresh Schedule from Batch Balancer Grid gets Unknown Action Error.

Fixed the "Refresh Schedule" URL problem.

56730.5.0

 

Custom UI Action Menu for Job

The "action" buttons on the Job Details screen will now use the user's default finder set actions.

56743.5.0

ISS00019640

Subsequent shipments not being re-driven when upstream shipments are merged

Downstream shipment times will now be correctly recalculated when 2 shipments are merged"

56760.5.0

 

According to bug #40785.4.5, this is a known issue and previous partial fix only solves when there are 1000+ orders, but not other primary keys such as shipment.

There is now no problem unassigning orders when there are more than 1000 related shipments.

56801.5.0

 

Bulkplan puts orders over capacity on static schedule shipment

The over capacity problem was caused by conducting capacity check on two different schedule instance objects for the same schedule instance shipment in the database. This is corrected and now only one object is checked.

56802.5.0

ISS00019753

javanull error when trying to delete a field from a custom manager layout screen.

The location names specified were not the top level element in the column - they were enclosed within an if statement. Changed the manager to be able to look for elements within multiple levels of a column.

56851.5.0

ISS00019822

Various Null pointer exceptions when creating Manager Layouts.

Added a label to the dropdown list and made the field required.

56854.5.0

 

When viewing shipment through OR tree, some ITL action labels are not translated, and action "View AES transmission" is missing. However, they are fine if you perform actions either via shipment manager or shipment view through shipment manager.

"View AES transmission" is now available in actions. Also, all translations were translated.

56889.5.0

 

BOL Back refers to incorrect tab when specifying which tab is next.

Label has been fixed.

56890.5.0

ISS00019851

International Rate Inquiry - Location type filter not being honored

International Rate Inquiry will now take Location Type into account even if you are querying on Location Name.

56900.5.0

 

Number Format exception is thrown when trying to enter reference numbers on End to end order

The user can no longer choose "PO" on the Reference Number dropdown. That can now only be set through the Purchase Order field. This makes sense because is not the user could enter more than one "PO" record and we would not know which value to put in the Purchase Order field.

56901.5.0

ISS00019847

When selecting the action Create Buy Shipment > Show Routing Options > Show Options, if the select itinerary is not feasible and the user clicks on 'show options', no error is logged or log file provided as it happened in version 4.5

Errors and View Log button have been added back to the Show Routing Options result screen

56903.5.0

 

Javascript error entering SKU event with time

Java script was looking at the wrong element. Issue has been resolved.

56909.5.0

 

Editing certain agent actions with data type association can be difficult.

Wrong XML element was being used to look up the data query type on the edit parameters screen. This has been corrected.

56944.5.0

 

When Auto Approve Adjusted costs is executed, the Was Auto Approved flag is not set

Fixed a bug where the invoice action Auto Approve Adjusted Costs was not setting the Was Auto Approved flag on the new voucher.

56946.5.0

 

Script error in the List Type field when creating a new workspace list.

The java script errors have been resolved. The values in drop down for 'Order By' and 'Field Name' change as per the change in value selected in List Type.

56947.5.0

 

Invoice Adjusted Costs Cannot Be Run On Multiple Shipments At One Time.

Added a validation to the Invoice/Bill Adjusted Costs shipment actions to only allow selecting one shipment at a time. Previously, multiple could be selected, but only one of them actually processed.

56960.5.0

ISS00019900

When an OM is scheduled onto a dynamic trip, the source location on the OM is changed to match the first stop on the dynamic trip.

Source location/Destination location of order movement should not be over-ridden by shipment stop locations.

56964.5.0

ISS00019786

The BOL invoice UI is displaying the wrong shipment equipment number.

Shipment Equipment Number, Equipment Group, and Equipment Type should now display correctly on the equipment grid.

57002.5.0

 

Shipment Send Financial Feed XML - Please change Tariff logic to OR and not AND to include tariff on XML when all 5 fields are not populated

Fixed the logic error that tariff info is excluded from the XML.

57120.5.0

ISS00020013

Shipment Group is created even though the shipment group rule contains an itinerary profile that does not contain the Sell shipment itineraries

Modified the code to check the compatibility correctly and subsequently group the shipments only if the itinerary used to build the shipment and the itinerary profile on the shipment group rule coincide.
1. With Itinerary Profile BUY having one itinerary - BAT_PJ_MILSWH:
No shipment group formed

2. With Itinerary Profile BUY having two itineraries - BAT_PJ_MILSWH and
BAT_PJ_MILSWH_SELL:
Shipment group is formed since BAT_PJ_MILSWH_SELL is the one used in building
shipments

57140.5.0

ISS00020029

Relax UI to allow invalid voyage_gid in Shipment Manager

Changed UI not to validate the Voyage ID.

57283.5.0

 

Null pointer adding a Ship Unit Line with remark to an Order Release

Can now add Remarks and Refnums to Ship Units created from an existing Line.

57288.5.0

 

Delete Related Bills action is failing with: Could not retrieve INVOICE(s)

Fixed a bug that occurred when deleting invoices or bills via an agent. The invoice or bill would delete successfully, however, an "Invoice record not found...Could not retrieve INVOICE(s)" error would be generated which would cause agents running this action to fail.

57323.5.0

ISS00020153

Order cannot be moved to a charter voyage (that has other orders) because of incorrect leg classification constraint violations.

Modified the logic so that only the equipment constraint for the leg classification of the specified OM leg will be applied.

57340.5.0

ISS00020172

Null pointer exception when performing ITL actions on a Custom screen set copied from Freight Forwarder screen set.

The problem had to do with user-defined screensets. The actions (this also includes View Denied Parties) were built to only handle the default screensets. Modified the code to handle user-defined screensets.

57362.5.0

ISS00019999

Errors when choosing list or new buttons for service provider profile ID on the Constraints tab for a manager layout.

Service Provider Profile field on the Constraints tab should now work correctly.

57366.5.0

ISS00020224

Other Attributes Buy Side General Ledger Code List and New Links java.java.lang.ClassNotFoundException: glog.webserver.finder.models.GLCodeBuyFinderModel

Buy and Sell Side General Ledger Code fields on the Other Attributes, Line,
and Ship Unit tabs should now work correctly.

57367.5.0

ISS00020230

Several errors received when using Freight Forwarder manager layout and clicking Create Override

The "Create Override" button now works correctly.

57375.5.0

ISS00020216

Booking an order onto a voyage fails because we look at the allocated capacity rather than the max capacity.

When consol is not in COMMITTED status, free capacity is based off max capacity, not allocated capacity. i.e., free capacity = max capacity - booked capacity

57381.5.0

 

Change the help link for the BOL Back Line Item servlet.

Help link has been fixed.

57382.5.0

 

When the Logistics Guide is run, the system could fail to find exchange rates if needed.

If the currency exchange rate is not found, an attempt will be made to locate the reciprocal rate and use it.

57383.5.0

 

Damage Notify Point calls the wrong help topic.

Help topic should now be correct.

57384.5.0

 

Data Source Manager does not call help (2 pages)-error rec'd

Help links should now be correct.

57385.5.0

 

Data Source Profile calls the wrong help topic.

Help link should now be working.

57387.5.0

ISS00020226

Error on Freight Forwarding manager layout clicking List button on Additional Services Inspection Company and selecting any data.

Updated the master freight_forwarding.xml manager layout file. The layout will need to be recreated.

57401.5.0

 

NamingDirectory leak in UI's Login servlet

The NamingDirectory object obtained using the getND() call was not being assigned to a reference and as a result not being released. This was causing the leak. Code has been fixed to address the leak.

57420.5.0

 

Shipment group status fax not sent due to XSL error

1. Add translation data of subject line.
2. Change template name.

57440.5.0

ISS00020275

Clicking on Column Header in Finder Results - Refreshes the results and forgets the results from a Saved Query

The last run saved query is now retained when resorting.

57465.5.0

ISS00020292

Max Beans Reached error in OmShipmentJoin, AllocationOrLineDBean, and WorkflowSessionBean

Max Beans in Cache for OmrShipmentBean has been increased to 500.
Max Beans in Cache for AllocationOrLineDBean has been increased to 2000.
Max Beans in Cache for WorkflowSessionBean has been increased to 200.

57482.5.0

 

Exception in Consol Interface

Fixed the null pointer exception when upload a consol(flight-type) XML into GC3

57485.5.0

 

Exchange Rate Date set to null for estimated cost shipments

Fixed an issue where shipments with an estimated cost from the leg were being set to the current date instead of being left null.

57486.5.0

ISS00020328

POD_HI secondary charges are mistakenly being created for a VESSEL shipment which is LOAD Confirmed but not received confirmed. The secondary charge rule has parameters for Port of Discharge/Quantities Received and there are no such debriefs for that shipment.

If the quantity type is 'Picked Up' or 'Received' and there are no corresponding shipment stop debrief records the secondary charge shipment will not be created.

57489.5.0

 

Selecting multiple GIDs in Action and running a Report passes incorrect objects

Fixed the error when passing multiple objects to report server

57492.5.0

 

Online Booking + Tendering - Export button always returns: Your query has found 0 records. Do you wish to proceed ?

Modify TenderRespAdapter to support Export action.
Note standard Export action does not support check box selection from result page. To restrict the selection, user need to modify the query from finder page.

57493.5.0

 

FF Manager Layout has non working links on the notification tab.

Updated the freight_forwarding.xml manager layout template. The layout will need to be recreated to see the fix.

57495.5.0

ISS00020316

OMD change cause order Movements in the status PLANNING - PLANNED FINAL but they have NO RELATED SHIPMENTS.

Set order movement status to unscheduled after un-assign

57497.5.0

 

Max Beans in Cache Spinoff from 56847

Fixed a problem where a shipment allocation was performed with the ALLOCATION GENERATES ACCRUALS planning parameter turned off, and the shipment bean would get stuck in the bean cache. This could eventually lead to bean cache full exceptions for shipments. The work-around prior to this fix is to enable the ALLOCATION GENERATES ACCRUALS planning parameter.

57498.5.0

ISS00020340

Error with autocombinelanes utility

The corresponding stored procedure was not in the update script so the new version was not applied when the Oct SR was applied. This stored procedure is now in the update script.

57501.5.0

ISS00020334

Document beans are locking and not releasing.

Removed locking of document type information during transactional document actions.

57507.5.0

 

Remove System.out.println for TInvoice

Removed System.print from TInvoice

57511.5.0

 

Merge shipment with consolidate equipment unchecked throws irrelevant exception after merged successfully

Bundle shipments did not terminate after shipment successfully committed, causing irrelevant exception being thrown. This is fixed now.

57517.5.0

 

Build secondary charges not prompting for quantity type

Fixed an issue where Build Secondary Charges action did not prompt for quantity type.

57520.5.0

 

Performance problem unassigning order from voyages - unassign order/order movement.

Backend only loads the shipments that contains those order, not related shipments. This should speed up the un-assign process.

57521.5.0

 

Performance problem with OMD propagate/edit shipments

Loads shipments and/or order movements that are related to the given order release.

57522.5.0

 

Performance problem with split to consol piece

Modified to use SQL to find the time and the quantity information instead of loading shipment.

57523.5.0

 

Performance problem with SMD

Load the given shipment only to improve the performance

57529.5.0

 

Error while deleting report records

Deleting a Report will now delete the REPORT_EMAIL, REPORT_LOG, and
REPORT_LOG_PARAMETER table entries as well.

57536.5.0

ISS00020412

Stop times for a secondary charge shipment not being set to destination of original shipment when using Location Type: Dest

If the user selects location type 'Destination' on the secondary charge rule, the times of the new secondary charge will be set to the end time of the transportation shipment.

57538.5.0

 

Same stylesheet profile shown twice on contact transactional event.

Added properties to suppress VPD lite optimization for particular queries. The stylesheet profile query no longer uses the optimization.

57539.5.0

 

Increase Bean Counts for Execution Objects

Increased max beans in cache setting for several invoice, voucher, and claim related objects. This should fix "Max Beans in Cache" errors that can occur with larger settlement transactions.

57545.5.0

ISS00020404

Deleting a temporary OM results in the order release to go to a status of planning_unscheduled

Order release status should stay planned final after temporary order movement is deleted

57546.5.0

ISS00020397

Shipments will not build if itinerary has a Servprov Profile ID.

Fixed ClassCastException.

57550.5.0

 

Hide the AA menu until 5.5.1

The Analytics option will be available at a future date.

57555.5.0

ISS00020398

Need ability to disable DropListCache for saved queries

Add property to enable/disable caching of savedquerynamecache.
glog.webserver.savedquerynamecache - {true, false} - cache is on by default {true}

57557.5.0

 

Cannot insert NULL into mode running logistics guide

Build Logistics Guide now runs without any errors.

57561.5.0

ISS00020548

Error when trying to consolidate bills into one parent bill via the UI.

You can now create a consolidated bill from more than 100 bills.

57562.5.0

 

Cannot view/edit voucher with more than 1000 line items

Can now edit a voucher with more than 1000 invoices.

57580.5.0

 

Allocation Issue - differences of less than a penny cause allocation to fail.

Fixed an issue where an allocation resulting in a remainder to be distributed might sometimes fail with an error message in the log indicating "ERROR - allocation stopped to prevent endless loop."

57620.5.0

ISS00020568

Cannot Edit Service Provider and Cost from Buy Shipment if Equipment and Seal Numbers have been assigned to the Buy Shipment.

Fix TSEquipment's data loading issue.

57642.5.0

 

PDF Issues

Certain intermittent issues with opening PDFs, in Win2k, WinXP were reported from clients. We have added code so that the browsers identify the file as PDF and open it correctly on all platforms.

57643.5.0

ISS00020595

When sending planned shipments, vouchers etc to a external system, the namespace declaration is included <Transmission xmlns="http://glog.com">This is seen even when the XmlDeclaration default value of false in the glog.common.properties

The Dec 5.0 patch (via Issue 57068.5.0) added an XML namespace to the outbound Integration XML in support of the Oracle BPEL Integration. This appears to be a cause of issue for existing 5.0 clients. There is a new property added to control whether the XML namespace is added to the XML. The property is:
glog.integration.enableXmlNamespace=false
The default value for the property is set to false to minimize impact to existing clients.

57646.5.0

ISS00020593

No FTP interface transmission possible after patch

Added the 3rd party library finj.jar into the CLASSPATH.
Also changed the default ftp package property (glog.util.ftp.client.package)
back to finj.

57647.5.0

ISS00020603

On Freight Forwarding - Notifications Screen the Create Override removes unchanged information when you edit the Address Lines.

All override information should now be saved to the database.

57670.5.0

 

PackagedItemBean Lock blocks Many Threads

Fixed problems with bean locks on the packaged item.

57700.5.0

 

Increase BeanCount for Leg

Changed the Max Beans in Cache for Leg to be 1000.

57722.5.0

 

OrderBaseShipmentLinkSession bean needs to be modified so it is deployed as stateless

Change OrderBaseShipmentLinkSession from stateful to stateless to reduce memory usage.

57723.5.0

 

Endless loop for allocation

Fixed rounding problems that could cause an infinite loop in the allocation rounding adjustment routine that is more likely when currency precision is set > 2 (default=2). Also added a protection to quit the loop if no adjustment is made.

57741.5.0

 

Custom code that was still referencing applet_support could have failed.

Added back XSL template applet_support as a no op for custom XSL files that have not removed this template reference.

57742.5.0

 

Move to consol display needs to use max and not allocated

Modified to retrieve consols based on remaining max instead of allocated capacity, also return both remaining max and allocated capacity.

57743.5.0

 

Move to consol display - need to add display column

1. (Item A) In Consol Edit screen, make sure for those populated capacities
(Weight, Volume, TEU and FEU),
Allocated Capacity <= Maximum Capacity

Note: we will ignore the requirement of "Maximum and allocated capacity can not be set below the actual booked capacity" .

2. (Item C) In View Summary By Stowage Mode screen,
* No screen change. Only need to call new API
getFreeAllocatedCapacity() instead of getFreeCapacity().

3. (Item D) In move to consol screen,
* Remove 4 existing columns "Remaining Weight/Volume/TEU/FEU";
* Add 8 new columns "Remaining Maximum Weight/Volume/TEU/FEU"
and "Remaining Allocated Weight/Volume/TEU/FEU";
* The existing API getFreeCapacity() will return Remaining Maximum Capacity and new API getFreeAllocatedCapacity() will return Remaining Allocated Capacity.

57747.5.0

ISS00020797

When bulk planning 2 OMs, one is left in a status of planned-final without a shipment is the planning parameter for MAXIMUM VOLUME PER BUNDLE and MAXIMUM WEIGHT PER BUNDLE are both set to 0.

Multi-stop skipped equipment assignment process when leg's calculate rate is unchecked causing one order's ship units not added to the equipment therefore not relating one of the order movement with the shipment.

57748.5.0

ISS00020790

Edit Ship Unit Line error on a Screen set with custom manager layout

Can now delete Ship Unit Lines from the Freight Forwarding user interface.

57752.5.0

 

Issue with User Credential in HTTP Headers

The logic setting the request property was incorrect.  It has been fixed. It is now:

   data.setRequestProperty("UserName", userName);

57761.5.0

 

Buyer Template Does Not Copy Involved Party Override Address Lines

Involved party override addresses should now be copied when running the Apply Buyer Template action.

57771.5.0

ISS00020793

Auto Assignment rule for Order Release are not running based on the object domain

Added Domain as available criteria for auto assigning an order release involved party (and order release involved party variable contact).

57796.5.0

 

Business Monitors need to be in the user interface functional category when scaling by function.

Added application function BUSINESS MONITORS. By assigning this function to a particular Application Server (i.e. cluster), all business monitor queries can be directed to a particular scalability (SCA) cluster.

57827.5.0

 

Cannot delete ship unit using Freight Forwarder (FF) manager layout.

Updated the web.xml template file for the FFordShipUnitCustDelete servlet.
You can now delete ship units.

 

Enhancements

G-Log Issue

Support Ticket

Issue Summary

Issue Resolution

53801.5.0

 

Location Capacity Optimization - Phase 2 for UI actions

This fix adjusts wait time for the shipments based on location capacity availability along with location open/close times. Wait times for each shipment start time can also be changed according to Location capacity in bulk plan (where multiple start times are tried for location capacity feasibility) by turning the property - business.location.locationCapacityOptimizer.CalculateStopWaitUsingLCinBP=true.

53837.5.0

 

Relevant project level information should be on email sent to carriers

Issues #53837.5.0 and #55880.5.0 were both checked in together since they were similar. Here is what was changed:

1. Added Contract Begin and End Dates (taken from the Project)

2. Added Open Date for the Bid Round

3. Changed all dates to be in the timezone of the Service Provider

4. Added a label "label.InvitationToBidEmailTitle" which can be used to change

the Subject of the bid email. To change by default you can use the Domain/Variant field in the Label Manager.

54331.5.0

 

Voyage Order Shipment Data

By configuring the CHARTER VOYAGE ARRIVE DATE CHANGE THRESHOLD and CHARTER VOYAGE DEPART DATE CHANGE THRESHOLD planning parameters you can determine whether or not future or previous order movements are adjusted if you change arrival or departure dates on a charter voyage.

57380.5.0

 

Add three reports to Procurement

Three new reports are added to the Base Procurement.

Procurement Solution By Lane.

Procurement Solution Evaluation By Lane.

Procurement Solution Cost.

57408.5.0

 

Schedule Lines Enhancement

Facilitates the ability to better manage delivery lines, buffer orders, and OMR plot changes utilizing the order base and releasing capabilities.

 

Updated Files

glogserver.jar
glog\gc3webapp\WEB-INF\web.xml
glog\config\maps\ui\*
glog\oracle\insert_security_roles.sql
weblogic\config\gc3domain\applications\GC3App.ear
apache\htdocs\html\help\webhelp\en\*
apache\htdocs\js\detail\releasemethod.js
apache\htdocs\js\document\document.js
apache\htdocs\js\finder\find.js
apache\htdocs\js\omr\omr.js
apache\htdocs\js\roe\OrderEdit.js
apache\htdocs\js\workspace\workspace.js
apache\htdocs\xsl\agent\ActionParameters.xsl
apache\htdocs\xsl\batch\BatchGrid.xsl
apache\htdocs\xsl\calendar\ViewCalendar.xsl
apache\htdocs\xsl\carrier\ViewCommMethods.xsl
apache\htdocs\xsl\comm\Fields.xsl
apache\htdocs\xsl\detail\PlanningParameter.xsl
apache\htdocs\xsl\detail\PlanningParameterSet.xsl
apache\htdocs\xsl\detail\PlanningParameterSetView.xsl
apache\htdocs\xsl\detail\ReleaseMethod.xsl
apache\htdocs\xsl\detail\ReleaseMethodView.xsl
apache\htdocs\xsl\document\DocumentDef.xsl
apache\htdocs\xsl\document\DocumentDefView.xsl
apache\htdocs\xsl\finder\ResultBody.xsl
apache\htdocs\xsl\integration\csvimport.xsl
apache\htdocs\xsl\invoice\bolback\BOLBackHeader.xsl
apache\htdocs\xsl\invoice\bolback\BOLBackLineItem.xsl
apache\htdocs\xsl\invoice\bolback\BOLBackRefnumRemark.xsl
apache\htdocs\xsl\managerlayout\AddField.xsl
apache\htdocs\xsl\omr\Omr.xsl
apache\htdocs\xsl\omr\OmrD.xsl
apache\htdocs\xsl\omr\viewOmrHeader.xsl
apache\htdocs\xsl\order\OrderReleaseOtherAttributes.xsl
apache\htdocs\xsl\order\OrderReleaseShipUnit.xsl
apache\htdocs\xsl\order\view_OrderReleaseHeader.xsl
apache\htdocs\xsl\orderbase\CommObLine.xsl
apache\htdocs\xsl\orderbase\CommObShipUnit.xsl
apache\htdocs\xsl\orderbase\ObLegConstraintsDetails.xsl
apache\htdocs\xsl\orderbase\OrderBaseConstraints.xsl
apache\htdocs\xsl\orderbase\OrderBaseOther.xsl
apache\htdocs\xsl\orderbase\OrderBaseReleaseInstruction.xsl
apache\htdocs\xsl\orderbase\OrderBaseShipUnit.xsl
apache\htdocs\xsl\orderbase\OrderBaseSuReleaseInstruction.xsl
apache\htdocs\xsl\orderbase\ViewOrderBase.xsl
apache\htdocs\xsl\orderbase\uic\EditSuReleaseInstruction.xsl
apache\htdocs\xsl\orderbase\view_OrderBaseHeader.xsl
apache\htdocs\xsl\orderbase\view_OrderBaseLegConstraint.xsl
apache\htdocs\xsl\procurement\bid\InvitationEmailFormat.xsl
apache\htdocs\xsl\procurement\bid\InvitationEmailFormatWithoutLaneDescription.xsl
apache\htdocs\xsl\roe\OrderEdit.xsl
apache\htdocs\xsl\roe\RapidOrderEntry.xsl
apache\htdocs\xsl\shipment\Shipment_Mode.xsl
apache\htdocs\xsl\status\SkuDetail.xsl
apache\htdocs\xsl\tenderresp\ExecTendMain.xsl
apache\htdocs\xsl\tenderresp\ExecTendOrders.xsl
apache\htdocs\xsl\uic\GetItineraryOptions.xsl
apache\htdocs\xsl\uic\GetNewStopSequence.xsl
apache\htdocs\xsl\uic\OrderBaseReleaseInstruction2.xsl
apache\htdocs\xsl\uic\ReadyToShip.xsl
apache\htdocs\xsl\uic\RereleaseOrderBaseResults.xsl
apache\htdocs\xsl\uic\misc\ConsolShipmentResult.xsl
apache\htdocs\xsl\uic\shipment\ShipmentDetail.xsl
apache\htdocs\xsl\uic\shipment\ViewShipmentStopInfeasibleOrders.xsl
apache\htdocs\xsl\workflow\DefaultObSuReleaseInstructionEventHtml.xsl
apache\htdocs\xsl\workflow\DefaultObSuReleaseInstructionEventText.xsl
apache\htdocs\xsl\workflow\DefaultShipmentGroupStatusText.xsl
apache\htdocs\xsl\workflow\DefaultShipmentGroupStatusText_de.xsl
apache\htdocs\xsl\workflow\DefaultShipmentGroupStatusText_es_MX.xsl
apache\htdocs\xsl\workflow\DefaultShipmentGroupStatusText_fr_CA.xsl
apache\htdocs\xsl\workflow\DefaultShipmentGroupStatusText_zh_CN.xsl
apache\htdocs\xsl\workspace\ListType.xsl
glog\config\glog.base.properties
glog\config\glog.common.properties
glog\config\glog.compareengine.properties
glog\config\glog.webserver.properties
glog\config\\GLogXML.xsd
glog\config\maps\ObSuReleaseInstructionMap.xml
glog\config\maps\OrderBaseMap.xml
glog\glog_resources\glog.ejb-metadata.properties
glog\glog_resources\glog.gen-metadata.properties
glog\glog_resources\glog.uom-metadata.properties
glog\glog_resources\glog\comm\query\QueryResources_xml.properties
glog\oracle\script8\content_glogowner\ACTION.csv
glog\oracle\script8\content_glogowner\ACTION_DEF.csv
glog\oracle\script8\content_glogowner\ACTION_DEF_STATE.csv
glog\oracle\script8\content_glogowner\AGENT_ACTION.csv
glog\oracle\script8\content_glogowner\AGENT_EVENT.csv
glog\oracle\script8\content_glogowner\APP_FUNCTION.csv
glog\oracle\script8\content_glogowner\AUTO_ASSIGN_TYPE_CRIT_MAP.csv
glog\oracle\script8\content_glogowner\BN_CONTEXT.csv
glog\oracle\script8\content_glogowner\BN_RULE.csv
glog\oracle\script8\content_glogowner\BN_TYPE.csv
glog\oracle\script8\content_glogowner\DATA_QUERY_TYPE.csv
glog\oracle\script8\content_glogowner\NOTIFY_FUNCTION.csv
glog\oracle\script8\content_glogowner\NOTIFY_SUBJECT.csv
glog\oracle\script8\content_glogowner\NOTIFY_SUBJECT_STYLESHEET.csv
glog\oracle\script8\content_glogowner\PLANNING_PARAMETER.csv
glog\oracle\script8\content_glogowner\PLANNING_PARAMETER_QUALIFIER.csv
glog\oracle\script8\content_glogowner\QUERY_TABLE.csv
glog\oracle\script8\content_glogowner\STATUS_FUNCTOR.csv
glog\oracle\script8\content_glogowner\STATUS_TYPE.csv
glog\oracle\script8\content_glogowner\STATUS_VALUE.csv
glog\oracle\script8\content_glogowner\STYLESHEET_PROFILE.csv
glog\oracle\script8\content_glogowner\TRANSLATION.csv
glog\oracle\script8\content_glogowner\TRANSLATION_D_ERR_en.csv
glog\oracle\script8\content_glogowner\TRANSLATION_D_QUERY_en.csv
glog\oracle\script8\content_glogowner\TRANSLATION_D_en.csv
glog\oracle\script8\content_glogowner\TRANSLATION_ERR.csv
glog\oracle\script8\content_glogowner\TRANSLATION_QUERY.csv
glog\oracle\script8\content_glogowner\V50BP_ACTION_DEF_STATE.csv
glog\oracle\script8\content_glogowner\V50BP_AGENT_EVENT.csv
glog\oracle\script8\content_glogowner\V50BP_APP_FUNCTION.csv
glog\oracle\script8\content_glogowner\V50BP_AUTO_ASSIGN_TYPE_CRIT_MAP.csv
glog\oracle\script8\content_glogowner\V50BP_BN_CONTEXT.csv
glog\oracle\script8\content_glogowner\V50BP_BN_RULE.csv
glog\oracle\script8\content_glogowner\V50BP_BN_TYPE.csv
glog\oracle\script8\content_glogowner\V50BP_BS_STATUS_GROUP_PROFILE.csv
glog\oracle\script8\content_glogowner\V50BP_DATA_QUERY_TYPE.csv
glog\oracle\script8\content_glogowner\V50BP_DOMAIN_ROLE.csv
glog\oracle\script8\content_glogowner\V50BP_NOTIFY_FUNCTION.csv
glog\oracle\script8\content_glogowner\V50BP_NOTIFY_SUBJECT.csv
glog\oracle\script8\content_glogowner\V50BP_NOTIFY_SUBJECT_STYLESHEET.csv
glog\oracle\script8\content_glogowner\V50BP_PLANNING_PARAMETER.csv
glog\oracle\script8\content_glogowner\V50BP_PLANNING_PARAMETER_QUALIFIER.csv
glog\oracle\script8\content_glogowner\V50BP_QUERY_TABLE.csv
glog\oracle\script8\content_glogowner\V50BP_RATE_SERVICE_TYPE.csv
glog\oracle\script8\content_glogowner\V50BP_STATUS_FUNCTOR.csv
glog\oracle\script8\content_glogowner\V50BP_STATUS_TYPE.csv
glog\oracle\script8\content_glogowner\V50BP_STATUS_VALUE.csv
glog\oracle\script8\content_glogowner\V50BP_STYLESHEET_PROFILE.csv
glog\oracle\script8\content_glogowner\V50BP_TRANSLATION.csv
glog\oracle\script8\content_glogowner\V50BP_TRANSLATION_D_ERR_en.csv
glog\oracle\script8\content_glogowner\V50BP_TRANSLATION_D_QUERY_en.csv
glog\oracle\script8\content_glogowner\V50BP_TRANSLATION_D_en.csv
glog\oracle\script8\content_glogowner\V50BP_TRANSLATION_ERR.csv
glog\oracle\script8\content_glogowner\V50BP_TRANSLATION_QUERY.csv
glog\oracle\script8\content_glogowner\V50BP_csvdiff_tables.txt
glog\oracle\script8\content_glogowner\V50BP_insert_glogowner_data.txt
glog\oracle\script8\content_glogowner\V50BP_update_glogowner_data.txt
glog\oracle\script8\content_glogowner\xml\agent_action\ob_ship_unit_mod_propagate_changes.txt
glog\oracle\script8\content_glogowner\xml\agent_action\obsu_release_instruction_mod_delete_release_instruction.txt
glog\oracle\script8\content_glogowner\xml\agent_action\obsu_release_instruction_mod_propagate_changes.txt
glog\oracle\script8\content_glogowner\xml\agent_action\obsu_release_instruction_mod_re_release.txt
glog\oracle\script8\content_glogowner\xml\finder_set\buy_shipment.xml
glog\oracle\script8\content_glogowner\xml\finder_set\ob_order_base.xml
glog\oracle\script8\content_glogowner\xml\finder_set\omr.xml
glog\oracle\script8\content_glogowner\xml\finder_set\order_release.xml
glog\oracle\script8\content_glogowner\xml\finder_set\sell_shipment.xml
glog\oracle\script8\content_glogowner\xml\manager_layout\freight_forwarding.xml
glog\oracle\script8\content_glogowner\xml\user_menu_layout\adminmenu.xml
glog\oracle\script8\content_glogowner\xml\user_menu_layout\dbaadmin.xml
glog\oracle\script8\content_glogowner\xml\user_menu_layout\defaultmenu.xml
glog\oracle\script8\content_glogowner\xml\user_menu_layout\servprovadmin.xml
glog\oracle\script8\content_glogowner\xml\user_menu_layout\servprovmenu.xml
glog\oracle\script8\content_procure\ACTION.csv
glog\oracle\script8\content_procure\ACTION_ARG.csv
glog\oracle\script8\content_procure\ACTION_DEF.csv
glog\oracle\script8\content_procure\ACTION_DEF_STATE.csv
glog\oracle\script8\content_procure\QUERY_TABLE.csv
glog\oracle\script8\content_procure\TRANSLATION.csv
glog\oracle\script8\content_procure\TRANSLATION_D_en.csv
glog\oracle\script8\content_procure\V50BP_ACTION.csv
glog\oracle\script8\content_procure\V50BP_ACTION_ARG.csv
glog\oracle\script8\content_procure\V50BP_ACTION_DEF.csv
glog\oracle\script8\content_procure\V50BP_ACTION_DEF_STATE.csv
glog\oracle\script8\content_procure\V50BP_TRANSLATION.csv
glog\oracle\script8\content_procure\V50BP_TRANSLATION_D_en.csv
glog\oracle\script8\content_procure\V50BP_insert_procure_data.txt
glog\oracle\script8\content_procure\V50BP_update_procure_data.txt
glog\oracle\script8\content_procure\xml\finder_set\p_project.xml
glog\oracle\script8\content_report\REPORT.csv
glog\oracle\script8\content_report\REPORT_GROUP.csv
glog\oracle\script8\content_report\REPORT_PARAMETER.csv
glog\oracle\script8\create_dbpatch_50b.sql
glog\oracle\script8\create_dbupdate_50b.sql
glog\oracle\script8\csvdiff.sh
glog\oracle\script8\csvdiff_chkin.sh
glog\oracle\script8\csvdiff_patch.sh
glog\oracle\script8\csvdiff_procure_50.sh
glog\oracle\script8\csvdiff_procure_patch.sh
glog\oracle\script8\dbpatch_50b.sql
glog\oracle\script8\load_java.sql
glog\oracle\script8\pkg\checkc.pkb
glog\oracle\script8\pkg\checkc.pks
glog\oracle\script8\pkg\create_index.pkb
glog\oracle\script8\pkg\create_index.pks
glog\oracle\script8\pkg\create_table.pkb
glog\oracle\script8\pkg\create_table.pks
glog\oracle\script8\pkg\foreign_key.pkb
glog\oracle\script8\pkg\foreign_key.pks
glog\oracle\script8\pkg\primary_key.pkb
glog\oracle\script8\pkg\primary_key.pks
glog\oracle\script8\procure\create_autocombine_package.sql
glog\oracle\script8\procure\create_procure_objects.sql
utils\integration\transform\GLogXML_v50_to_v45.xsl
glog\reports\procurement_sol_eval_by_lane.rdf
glog\reports\procurement_sol_eval_by_lane_excel.rdf
glog\reports\procurement_solution_by_lane.rdf
glog\reports\procurement_solution_by_lane_excel.rdf
glog\reports\procurement_solution_cost.rdf
glog\reports\procurement_solution_cost_excel.rdf

Next Scheduled Service Release

The next Service Release is scheduled for February 2006.

Customer Support

Contact G-Log Technical Support if you need assistance with this service release:

Email:

support@glog.com

Continental United States:

+1.866.456.4423

International:

+1.800.837.4717

Direct Dial:

+1.610.491.3695

 

You should also have the following logs available before you call Customer Support: