GC3 5.0 Service Release: September 2005 (SR-#5: 09.05)

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

AUTO_SEC_RES_CRITERION

Column

Data Type

Nullable

auto_sec_res_criterion_gid

VARCHAR2(101)

NOT NULL

auto_sec_res_criterion_xid

VARCHAR2(50)

NOT NULL

object_name

VARCHAR2(50)

NOT NULL

field_name

VARCHAR2(50)

NOT NULL

data_type

VARCHAR2(50)

 

uom_code

VARCHAR2(64)

 

min_value

NUMBER(10)

 

max_value

NUMBER(10)

 

domain_name

VARCHAR2(50)

NOT NULL

insert_user

VARCHAR2(128)

NOT NULL

insert_date

DATE

NOT NULL

update_user

VARCHAR2(128)

 

update_date

DATE

 

 

AUTO_SEC_RES_PROFILE

Column

Data Type

Nullable

auto_sec_res_profile_gid

VARCHAR2(101)

NOT NULL

auto_sec_res_profile_xid

VARCHAR2(50)

NOT NULL

saved_condition_gid

VARCHAR2(101)

 

saved_condition_override_crit

VARCHAR2(1)

DEFAULT ''N''

must_meet_all_criteria

VARCHAR2(1)

DEFAULT ''Y''

domain_name

VARCHAR2(50)

NOT NULL

insert_user

VARCHAR2(128)

NOT NULL

insert_date

DATE

NOT NULL

update_user

VARCHAR2(128)

 

update_date

DATE

 

 

AUTO_SEC_RES_PROFILE_D

Column

Data Type

Nullable

auto_sec_res_profile_gid

VARCHAR2(101)

NOT NULL

auto_sec_res_criterion_gid

VARCHAR2(101)

NOT NULL

domain_name

VARCHAR2(50)

NOT NULL

insert_user

VARCHAR2(128)

NOT NULL

insert_date

DATE

NOT NULL

update_user

VARCHAR2(128)

 

update_date

DATE

 

 

AUTO_SEC_RES_PROFILE_LANE_JOIN

Column

Data Type

Nullable

auto_sec_res_profile_gid

VARCHAR2(101)

NOT NULL

x_lane_gid

VARCHAR2(101)

NOT NULL

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

CONDITIONAL_BOOKING_FIELD

UPDATE_FIELD_NAME

VARCHAR2(500)

 

Modified Columns

Table

Column

DataType

INVOICE

UPDATE_FIELD_NAME

VARCHAR2(500)

INVOICE

CURRENCY_GID

default null

REPORT_PARAMETER

FIXED_VALUES

VARCHAR2(4000)

INVOICE

IS_VAT_ANALYSIS_FIXED

NOT 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

45460.5.0

 

Secondary charges not added when building shipments from order movement- works when using Bulk Planning.

This is working now. You are able to build secondary charges for shipments created from an order movement.

47013.5.0

 

It appears that remarks are no longer saving correctly for conditional bookings.

Remark, refnum, equipment ini/num now saved for conditional booking.

47547.5.0

 

Unable to see results when specifying service time constraints in International RIQ.

CriteriaToBeIgnored was not being set properly causing it not to ignore the service time infeasibility. It now has the expected hour glass with a cross mark if it is service time infeasible.
Restored deleted functionality.

50252.5.0

 

Error when using SMC rate

Added null checks for source and destination addresses and postal codes.

50870.5.0

 

Move User type User Role grant management to the User Role manager

Moved the granting of User Roles to Users from the User Manager to the User
Role Manager.

51060.5.0

1-9628

Order Movement in a planned final status but with no shipment will bulk plan by itself but not if selected with others.

When an Order Movement is in a status of PLANNING_PLANNED - FINAL but does not have a shipment attached to it, its status will not be changed and thus cannot be planned. Even the unassign action will not change its status.

51888.5.0

 

AllocationXML not validating against schema.

Changed PaymentHeader.NetDueDate field from required to optional.

51900.5.0

1-10086

Large order is not Bulk planned if load config is turned on.

This is related only to curved roof rail wagon. It could not rate because the last equipment is incorrectly loaded with 100 ship units, not 58 units making the total weight of 86800 KG exceeding the max weight limit for the rate record. With the fix, when load config is on, there should be 5 shipments built all with the same equipment group: RAILWAGON_25.1M. When load config is off, the first four shipments will have RAILWAGON_25.1M while the 5th shipment would have equipment group of RAILWAGON_18.8M.

52224.5.0

1-10253

Undefined Help for the Resource tab on a location.

The correct Help topic now opens.

52289.5.0

1-10245

Planned arrival time on the first stop is when the location is closed.

Corrected mistakes in calculating rest time at stop when stop wait time is involved and overlaps with some of the rest times for driver simulation service time.

52500.5.0

 

1 Failed tender email from End-to-End Order stress test

Synchronize the instance method of XSLHelper and XMLHelper to avoid initiation error when concurrent access occurs.

52560.5.0

 

Beta Test Issue 1368 Non Freight Related Charge shipment type not available in shipment finder for saved queries

1. Since we have no lifetime events related to SELL(BUY) NFRC SHIPMENT, the
SELL(BUY) NFRC SHIPMENTs are no longer viewable in agent type drop down under
agent manager.
2. Create a new data query type "BS SHIPMENT". This data query type does not
append any default where condition to the generated saved query when user tries to choose "user in finder" in saved query manager. In contrast, the
SELL/BUY SHIPMENT data query type will always append the where condition
like "shipment_type = 'NFRC' AND PERSPECTIVE = 'B'"
3. Use the new data query type to configure the agents. First, create a saved query with "BS SHIPMENT" query type from powerdata. At the saved Query manager, please click "user In Finder", then select "shipment type" under column dropdown and "non freight related charge" under shipment type dropdown. After finished, a query like "select shipment_gid where shipment_gid =? and shipment_type ="non freight related charge" should be generated. Second, create a BUY/SELL SHIPEMENT agent. Third, added the saved query generated early to the agent through saved condition.

52785.5.0

 

Need to increase the report parameter max length to 4000 chars

The size of FIXED_VALUES field in the REPORT_PARAMETER table is now increased
to 4000 characters.

53181.5.0

 

Refnum qualifier is not copying down on a grid on Custscreens.

The reference number qualifier is now able to be saved.

53220.5.0

 

Unable to edit service days on flight schedule.

The xpath for frequency in the hidden variable was incorrect. Have corrected it.

53328.5.0

 

Dead lock in audit trail

Added an option to separate audit trail cleanup from the removal of the owning business object.

53378.5.0

 

XMLbuilder not assigned with NotifyContext

Added support of notify with glog xmls for Monitored Shipment.

53400.5.0

1-10722

Need to set the bean count for SavedQueryValues bean to 200.

Updated the count to match the SavedQuery bean count - 1000

53447.5.0

 

Please add UI validation for charter voyage schedule setup.

Added UI validation to ensure user enter *Terminal Start Time > 0(zero)
and *Terminal Start Time > *Terminal Close Time.

53449.5.0

1-10748

Case sensitivity issue on v5.0 search screens.

Changed the Invoice related, Order release, and Freight forwarding finders to allow mixed case text search for the Remark Value field.

53455.5.0

 

Screenset changes do not take effect on scalability webservers

Fixed web-side scalability messaging when GC3 delegates messages to workflow.

53466.5.0

 

Script error when trying to use the new text template icon in remarks grid for item.

Fixed. Note that the remarks are order release line remarks so only support general text templates.

53642.5.0

1-10817

The 'PLANT TO' location field is left blank when both the 'DESTINATION' and 'PLANT TO' locations are changed at the same time - UI

Fixed a bug for order base line, order base ship unit, and order release where user manually changed the source location and plan from (or the destination and plan to) and GC3 was nulling out the plan from (or plan to). This was because of a previous assumption that any change to the source (or destination) should reset the plan from (or plan to) based on the substitute location even if that means nulling it out.
Now, GC3 will not overwrite plan from/plan to locations if:
1) the user has changed them, even if the source/destination has changed
2) an overwrite would null out the plan from or plan to
GC3 will overwrite plan from/plan to locations if:
1) the source (or destination) has changed and a substitute location does exist for
the new source (or destination)
2) the plan from (or plan) to is null

53702.5.0

 

Move to shipment errors when no equipment on unitized consol.

On Move to Shipment action, error message "The selected shipment has no equipment." is displayed when there is no equipment.

53742.5.0

1-10843

STATIC TRIP is not bulk planning two orders when combined weight exceeds max weight of equipment, despite one being delivered before the other one is picked up.

The equipment capacity check on schedule instance shipment is changed to use the correct method of calculating total weight and volume on shipment.

53781.5.0

 

Redo Transmission processing is processing extra transmissions

Fixed the error that Redo Transmission processing is processing extra transmissions.

53830.5.0

 

Planning parameter SOLUTION IMPROVE CONFIG ID has a value set to 'NULL'

Check if the planning parameter SOLUTION IMPROVE CONFIG ID has a value. If not, write to the log and let bulk plan continue.

53831.5.0

 

Errors related to network connectivity are not helpful

The problem was caused when a bad username or password was specified
during the buildShipmentSet action. A very unhelpful "StringIndexOutOfBounds"
exception was returned. The system now checks for this condition and reports
the error in a friendlier way.

53833.5.0

 

Finding projects by location does not work

Source Location ID and Destination Location ID have been added to the project finder.

53834.5.0

 

Lane description on email to carriers is inconsistent

Lane description on the email sent to carriers is now consistent with the bid finder results.

53842.5.0

 

Bid Status change is not working properly.

Bid status change is now working correctly. Tested by changing the variable cost on a pre-bid and the status automatically changed to comittment_new as it should.

53885.5.0

1-10896

Need to add foreign key cascade on all OMR tables.

Foreign keys on OMR referencing order_release and all child on following tables are cascading now.
OMR
OMR_D
OMR_STATUS
OMR_D_LINE
OMR_D_LINE_REFNUM
OMR_D_LINE_REMARK
OMR_D_LINE_STATUS

53891.5.0

 

MatchRuleProfileD bean cache needs to be increased.

Increase Bean Cache to 300 for MatchRuleProfileD.

53943.5.0

 

Saved Query drop down on finders is not updated in SCA (scalability) environment

Added property to enable SavedQueryNameCache in SCA environment.

53946.5.0

 

Assign Partition fails with StringIndexOutOfBoundsException if the SQL query inside saved query is in upper case

Ignore the case of the sql query defined in the saved query.

53980.5.0

1-10986

When selecting multiple records in the Ground Schedule results screen and clicing 'view', then 'next,' an error message is displayed.

Fixed .Now able to select multiple records and use the NEXT/PREVIOUS buttons to view them.

54021.5.0

 

Currency problem

The export code now looks for a property to decide whether or not to add a column for the UOM (currency) type.  By adding the following property:

glog.webserver.finder.export.include_uom=Currency

This will add a column to the spread sheet for the Currency type.  You can add the weight type by adding the following property.

glog.webserver.finder.export.include_uom=Weight

54024.5.0

 

Change Help link for Equipment details window.

Updated the link to help topic.

54044.5.0

 

Ask Glog vessel schedule label.VoyageStowageModes is not translated.

Added the translation resources.

54047.5.0

 

Sell side consols are not displayed in the charter voyage view screen

Show both Buy Consol and Sell Consol ID in Charter Voyage View screen:Rename the existing "Consol ID" with "Buy Consol ID" and add a new column "Sell Consol ID".

54048.5.0

 

Edit screen does not display the fact that sell consols exist for the stowage modes

Show both Buy Consol and Sell Consol ID in Charter Voyage Edit screen:Rename the existing "Consol ID" with "Buy Consol ID" and add a new column "Sell Consol ID".

54049.5.0

 

Voyage Summary By Stowage Mode does not handle the buy and sell side console link properly

All actions in the charter voyage manager need a perspective. They include
closeConsols(charterVoaygePK)
openConsols
pre-commitConsols
commit-Consols
unprecommitConsols
uncommitConsols
View Voyage Summary

54051.5.0

 

The status isn't being set to ISSUED for vouchers belonging to parent invoices

Vouchers for parent invoices now set to ALLOCATION_VOUCHER_ISSUED so that they are not re-sent when Issue Allocation is run.

54109.5.0

 

Multiple invoices allowed to create for a Buy Shipment using Shipment Actions.

Fixed a bug where multiple users or processes attempted to create an invoice from a shipment at the same time, and both were able to complete resulting in duplicate invoices and duplicate payments. This has been fixed so that the first one to complete will be saved and any others will fail with a message informing the user of this concurrent modification.

54112.5.0

 

Re-use Equipment is spelled differently on two adjacent pages.

Label has been changed to Re-use.

54113.5.0

 

Order release is removed from job when order is unassigned.

In unassign actions (unassign order release and unassign order movements), remove links between job and order releases, links between job and permanent order movements for only consol related jobs.

54121.5.0

 

Help link for Integration Manager XML Upload does not work.

Make the help link after upload XML or CSV files through the Integration manager.

54123.5.0

 

Bad help links when moving to a consol shipment.

Updated the help links.

54167.5.0

1-11048

Adding 2 'assign variable' actions to a milestone ID generates a stack trace error - java.lang.StackOverflowError

This was an error in the xsl xpath which was resulting in an endless loop. The
xsl xpath has been changed.

54181.5.0

1-10972

Equipment with temp control set to null being selected over equipment with valid temp control records

Updated the help topic "Temperature Control" Also added a section to the Getting Started topic.

54202.5.0

 

Incorrect SQLException in the log file when editing an auto assignment rule

Added synchronization to JMS remove notifications.

54308.5.0

1-11038

The DropListCacheManager needs to be modified to cache by user id as well as all of the other criteria it already caches by

Added the ability to exclude queries from being cached. To exclude a query from being cached add a glog property with the key glog.droplistcache.exclude and the value is the full java class name that does the query. For example: To exclude Shipment Refnum Qualifiers from the cache -
glog.droplistcache.exclude=glog.server.query.powerdata.ShipmentRefnumQualQuery

54329.5.0

 

dedicated_security pool is performing slowly.

Added pre-caching of COMMON groups. This should minimize the simultaneously
loading of functional groups by multiple users and the subsequent contention on
the security pool.

54330.5.0

 

app server switching to failover is not transparent to user

Fixed 5.0 Authentication to seamlessly switch to the failover cluster if necessary.

54344.5.0

 

Got a null pointer exception when unassigning single OR.

This problem is caused by collecting a non-existing depot stop to remove. It is fixed now.

54346.5.0

 

Solution summary reports incorrect results

The solution summary was reporting incorrect results because it failed to account for entries in the solution detail table where the percent award was 0. This problem has been corrected.

54349.5.0

 

Variable Handling Time mistakenly set to 0 on location role.

Fixed Integration logic to handle VarHandlingTime element.

54352.5.0

1-11132

OMR PLANNING ALERT event that is triggered when the redrive service time is infeasible.

This is fixed by the OMD work

54355.5.0

 

Function based routing errors.

Enabled full support for the Optimization Architecture feature.

54485.5.0

 

Calendar needs to allow performing until midnight instead only up to 11:59 PM.

1) Treat mid-night "To Time" as mid-night next day, which means mid-night to mid-night is a 24-hour period.
2) A period of same time other than mid-night (such as 9:00AM to 9:00AM) is currently allowed, and should still be allowed. It has 0 seconds gap.
3) All "From Time" and "To Time" are still accurate up to minutes (have 0 seconds)

54487.5.0

 

Issue with Adding Release.InvolvedParty.LocationOverrideInfo

Fixed the NullPointerException when loading the release xml in which Release.InvolvedParty.LocationOverrideInfo is specified and the InvolvedParty.ComMentodGid is not specified

54584.5.0

1-11044

Remaining weight, volume, TEU, FEU are blank on the result screen for 'move to consol shipment' action

Change UI to show remaining capacity.

54586.5.0

1-11223

Unable to build a shipment - process hangs on service time.

If min rest time = 0, do not calculate rest period because it caused an infinite loop.

54601.5.0

 

Non Public domain reports, when scheduled, give an error (file not found)

For non DBA records an extra . is added in the GID. This was causing problems
when creating filenames. It is being replaced now by an _. So correct filenames
are created.

54623.5.0

 

Max capacity line displayed while there is no bucket max capacity.

Updated to show the used/max/target capacity for each bucket when the capacity
is defined (any non-null value including 0), and hide the capacity when the
value is not defined (null).

54640.5.0

1-11135

Deliver Absolutely First constraint not being considered when MULTISTOP USES LIFO PICKUP DROPOFF planning parameter set to true

In both cases, LIFO and non-LIFO, we should be able to build a single shipment
DEN->PUC->RVR->SLC that honors the delivery absolutely first constraint on the
second order OR2.

54680.5.0

 

Multistop distance saving different behavior in BP versus multistop planning

For both BP and build multistop action, two orders are combined into one multistop shipment now.

54681.5.0

 

Unable to send out Shipment Stop interface.

Removed the "Send Interface Transmission " action form Shipment Stop Manager

54700.5.0

 

BDP 094 AES Changes (ADP)

The attribute names were changed as requested.

54703.5.0

 

Incorrect data in translation d error csv file

Fixed the extra comma in the exception message.

54709.5.0

 

Error deleting a Contact via XML

Fixed the nullPointerException when trying to delete contact records from
Integration

54711.5.0

 

Fix Validation Logic for Contact that is Primary for a Location

Fixed validation issue where a Contact which was marked as IsPrimary could not
be updated with the same setting for IsPrimary.

54721.5.0

 

Invoice net amount due in database default when no base charge line items

Fixed a bug where the optional invoice currency code was not defined and there
was no base charge. In this case, the net amount due should have been in the
currency of one of the line items, but instead it was in the database default.
The net amount due currency will be in 1) the currency specified on the invoice
if specified, else 2) the currency of the base charge, else 3) the currency of
one of the line items (which are typically of the same currency).

54722.5.0

 

Update Job Interface to Include Order Release from Order Movements

Updated Integration logic for generating the Job.Release element to include
the order releases from the order movements.

54724.5.0

 

Deadlock in Audit trail

Locking mechanism is used on single appserver and multiple appservers
(Scalability) for the audit trail creation process and audit clean up process. Any of the process would need to obtain the lock in order to run.
This guarantees the two processes will not run across each other and cause
deadlocks.

54740.5.0

1-11303

View Shipment Events screen does not display all events chronologically in the order the transmissions were received.

Shipment events on View Shipment events screen were getting sorted based on
transmission date and stop number. It is now been changed to transmission
date descending.

Introduced new property in GC3 “glog.shipment.viewevents.sortorder=event_date”
(default). Users who don’t want this configuration can change this property
value to any other value (ex: event_date,stop_num) to get current sorting
order.

54780.5.0

 

Site crashes with an out of memory error from itinerary loop in the logs

Added a new property
glog.business.shipment.MaxNumberOfShipmentGroupsForSplitOrders that will group
the shipments into those many groups (if #of shipments > property value). The
total leg options considered would be reduced resulting in reduced number of
TShipment cloning and thus avoiding memory issues. However, it may not utilize
the capacity of the cheapest carrier in some instances. In general, if the
number of shipment groups (property) is increased, it would give a better
solution at the expense of run time and memory usage.

54782.5.0

 

PDF reports bring back more data than requested

The issue of more data coming back than requested is attributed to
Windows2000,
IE, with Acrobat 6 and "Display PDF in Browser" option checked in Acrobat.
There are two possible solutions to this:
1. Close all IE sessions. Uncheck the "Display PDF in Browser" setting in
Acrobat. Run the report again.

2. Upgrade Acrobat to version 7.

Any of the above steps will resolve this issue.

54800.5.0

 

Bulk Plan Query page has a typo.

Fixed the typo in "Numer of Order Selected"on Bulk Plan Query page.

54802.5.0

 

Web server needs to be bounced after making translation changes.

Editing a label now bounces the labels cache on all web servers.

54825.5.0

 

Unable to add capacity group to Rate Offering.

Can now update Capacity Group field.

54826.5.0

 

Intelliroute RMI (Remote Method Invocation) layer for Solaris needed

Added RMI (Remote Method Invocation) layer to handle communication from GC3 JDK 1.4.2 to Intelliroute 1.3.1 on the Solaris platform.

54844.5.0

 

Transmission processing error when throttle is set to true

One of the changes for 52660.5.0 was not checked in and thus the exception.

54861.5.0

 

Recalculate cost doesn't recalculate cost for all related shipments, but only primary shipment.

Someone has changed my rate to charge per distance, therefore it's not updating
the cost since the distance is not changing. It's works fine after I changed the rate to charge per weight.

54942.5.0

 

RBI ship unit line hazardous item flag is not working for international rate inquiry.

Rate inquiry will now correctly set the order release line hazardous flag for rating
purposes.

54944.5.0

 

Order booking line amendment is not notify when modify shipunit weight.

It's now notifying when edit ship unit's weight/volume/count.

54946.5.0

 

Alert is not being raised when order LD is earlier than consol shipment endtime.

For OMD date propagation,when the shipment the OM is on is on a Chartered Voyage, check if the changed dates are feasible with the existing schedule of the Voyage, and if so, propagate the change to the OM, else, error the transaction and not propagate the change to the OM and alert the user. The date change will be propagated to the OR, as before.

54964.5.0

 

Order Release Line - HTS - Integration

Removed Integration validation logic

54965.5.0

 

Issue 1446 - Check export license UI (user interface) field labels are mapped incorrectly to the XML tags

Corrected the mapping and added license number to the XML.

54966.5.0

 

Issue 1447 - Check export license response not properly displaying exception codes

Fixed to read more than one code.

54969.5.0

1-11512

When saving a saved_query - dates set to today +1 (for saved_query_definition) are being saved as today's date

The date conversion routine for saved query criteria has been corrected to
convert the date from GMT to the user's time zone.

54984.5.0

 

PVT cost allocation consolidating by mistake

Fixed a bug in the allocation process that was allowing like costs (ex. two
identical Accessorial charges) to be consolidated even though they were marked
private to different orders.

54986.5.0

 

Order booking line amendment sent out for every order release (OR) in consol shipment.

Modified the code so that booking line amendments are sent out only for the ORs that get modified.

54987.5.0

 

Order booking line amendment should always display the delta.

Modified the code so that booking line amendments display delta rather than updated value.

54988.5.0

 

OBL amendment always displays ChangeAction = D when OMD.

Modified code so that booking line amendments display A or D correctly for the delta.

55002.5.0

1-11481

From the OM user interface - cannot select 57 (or more) OMS and then run bulk plan.

When running this action on more than 57 records, the records were not getting
stored in the correct location. Instead of getting stored in the session they
were placed in the redirect url and this was causing an error in the browser.
The records are now being stored in the correct location and the browser will
not display an error.

55042.5.0

 

Error running custom SQL in business monitor

Fixed the SQL parsing error when a saved query is based off of custom SQL.
Upper case SQL keywords were causing an error.

55085.5.0

 

Deleting one of the many shipments of the OR, still marks the OR as planning unscheduled

If orders are split into multiple shipments, all the shipment have to be deleted at once.

If order movements are split into multiple shipment, all the shipments have to be deleted at once

55108.5.0

 

Performance purpose, it should ignore when there is no differences.

To improve performance: only propagate dates change to OM and shipments when
the dates are actually changed. If the dates are the same before/after,
planning logic ignores the agent parameter that instructs to propagate.

55150.5.0

 

Mediator Not Enforcing Order of Transmission Processing across Transmissions

Transaction mediation has been updated to support blocking across Integration
Transmissions using a global process group designation. When the property is set to true, a Transmission which has a ProcessGrouping in the
TransmissionHeader defined with a ProcessGroupOwner and the ProcessGroupOwner
is not itself specified as a ProcessGrouping within the Transmission, then the
ProcessGroupOwner (or Parent Group) will be setup as a global process group
which will block on all transactions in the process group. For example, if
the only ProcessGrouping in the Transmission is defined as below:
<processgrouping>
<processgroup>MYGROUP.48785</processgroup>
<processgroupowner>48785</processgroupowner>
<insequence>Y<insequence>
</processgrouping>
then all Transactions across Transmissions that are designated in
MYGROUP.48785 ProcessGroup will be sequenced globally.

The following property enables the functionality.
glog.server.workflow.mediator.supportGlobalGroup = true

55161.5.0

1-8

Order releases can be planned on a static ground schedule in violation of the delivery constraint

Order's delivery constraint should be checked against times on schedule instance. In the given case, no time feasible schedule instance can be found and order should fail to plan.

55281.5.0

 

PCMiler Latitude/Longitude - Incorrect Conversion

Changed Latitude to be N/S, Longitude to be E/W

55420.5.0

 

Null pointer building shipment from order movement

Fixed a null pointer exception that occurred when finding shipment group rules
for an order movement that did not have an itinerary.

55423.5.0

 

Bill XML for Parent Invoice needs to map the sell shipment

Modified the query in Integration for generating the Billing.Shipment element to only use the associations defined in the invoice_shipment and shipment_bill tables. The logic was previously selecting all the shipments related to the order releases that are on the bill. If there is a need to revert to the previous query, the following property can be used:glog.integration.Billing.Shipment.useOldQuery = true

55501.5.0

18967

Smartlink for order release does not work using French translations.

Escaped the Javascript properly for French translations.

 

Enhancements

G-Log Issue

Support Ticket

Issue Summary

Issue Resolution

51800.5.0

 

Accessorials for Spot Rating allowed

This enhancement provides the ability to enter multiple cost lines on the Edit Service Provider and Cost action page.

54061.5.0

 

Add Packaging Unit to Ready to Ship Screen

Added the Packaging Unit and Packaging Unit Count fields to the Ready to Ship screen.

54305.5.0

 

Agent Action to Manage Service Provider Allocation on Order

An agent action has been added to populate the service provider as a constraint on an order release that will lookup the "furthest behind" service provider as to assignment commitment and assign that service provider.

54307.5.0

 

Copy Data From Consolidated Booking to Shipment

Add logic to Conditional Booking function to copy service provider's value to additional fields of shipment and its children tables. Note the definition of update_field_name in table conditional_booking_field should be added via csv file. By default, GC3 leaves this column blank.

54310.5.0

 

Ability to Show/ Hide Profit on Job

Added a property to allow users to hide/show the profit section of the Job Details screen.

54328.5.0

 

Date Change on Orders with Order Movements

OMD functionality has been enhanced to propagate Order Release dates to affected order movement and shipments in addition to ship unit quantity propagation.

54332.5.0

 

Bulk Plan Mediation Logic

Order release objects are mediated to ensure that only one of the following processes can work against a given order release object at a given time.
- Bulk Plan from Process Control
- Bulk Plan from the UI
- Bulk Plan Order Movements from Process Control
- Bulk Plan Order Movements from UI
- Order Release Modifications via Integration
- Order Release Deletes via Integration

New properties have been added.

54341.5.0

 

Add the Release element to the Booking Line Amendment

Added the Release XML element to the BookingLineAmendment XML.

54342.5.0

 

Order Movement Screen Set Criteria Additions

Added the following four fields to Order_Movement screen set in the result tab
Source Location Name
Source City
Destination Location Name
Destination City

54544.5.0

 

Rate by Order Release Refnums

Implemented order release refnum rate basis items

54960.5.0

1-11081

The query for region based rate unit breaks does not rank the regions based on rank. It just selects the first matching region for a region group.

Sorted regions by geo hierarchy ranking.

 

Updated Files

glogserver.jar

glog\config\maps\ui\*

glog\gc3webapp\WEB-INF\web.xml

glog\oracle\insert_security_roles.sql

weblogic\config\gc3domain\applications\GC3App.ear

apache\htdocs\html\help\webhelp\en\*

apache\htdocs\js\buttons\buttons.js

apache\htdocs\js\calendar\calendar.js

apache\htdocs\js\managerlayout\editfield.js

apache\htdocs\xsl\air\Air.xsl

apache\htdocs\xsl\calendar\Calendar.xsl

apache\htdocs\xsl\calendar\Override.xsl

apache\htdocs\xsl\chartervoyage\CharterVoyageStowage.xsl

apache\htdocs\xsl\chartervoyage\CharterVoyageStowageData.xsl

apache\htdocs\xsl\chartervoyage\CharterVoyageView.xsl

apache\htdocs\xsl\detail\Report.xsl

apache\htdocs\xsl\finder\ResultBody.xsl

apache\htdocs\xsl\invoice\InvoiceEquipment.xsl

apache\htdocs\xsl\invoice\InvoiceLineitemVat.xsl

apache\htdocs\xsl\job\JobFinancial.xsl

apache\htdocs\xsl\lane\XLane2.xsl

apache\htdocs\xsl\lane\XLane3.xsl

apache\htdocs\xsl\order\OrderReleaseShipUnitLine.xsl

apache\htdocs\xsl\order\fford\FFordShipUnitLineFromLIData.xsl

apache\htdocs\xsl\order\fford\FFordShipUnitLineFromSUData.xsl

apache\htdocs\xsl\powerdata\PowerIndexBusiness.xsl

apache\htdocs\xsl\procurement\bid\EditBid.xsl

apache\htdocs\xsl\procurement\bid\InvitationEmailFormat.xsl

apache\htdocs\xsl\repetitionschedule\RepetitionScheduleView.xsl

apache\htdocs\xsl\scem\MonitorAgentSetupComm.xsl

apache\htdocs\xsl\tender\AutoSecResProfile.xsl

apache\htdocs\xsl\tender\AutoSecResProfileView.xsl

apache\htdocs\xsl\uic\GetSEquipmentForOM.xsl

apache\htdocs\xsl\uic\GetServiceProviderCost.xsl

apache\htdocs\xsl\uic\ReadyToShip.xsl

apache\htdocs\xsl\uic\misc\ConsolShipmentResult.xsl

apache\htdocs\xsl\uic\order\MoveOrderMovementToConsolShipmentInput.xsl

apache\htdocs\xsl\uic\shipment\ChooseConsolSEquipment.xsl

apache\htdocs\xsl\uic\shipment\SplitShipmentToConsolInput.xsl

apache\htdocs\xsl\uit\shipmentActuals\FastActualsEntry.xsl

apache\htdocs\xsl\uit\shipmentActuals\FastMultiEquipment.xsl

apache\htdocs\xsl\uit\shipmentActuals\FastThankYou.xsl

apache\htdocs\xsl\uit\shipmentActuals\common.xsl

apache\htdocs\xsl\uit\shipmentActuals\sell\ActualsEntry.xsl

apache\htdocs\xsl\uit\shipmentActuals\sell\FastActualsEntry.xsl

apache\htdocs\xsl\uit\shipmentActuals\sell\FastThankYou.xsl

apache\htdocs\xsl\uit\shipmentActuals\sell\ThankYou.xsl

apache\htdocs\xsl\uit\shipmentActuals\sell\ViewRelated.xsl

apache\htdocs\xsl\umt\manageuser.xsl

apache\htdocs\xsl\umt\showmsg.xsl

apache\htdocs\xsl\userrole\UserRole.xsl

apache\htdocs\xsl\userrole\UserRoleView.xsl

glog\config\maps\integration\LocationMap.xml

glog\config\schema\GLogXML.xsd

glog\config\glog.acl.properties

glog\config\glog.appserver.properties

glog\config\glog.base.properties

glog\config\glog.pseudo-field.metadata.properties

glog\config\glog.queryupdate.properties

glog\config\glog.readonly.properties

glog\config\glog.webserver.properties

glog\config\uit\screens.xml

glog\config\uit\tasks.xml

glog\glog_resources\edit_help_links.properties

glog\glog_resources\glog.ejb-metadata.properties

glog\glog_resources\glog.securityGroupings.properties

glog\glog_resources\glog\comm\query\QueryResources_xml.properties

glog\glog_resources\query_help_links.properties

glog\glog_resources\search_help_links.properties

glog\oracle\script8\content_glogowner\ACTION.csv

glog\oracle\script8\content_glogowner\ACTION_ARG.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_ACTION_DETAILS.csv

glog\oracle\script8\content_glogowner\AGENT_EVENT.csv

glog\oracle\script8\content_glogowner\APP_ACTION.csv

glog\oracle\script8\content_glogowner\APP_ACTION_RESP_PARTY_P.csv

glog\oracle\script8\content_glogowner\APP_FUNCTION.csv

glog\oracle\script8\content_glogowner\CONDITIONAL_BOOKING_FIELD.csv

glog\oracle\script8\content_glogowner\DATA_QUERY_TYPE.csv

glog\oracle\script8\content_glogowner\FINDER_SET.csv

glog\oracle\script8\content_glogowner\LOGFILE_DETAIL.csv

glog\oracle\script8\content_glogowner\NOTIFY_SUBJECT.csv

glog\oracle\script8\content_glogowner\NOTIFY_SUBJECT_STYLESHEET.csv

glog\oracle\script8\content_glogowner\QUERY_TABLE.csv

glog\oracle\script8\content_glogowner\RATE_GEO_COST_OPERAND.csv

glog\oracle\script8\content_glogowner\RATE_GEO_COST_OP_OWNER.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_EXPL_en.csv

glog\oracle\script8\content_glogowner\TRANSLATION_D_NOT_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_EXPL.csv

glog\oracle\script8\content_glogowner\TRANSLATION_NOT.csv

glog\oracle\script8\content_glogowner\TRANSLATION_QUERY.csv

glog\oracle\script8\content_glogowner\V50BP_ACTION.csv

glog\oracle\script8\content_glogowner\V50BP_ACTION_ARG.csv

glog\oracle\script8\content_glogowner\V50BP_AGENT_ACTION_DETAILS.csv

glog\oracle\script8\content_glogowner\V50BP_AGENT_EVENT.csv

glog\oracle\script8\content_glogowner\V50BP_APP_ACTION.csv

glog\oracle\script8\content_glogowner\V50BP_APP_ACTION_RESP_PARTY_P.csv

glog\oracle\script8\content_glogowner\V50BP_APP_FUNCTION.csv

glog\oracle\script8\content_glogowner\V50BP_CONDITIONAL_BOOKING_FIELD.csv

glog\oracle\script8\content_glogowner\V50BP_DATA_QUERY_TYPE.csv

glog\oracle\script8\content_glogowner\V50BP_LOGFILE_DETAIL.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_QUERY_TABLE.csv

glog\oracle\script8\content_glogowner\V50BP_RATE_GEO_COST_OPERAND.csv

glog\oracle\script8\content_glogowner\V50BP_RATE_GEO_COST_OP_OWNER.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_EXPL_en.csv

glog\oracle\script8\content_glogowner\V50BP_TRANSLATION_D_NOT_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_EXPL.csv

glog\oracle\script8\content_glogowner\V50BP_TRANSLATION_NOT.csv

glog\oracle\script8\content_glogowner\V50BP_TRANSLATION_QUERY.csv

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\assign_commitment_based_sp.txt

glog\oracle\script8\content_glogowner\xml\agent_action\order_release_mod_propagate_changes.txt

glog\oracle\script8\content_glogowner\xml\finder_set\agent_event.xml

glog\oracle\script8\content_glogowner\xml\finder_set\bill_invoice.xml

glog\oracle\script8\content_glogowner\xml\finder_set\bolback_invoice.xml

glog\oracle\script8\content_glogowner\xml\finder_set\charter_voyage.xml

glog\oracle\script8\content_glogowner\xml\finder_set\conditional_booking_field.xml

glog\oracle\script8\content_glogowner\xml\finder_set\freight_forwarding.xml

glog\oracle\script8\content_glogowner\xml\finder_set\invoice.xml

glog\oracle\script8\content_glogowner\xml\finder_set\invoice_invoice.xml

glog\oracle\script8\content_glogowner\xml\finder_set\order_release.xml

glog\oracle\script8\content_glogowner\xml\finder_set\shipment.xml

glog\oracle\script8\content_glogowner\xml\finder_set\shipment_stop.xml

glog\oracle\script8\content_procure\TRANSLATION_D_QUERY_en.csv

glog\oracle\script8\content_procure\TRANSLATION_QUERY.csv

glog\oracle\script8\content_procure\V50BP_TRANSLATION_D_QUERY_en.csv

glog\oracle\script8\content_procure\V50BP_TRANSLATION_QUERY.csv

glog\oracle\script8\content_procure\xml\finder_set\p_project.xml

glog\oracle\script8\create_dbpatch_50b.sql

glog\oracle\script8\create_dbupdate_50b.sql

glog\oracle\script8\create_glogowner_comments.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_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\pkg_novpd_domain_copy.pkb

glog\oracle\script8\pkg\primary_key.pkb

glog\oracle\script8\pkg\primary_key.pks

glog\oracle\script8\procure\create_views.sql

glog\oracle\script8\procure\procurement.pkb

glog\oracle\script8\procure\query.pkb

glog\oracle\script8\procure\query.pks

Next Scheduled Service Release

The next Service Release is scheduled for October 2005.

Customer Support

Contact G-Log Customer 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: