GC3 5.0 Service Release: February 2006 (SR-#9: 02.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

VOUCHER_VAT_ANALYSIS

voucher_gid

VARCHAR2(101)

NOT NULL

 

vat_code_gid

VARCHAR2(101)

NOT NULL

 

tax_amount

NUMBER

NOT NULL

 

tax_amount_currency_gid

VARCHAR2(101)

NOT NULL

 

tax_amount_base

NUMBER

NOT NULL

 

exchange_rate_date

DATE

 

 

exchange_rate_gid

VARCHAR2(101)

 

 

vat_rate

NUMBER

 

 

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

VOUCHER

AMT_TO_PAY_WITH_TAX

NUMBER

 

NOT NULL

 

AMT_TO_PAY_WITH_TAX_CURR_GID

VARCHAR2(101)

 

NOT NULL

 

AMT_TO_PAY_WITH_TAX_BASE

NUMBER

 

NOT NULL

ORDER_RELEASE_ACCRUAL

IS_REVERSAL

VARCHAR2(1)

'N'

NOT NULL

 

SHIPMENT_START_DATE

DATE

 

 

 

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

54201.5.0

 

beancache servlet should handle incorrect cache names

The new BeanCacheServlet shows all caches with valid names. By clicking on the cache name, the user is taken to the cache items screen.

56563.5.0

 

Auto Secure Resources menu items out of order on Power Data Screen

Order Of Power Data menu items under Business Process Automation -> Event Management are modified to display in alphabetical order.

56649.5.0

 

There is a conflict between a shipment status transaction and an order release transaction.

The mediation logic is put on ORModEditShipment to ensure that the same shipment in two different threads will not be processed at the same time. There is a property "glog.agent.order.mediateEditShipment". The default value is False.

56742.5.0

ISS00019714

Sending the shipment for integration for testing GC3 WMS integration via an agent and getting a cause.namingDirectory_already_Released exception

Fixed issue where cause.namingDirectory_already_Released error was being generated when building the Shipment.PrimaryShipmentRefInfo.

56806.5.0

 

Related Shipments Smart Link does not work on Order Visibility Screen set

The code assumed existence of a request parameter "type" which would be available only for shipments.

56911.5.0

 

Navigation buttons not showing up in reports with multiple pages.

Navigation buttons are now showing up.

57122.5.0

ISS00020085

Unable to delete certain fields from Manager Layout - INVOICE_VIEW

Fields were named incorrectly and it caused the wrong field to be deleted.

57260.5.0

 

Results on User ID include all domains instead of just public and my domain.

The L and F buttons for the User ID was changed to point to the correct query.

57284.5.0

ISS00020125

Flight number retrieval error from view shipment screen.

Flight view screen now opens from Shipment View.

57360.5.0

 

Event Date/Time is displayed as UTC but name is local.

Set stop num =1 for all tender related shipment events, and use first stop's timezone to display the event date.

57373.5.0

ISS00020232

Ship Unit Line weight gets set to zero when AUTO CALC WEIGHT VOLUME and CALC SHIP UNIT VALUES FROM SHIP UNIT LINES are on.

Fixed an issue where turning on both AUTO CALC WEIGHT VOLUME and CALC SHIP UNIT
VALUES FROM SHIP UNIT LINES planning parameters would sometimes cause the ship unit line weight to be set to zero and then sum up to zero at the ship unit. This most frequently occurred loading an order XML via integration.

57374.5.0

ISS00020210

Product Data Assignment button is throwing a Null Pointer Exception

Null Pointer error no longer occurs.

57403.5.0

 

Delete transactional event from contact doesn't commit

Client side grids now correctly handle items being deleted that have been edited or added.

57410.5.0

 

SMC Rate by Ship Unit is not considering the ship unit count.

SMC rating by ship unit will apply ship unit count during weight accumulation.

57464.5.0

ISS00020294

Product Data Assignment is not populating the Hazmat Item ID.

The Hazmat Item ID on very bottom is now being populated. The Hazardous drop down is being populated as well.

57524.5.0

 

Please add new XML element commodity name for tenderoffer.

CommodityName is added as a child element of Item.

57552.5.0

ISS00020472

Setting up a screenset with a default search criteria for a status value does not return any records.

Replaced the Default Criteria logic with Saved Query definition logic. The Default Criteria supported a limited set of data types and operators. Where the Saved Query definition logic supports all types and operators. This change will now use the same logic in both places.

57560.5.0

ISS00020536

Bug in Claim damage value calculation.

Changed the behavior of the Claim Estimate Damage Value action to consider a null damaged or removed weight as zero damage and create a damage cost line of zero. This would previously error out with a message informing the user that there was not enough information to estimate damage value.

57607.5.0

ISS00019837

While editing the Sell Shipment Under Job Details 3 actions grouped under ITL (and they all have underscores in them) and when running any of the 3 actions there you get the error message: Action not specified or is unknown

The correct actions should now appear for Sell Shipments.

57614.5.0

ISS00020508

Unable to send notification via a Data Query.

The DataQueryDOMBuilder class was modified to handle non-summary notifications

57616.5.0

ISS00020577

On the involved parties tab of a sell side shipment, cannot save changes done using the 'override' functions when editing multiple involved_party_locations records.

Can now edit multiple involved party override addresses and save them correctly.

57621.5.0

ISS00020581

Selecting the finder "One Of" option with a shipment that has duplicate ID's in other domains, returns error.

Fixed the error when using the one of selection when including a shipment with same XID but different domains

57644.5.0

ISS00020571

Issue with Bid Upload

Carriers can now enter separate bids with different equipment or with different transport modes on the same lane.

57651.5.0

 

Power Data master servlet should call help..

Page now calls the Power Data map help topic..

57657.5.0

 

A nullpointer exception is thrown when AES response date is recorded.

Add null pointer check to ITLAESTransmissionTransactionHandler.

57659.5.0

ISS00020632

Trying to create Override on an Involved Party location gives org.w3c.dom.DOMException

Add Involved Party override now works correctly.

57711.5.0

ISS00020699

Saving a saved query with a date range throws NullPointer exception

Fixed null pointer exception when between operator used for a date field.

57718.5.0

ISS00020719

Add shipment event - Ship Unit Link fails

URL used to popup Ship Unit details was not formatted properly

57719.5.0

 

Saved condition view not displaying correctly when changing a saved query

View is updated to display the SQL when Use In Finder = NO as well as original logic is retained to display the expressions when Use In finder = YES

57720.5.0

ISS00020732

Shipment - Actions - Create Job. Job is build in domain of logged in user and not domain of the business object

The Job is created in the domain of the object it is run against.

57731.5.0

ISS00020720

Add Shipment Event. Ship Unit Spec ID is missing

Now Ship Unit Spec ID (Packaged Item) is displayed on Add Shipment Event screen.

57732.5.0

 

StackOverflowError in RatingEngine for Shipments w/ Job ID

Infinite loop in rating engine will no longer happen when Consol shipments are included in a job.

57751.5.0

ISS00020681

AES transmission

When there are more than one lines on a shipment, the Commodities elements in the AES request XML will have different line numbers.

57754.5.0

ISS00020809

Individual threads are using the DBA.ADMIN user role instead of the current user

Rely on the user_association data to qualify service provider for tender query. Otherwise, use planner's own domain data. ExecAsUser is no longer in use in tender function.

57802.5.0

 

Cannot change location in stops in shipments

Can now modify Shipment Stop locations.

57820.5.0

 

View location capacity usage displayed target line incorrectly.

The UI was changed to add a line between buckets so the user can see each individual bucket.

57825.5.0

 

Change the help link for the Order Base Leg Constraint servlet.

Fixed the help link for the Order Base Leg Constraint screen.

57845.5.0

 

Successful rate query for Rail rate with lookup rate service breaks the cache for the rate query for same rail rate for all other domains

Allow crossing domain data references for rate service's day duration calculator and look up time service calculator.

57850.5.0

 

Make SAME AS default for reports parameter screen

Made "same as" default value for report finders

57874.5.0

 

Error with Procurement Reports generated with 'begins with' operator

Reports Run with "Begins With" as the parameter selection come back with correct data.

57885.5.0

ISS00020924

Editing multiple involved party locations on the Freight Forwarding does not save information correctly

Can now edit multiple involved party override addresses and save them correctly.

57905.5.0

 

Via Points are incorrect

Via points are correct now.

57909.5.0

 

Build Shipments - Show Options does not commit.

The correct Vias are now selected for international rate inquiry.

57917.5.0

ISS00020955

Data applied from buyer or customer template is being saved in parent domain and not the domain of the order release

Always set the domain name with the current data domain name

57979.5.0

 

Apply Buyer Template - Does not Copy All Address Override Lines

All involved party address lines should now be copied over when performing the apply buyer template action.

57995.5.0

 

Getting a nullpointer error while it calculates service time on rate offering type 'Zone-Based"

Added check of empty string for rateDistancePK and this null pointer exception should not be thrown anymore.

57998.5.0

 

Change the name of planning parameter LOCATION CAPACITY OPTIMIZER PERCENT OPTIMAL.

Changed the name to LOCATION CAPACITY OPTIMIZER PERCENTAGE TOLERANCE. Changed the logic to take in x% which means that the final solution chosen would at most x% away from the optimal

58000.5.0

 

Large emails are being stuck in the Transport - SMTP queue after being rejected by the mail server.

Added a property to control the maximum size of emails. Emails exceeding this size are sent with a subject, but without content or attachments. The new property is glog.mail.maxContentSize. The value entered is the <size in characters>. The default is 5M.

58001.5.0

 

Rollback usage of multiple level business objects to trigger order base release instruction events

Reverted a portion of the integration changes which treated the Release Instruction in the TransOrder interface as a separate business object for raising events. The behavior already existed in the core product, so the Release Instruction will be maintained as a child object of the TransOrder.

58002.5.0

 

Notification error for order base ship unit release instruction events

Notifications for order base ship unit release instruction events now work.

58011.5.0

 

New Procurement reports not added during Jan 5.0 migration

New Report Records are now added to the DB as part of the service release installation process.

58013.5.0

ISS00020991

Display text overrides in the 'by text' view of documents

Added override column to document detail in the 'by text' LOT view.

58023.5.0

ISS00021094

Using RC transaction code on Invoice GenericLineTime is throwing NullPointer

Added logic to eliminate the exception thrown in the Invoice interface for a null InvoiceLineitem when using an RC Transaction Code in the Invoice.

58103.5.0

ISS00021131

Throwing NullPointer during bulk plan when order's equipment reference unit is not found on equipment group

When the equipment group does not have the equipment reference unit defined, it will return a false (not compatible) rather than throw a null pointer exception.

58131.5.0

 

Rating of Secondary Charge for Shipment Groups Fails

Fixed a bug where successfully rating a secondary charge for shipment groups would error. One work-around is to specify the cost.

58145.5.0

 

R5.0 January Missing Actions

Update the files to contain the missing actions.

58155.5.0

ISS00021187

Unable to edit Rate Record cost without generating an error when the database and web server are separated by a firewall.

Editing Rate Geo Cost records will no longer hit the database through the web server.

58226.5.0

 

Open Tender collaboration data persisting has max bean record reached.

Instead of relying location_corporation table to reverse link contact to a servprov, open tender will cache the contact/servprov info and use it to stage tender_collab_servprov table.

58234.5.0

 

Releasing Deadlock

Since workflow for release instructions has been enabled, there are a couple of problems that need to be fixed to support this in OrderTransactionSessionBean:

- First, we are not querying for all Unprocessed Release Instructions anymore. This is causing us to find release instructions that are being processed on other threads and thus a dead lock.

- Second, we have recalc capabilities at the bean level to update the released count on the ObShipUnit.  Remove the redundant business logic that updates the ObShipUnit and only use the bean level calculation logic.

58236.5.0

 

Billed quantity field on Order Release line table converts to 38 decimals in the database

The outbound integration for the ReleaseLine.BilledQuantity element has been modified to eliminate output of exponential values.

58249.5.0

ISS00021263

G/L code Assignment fails when time windows are incompatible

Fixed an issue where the shipment action Assign General Ledger Codes failed with a bundling error if the time windows on the orders were incompatible. This constraint is ignored for settlement actions.

Enhancements

G-Log Issue

Support Ticket

Issue Summary

Issue Resolution

56001.5.0

 

ReleaseGid is no longer required under Release element

Added BNG support for ReleaseGid, ReleaseLineGid, and ShipUnitGid. The transaction code has

to be "I" in this case. If ship_unit_line wants to reference to the ReleaseLineGid which will

be generated by BNG. The XML format has to be as follows...

<ReleaseLine>

        <ReleaseLineGid>

                      <Gid>

                        <Xid>{1}</Xid>

                      </Gid>

         </ReleaseLineGid>

         ..............

</ReleaseLine>

<ReleaseLine>

        <ReleaseLineGid>

                      <Gid>

                        <Xid>{2}</Xid>

                      </Gid>

         </ReleaseLineGid>

          .....

<ReleaseLine>

<ShipUnitContent>

            <ReleaseLineGid>

                            <Gid>

                              <Xid>{1}</Xid>

                            </Gid>

                        </ReleaseLineGid>

</ShipUnitContent>

<ShipUnitContent>

            <ReleaseLineGid>

                            <Gid>

                              <Xid>{2}</Xid>

                            </Gid>

                        </ReleaseLineGid>

</ShipUnitContent>

56726.5.0

 

VAT Approval Amount

This feature calculates VAT based on the approved amount of the voucher. There are new planning parameters as a result of this: CALCULATE VAT ON VOUCHER; VOUCHER VAT TAX TYPE

56727.5.0

 

Handle Order Re-Plans with existing Accruals

Now if costs have been allocated, it generates accrual reversals when a shipment is deleted and the order re-planned, or when an order is unassigned from a shipment and re-planned.

In addition, the shipment start date has been added to the order release accrual for use as an exchange rate date.

56965.5.0

 

GC3 Does Not Check SERVPROV On Incoming XML - Checks Servprov only.

A check has been added to shipment status processing that prevents processing of shipment status events with a service provider different than that on the shipment. This can be turned on using the following property: glog.shipment.event.checkServiceProvider. The default value of this property is "False".

 

Updated Files

glogserver.jar
glog\gc3webapp\WEB-INF\web.xml
glog\gc3webapp\WEB-INF\jsp\gc3-taglib.tld
glog\gc3webapp\WEB-INF\lib\3rdparty\\commons-logging.jar
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\comm\grids.js
apache\htdocs\js\roe\OrderEdit.js
apache\htdocs\xsl\agent\SavedConditionView.xsl
apache\htdocs\xsl\agent\WorkflowActions.xsl
apache\htdocs\xsl\agent\WorkflowErrors.xsl
apache\htdocs\xsl\carrier\ViewCommMethods.xsl
apache\htdocs\xsl\finderset\FinderSetDefaultCriteria.xsl
apache\htdocs\xsl\invoice\ViewVoucher.xsl
apache\htdocs\xsl\invoice\Voucher.xsl
apache\htdocs\xsl\invoice\viewInvoiceVoucher.xsl
apache\htdocs\xsl\job\JobFinancial.xsl
apache\htdocs\xsl\managerlayout\AddField.xsl
apache\htdocs\xsl\order\OrderReleaseAccrual.xsl
apache\htdocs\xsl\order\fford\FFordInvPartyOverride.xsl
apache\htdocs\xsl\orderbase\ObLegConstraintsDetails.xsl
apache\htdocs\xsl\powerdata\PowerIndex.xsl
apache\htdocs\xsl\powerdata\PowerIndexBusiness.xsl
apache\htdocs\xsl\report\ReportParameters.xsl
apache\htdocs\xsl\roe\OrderEdit.xsl
apache\htdocs\xsl\shipment\Shipment_InvPartyOverride.xsl
apache\htdocs\xsl\shipment\TrackingServerDetail.xsl
apache\htdocs\xsl\status\ShipmentDetail.xsl
apache\htdocs\xsl\tenderresp\ExecTendOrders.xsl
apache\htdocs\xsl\workflow\DefaultObSuReleaseInstructionEventHtml.xsl
apache\htdocs\xsl\workflow\DefaultObSuReleaseInstructionEventText.xsl
glog\config\glog.appserver.properties
glog\config\glog.base.properties
glog\config\\GLogXML.xsd
glog\config\\GLogXML-v2001.xsd
glog\config\procurement\procurement.base.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\PLANNING_PARAMETER.csv
glog\oracle\script8\content_glogowner\PLANNING_PARAMETER_QUALIFIER.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_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_DEF.csv
glog\oracle\script8\content_glogowner\V50BP_DATA_SOURCE_PROFILE.csv
glog\oracle\script8\content_glogowner\V50BP_DISTANCE_EXTERNAL_ENGINE_PARMS.csv
glog\oracle\script8\content_glogowner\V50BP_DOOR.csv
glog\oracle\script8\content_glogowner\V50BP_EXTERNAL_RATING_ENGINE.csv
glog\oracle\script8\content_glogowner\V50BP_MODE_PROFILE_DETAIL.csv
glog\oracle\script8\content_glogowner\V50BP_MONITOR_AGENT_TYPE.csv
glog\oracle\script8\content_glogowner\V50BP_MONITOR_BUSINESS_FUNCTION.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_SHIPMENT_ACTION_QUAL.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_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\manager_layout\freight_forwarding.xml
glog\oracle\script8\content_glogowner\xml\manager_layout\invoice_view.xml
glog\oracle\script8\content_procure\V50BP_csvdiff_tables.txt
glog\oracle\script8\content_report\V50BP_REPORT.csv
glog\oracle\script8\content_report\V50BP_REPORT_GROUP.csv
glog\oracle\script8\content_report\V50BP_REPORT_PARAMETER.csv
glog\oracle\script8\content_report\V50BP_insert_report_data.txt
glog\oracle\script8\content_report\V50BP_update_report_data.txt
glog\oracle\script8\create_dbpatch_50b.sql
glog\oracle\script8\create_dbupdate_50b.sql
glog\oracle\script8\create_glogowner_comments.sql
glog\oracle\script8\insert_security_tables.sql
glog\oracle\script8\pkg\checkc.pkb
glog\oracle\script8\pkg\checkc.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\procure_index.pkb
utils\integration\python\OracleTools.py
util\integration\python\sql2xml.py
util\integration\python\xml2sql.py
util\integration\transform\GLogXML_v45_to_v40.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
glog\reports\reports_library.pll

Next Scheduled Service Release

The next Service Release is scheduled for March 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: