This page describes the content of this Service Release and contains the following sections:
Service Release-Specific Installation Instructions describes additional installation instructions (supplementing the standard service release installation instructions) that are specific to this service release.
Database Changes describes any structural changes that were made to the GC3 database and migration notes, if applicable.
Integration Changes summarizes changes to the standard GC3 XML interfaces.
Corrections describes defects that were reported and fixed in the release.
Enhancements lists all the enhancements in this release (excluding those that were customer-specific and not included in the core product).
Updated Files lists all files that have changed.
Next Service Release shows the date of the next scheduled service release.
Customer Support provides contact information if you need assistance with this service release.
Service Releases are cumulative in their content and any corrections/enhancements from previous service releases are also included. You should also review previous release notes for release-specific installation instructions as well.
There are no service release-specific installation instructions for this release. Refer to the standard service release installation instructions.
Note: If you are using location capacity functionality, please contact Technical Support. There is a known issue with this functionality on the Linux platform and Technical Support can provide a technical (non-code) workaround.
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 |
|
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 |
|
|
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:
Added AmountToPayWithTax element to Voucher element.
Added ExchangeRateInfo element to VatAnalysis element.
Added VatAnalysis element to Voucher element.
Changed Accrual.ShipmentGid from "required" to "optional."
Added IsReversal element to Accrual element.
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 |
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. |
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". |
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
The next Service Release is scheduled for March 2006.
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:
dbpatch__<version>_<dbsid>_<date>.log (adds/updates data due to minor enhancements or fixes)
update_content.log (inserts/updates PUBLIC data included in the service release)