0% found this document useful (0 votes)
50 views

Oracle in Terfaces Xml-Interface-Changes-Guide

Oracle In terfaces xml-interface-changes-guide
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
50 views

Oracle in Terfaces Xml-Interface-Changes-Guide

Oracle In terfaces xml-interface-changes-guide
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 56

Oracle Fusion

Cloud
Transportation
and Global Trade
Management

XML Interface Changes Guide

Release 24C
Oracle Fusion Cloud Transportation and Global Trade Management
XML Interface Changes Guide

Release 24C

F94375-01

Copyright © 2003, 2024, Oracle and/or its affiliates.

Author: Sudheer Rimmalapudi


Oracle Fusion Cloud Transportation and Global Trade Management
XML Interface Changes Guide

Contents

Get Help ................................................................................................................................ i

2 General Integration Processing Changes 3


Consolidated Schema .................................................................................................................................................................... 3
Processing Changes ....................................................................................................................................................................... 3

3 Schema Change History 5


Release 24C Schema Change History ........................................................................................................................................ 5
Release 24B Schema Change History ........................................................................................................................................ 5
Release 24A Schema Change History ....................................................................................................................................... 6
Release 23C Schema Change History ........................................................................................................................................ 6
Release 23B Schema Change History ........................................................................................................................................ 7
Release 23A Schema Change History ........................................................................................................................................ 8
Release 22C Schema Change History ........................................................................................................................................ 8
Release 22B Schema Change History ...................................................................................................................................... 10
Release 22A Schema Change History ...................................................................................................................................... 10
Release 21C Schema Change History ....................................................................................................................................... 12
Release 21A Schema Change History ....................................................................................................................................... 13

4 Added Element Definitions 17


Element Definitions ...................................................................................................................................................................... 17
Release 24C Added Element Definitions ................................................................................................................................. 17
Release 24B Added Element Definitions ................................................................................................................................. 17
Release 24A Added Element Definitions ................................................................................................................................. 18
Release 23C Added Element Definitions ................................................................................................................................. 19
Release 23B Added Element Definitions ................................................................................................................................. 19
Release 23A Added Element Definitions ................................................................................................................................. 19
Release 22C Added Element Definitions ................................................................................................................................ 20
Release 22B Added Element Definitions ................................................................................................................................. 21
Release 22A Added Element Definition ................................................................................................................................... 21
Release 21C Added Element Definition ................................................................................................................................... 24
Oracle Fusion Cloud Transportation and Global Trade Management
XML Interface Changes Guide

Release 21A Added Element Definition ................................................................................................................................... 27

5 Changed Element Definitions 29


Release 24C Changed Element Definitions ............................................................................................................................ 29
Release 24B Changed Element Definitions ............................................................................................................................ 29
Release 24A Changed Element Definitions ............................................................................................................................ 30
Release 23C Changed Element Definitions ............................................................................................................................. 31
Release 23B Changed Element Definitions ............................................................................................................................ 32
Release 23A Changed Element Definitions ............................................................................................................................ 33
Release 22C Changed Element Definitions ............................................................................................................................ 34
Release 22B Changed Element Definitions ............................................................................................................................ 36
Release 22A Changed Element Definitions ............................................................................................................................ 37
Release 21C Changed Element Definitions ............................................................................................................................ 40
Release 21A Changed Element Definitions ............................................................................................................................ 44

6 Removed, Restructured, and Deprecated Elements 49


Summary of Removed or Restructured Elements ................................................................................................................ 49
Summary of Deprecated Elements .......................................................................................................................................... 50
Oracle Fusion Cloud Transportation and Global Trade Management Get Help
XML Interface Changes Guide

Get Help
There are a number of ways to learn more about your product and interact with Oracle and other users.

Get Help in the Applications


Use help icons to access help in the application.

Get Support
You can get support at My Oracle Support. For accessible support, visit Oracle Accessibility Learning and Support.

Join Our Community


Use Cloud Customer Connect to get information from industry experts at Oracle and in the partner community. You can
join forums to connect with other customers, post questions, and watch events.

Learn About Accessibility


For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program. (if videos) Videos
included in this guide are provided as a media alternative for text-based topics also available in this guide.

Share Your Feedback


We welcome your feedback about Oracle Applications user assistance. If you need clarification, find an error, or just
want to tell us what you found helpful, we'd like to hear from you.

You can email your feedback to otm-doc_us@oracle.com.

Thanks for helping us improve our user assistance!

i
Oracle Fusion Cloud Transportation and Global Trade Management Get Help
XML Interface Changes Guide

ii
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 2
XML Interface Changes Guide General Integration Processing Changes

2 General Integration Processing Changes

Consolidated Schema
An XML schema definition, OTMGTM.xsd, consolidates the old separate schema files into one root document to be
more flexible for some third party tools, e.g. for validation or processing of messages. This file can be downloaded from
the Retrieve Schemas page in the Integration Manager user interface.

Processing Changes
This section describes the XML interface changes introduced in Oracle Transportation Management version 21A that
affect the schema documents as a whole. A description of each element and attribute changes are covered in section
3 and section 4. For a complete description of the meaning and use of all interfaces refer to the integration online
documentation.

Primary schema changes in 21A release came from an effort to support strict schema validation. Some key common
changes include

• Primary key element(s) (GID/Sequence) are now optional where an Integration Saved Query is supported
• Weight and Volume are now optional in a WeightVolumeType
• Length, Width and Height are now optional in a LengthWidthHeightType
• GLogDate is now optional in the GLogDateTimeType

3
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 2
XML Interface Changes Guide General Integration Processing Changes

4
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

3 Schema Change History

Release 24C Schema Change History


Changes to Transmission.xsd

Reference Description

36469372 Update documentation to clarify the usage of the element ServletURL.

Changes to TransmissionCommon.xsd

Reference Description

36402048 Add new option “RemoveOrderFromParallelShipments” for IntCommandName element.

Release 24B Schema Change History


Changes to GTM.xsd

Reference Description

36162679 Product classification purpose added to Transaction Line.

Changes to Item.xsd

Reference Description

36169067 Add Item Structure Tags to Item Qualification Type.

Changes to Order.xsd

Reference Description

36085354 Make cost type gid optional.

5
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

Changes to Shipment.xsd

Reference Description

36159253 Add Axle Weight fields to Shipment and Equipment.

Release 24A Schema Change History


Changes to GTM.xsd

Reference Description

35839730 Add outbound support for GtmDeclarationLine.

Changes to GenericTransaction.xsd

Reference Description

35821967 Make SourceLocationGid and DestLocationGid optional for RIQ.

Changes to Item.xsd

Reference Description

35947320 Add HazmatItemRef element to Packaging..

Changes to Shipment.xsd

Reference Description

35828218 Add TransportModeType to PlannedShipment.

Release 23C Schema Change History


Changes to Document.xsd

Reference Description

35117030 Allow multiple object GIDs for the Document interface to allow documents for a shipment stop.

6
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

Changes to Item.xsd

Reference Description

35289560 Add customs description to GtmItemClassification.

Changes to LocationContact.xsd

Reference Description

35135425 Add IntSavedQuery for Contact.

Changes to Order.xsd

Reference Description

35205441 Add flex field support for the order base release and order base ship unit release instruction.

Changes to ShipUnit.xsd

Reference Description

35205441 Add flex fields support for ship unit line.

Release 23B Schema Change History


Changes to Shipment.xsd

Reference Description

34858567 Add Location GID to SSLocation of ShipmentStatus (TrackingEvent) interface

7
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

Release 23A Schema Change History


Changes to GTM.xsd

Reference Description

28796492 Add Child GTM Transaction Lines to Parent GTM Transaction Line

Changes to Item.xsd

Reference Description

34579428 Add Flex Fields for Item Trade Value

Changes to Location.xsd

Reference Description

34597409 Add Tag Fields and BidComment for ConditionalSpotBid

Changes to Shipment.xsd

Reference Description

34599326 Add Cutoff Fields for Location and Appointment Rule Set

34579132 Add Center of Gravity fields for SEquipment

Release 22C Schema Change History


Changes to Configuration.xsd

Reference Description

34129232 Add AutoApproveRuleProfileGid for User

8
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

Changes to Finance.xsd

Reference Description

33938121 Add VoucherInvoiceLineVat for Voucher

Add VatCodeGid for Release and TransOrder

33918240 Add ShipmentGroup information for Voucher

Changes to Item.xsd

Reference Description

32703419 Deprecate IsQualified for ItemQualification

Changes to LocationContact.xsd

Reference Description

34129240 Add Flexfields for ServiceProvider

Changes to Order.xsd

Reference Description

33938121 Add VatCodeGid for TransOrder

Changes to Planning.xsd

Reference Description

29750752 Make ItineraryType element optional for Itinerary

Changes to Shipment.xsd

Reference Description

33935260 Add ProjectedTourName and ProjectedTourSequenceNum for Shipment

33904791 Add Flexfields for ShipmentCost

33954356 Add ReservationNumber for Shipment

9
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

Release 22B Schema Change History


Changes to GTM.xsd

Reference Description

33722728 Add AlternateDesignator for GtmStructure

Release 22A Schema Change History


Changes to Finance.xsd

Reference Description

33389309 Add AllocSeqNo and AllocCostSeqnoforAllocReleaseDetail, AllocReleaseLineDetail and


AllocTransOrderLineDetail

Changes to GenericTransaction.xsd

Reference Description

33440182 Add LegPosition forRIQQuery

Changes to GTM.xsd

Reference Description

33087520 Add GtmStructureValue for GtmTransactionLine

33332446 Add CountryOfExport for GtmTransaction

Add CountryOfExport and CountryOfImport for GtmTransactionLine

33401487 Add CountryOfImport for GtmTransaction

10
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

Changes to Item.xsd

Reference Description

33087551 Add CountryOfImport, RVCPercentage, MinOpsMet, ROOAttribute, WhollyOriginated, and


ItemQualificationConditionsfor ItemQualification

Add ItemQualificationConditionType

Changes to LocationContact.xsd

Reference Description

33294179 Add MaximumShipUnitsAllowed for ApptRuleSet

Changes to Order.xsd

Reference Description

33247081 Add TrackingEvents to Release

33285472 IsTemporary for OrderMovement is deprecated and will be removed in a future release

33389309 Add AllocSeqNo and AllocCostSeqno forReleaseAllocShipmentDetail

Add AllocSeqNo for ReleaseAllocShipment

33377234 Add Status for TransOrder

Changes to OTMGTM.xsd

Reference Description

33010468 A new XML schema definition - OTMGTM.xsd - has been added to consolidate the separate schema
files into one root document

Changes to Shipment.xsd

Reference Description

33098106 Add ConditionalSpotBid For TenderResponse

33223416 Add Flexfields for Vessel

33418108 Add IsDirect and FlightInstanceId for ConditionalBooking

33439216 Add IsAirRailRouteCodeFixed for Shipment

11
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

Reference Description

33440029 Add WaybillDate for Shipment

Changes to ShipUnit.xsd

Reference Description

33001302 Add IsFixedEruCount and SShipUnitEquipRefUnit to ShipUnit

33195905 Make TotalNumReferenceUnits optional for EquipmentRefUnit

Release 21C Schema Change History


Changes to Finance.xsd

Reference Description

32745681 Add AllocTransOrderLineDetail for AllocationBase

Add Flex fields for AllocReleaseDetail, AllocReleaseLineDetail, and AllocTransOrderLineDetail

Changes to GTM.xsd

Reference Description

32377054 Add PartnerGid, PartnerSiteGid and InventoryOrganizationGid for GtmStructure and


GtmStructureComponent

32458880 Add Flex fields for GtmStructure and GtmStructureComponent

Changes to Item.xsd

Reference Description

32223040 Add ItemValueSet for Item interface

Add GtmValueQualifierGid, Value, ExchangeRateGid, ExchangeRateDate, and SeqNumber for


ItemValue

32632682 Add GtmStructureGid for ItemOrigin

12
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

Changes to LocationContact.xsd

Reference Description

32435196 Add ServprovProfileGid, EquipmentGroupProfileGid for ActivityTimeDef

32554912 Add EruGrouping for Location interface

Changes to Order.xsd

Reference Description

32519722 Add PackWithGroup for ReleaseLine

32745681 Add Flex fields for ReleaseAllocShipmentDetail

32832837 Add EarlySailDt, LateSailDt and VoyageGid for ReleaseHeader

Changes to Rate.xsd

Reference Description

32299779 Add OPERAND_QUALIFIER1, OPERAND_QUALIFIER2, OPERAND_QUALIFIER3, OPERAND_QUALIFIER4,


CHARGE_QUALIFIER1, CHARGE_QUALIFIER2, CHARGE_BREAK_COMP_QUALIFIER1, and CHARGE_
BREAK_COMP_QUALIFIER2 to ACCESSORIAL_COST

Changes to Shipment.xsd

Reference Description

32257746 Add PredictedArrival for ShipmentStop

32487668 Add PredictedArrivalLow and PredictedArrivalHigh for ShipmentStop

Release 21A Schema Change History


Changes to Configuration.xsd

Reference Description

31962321 Add FirstName, LastName and EmailAddress to User interface

13
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

Changes to Document.xsd

Reference Description

31880166 Make EffectiveDate and ExpirationDate as optional for Document interface

Changes to Finance.xsd

Reference Description

31537024 Make WorkInvoiceGid as optional for WorkInvoice

32065374 Make DomainName as optional for PaymentHeader

Changes to GTM.xsd

Reference Description

31537024 Make TradeDirection as optional for ProductClassification

31473892 Add AuthorizationTypeGid to ControlScreeningResult

31964784 Make TypeGid and Code as optional for UserDefinedType

Make GtmCode and Code as optional for UserDefinedCode

31955039 Make GtmRegistrationGid as optional for GtmRegistrationDate, GtmRegRelatedItem,


GtmRegRelatedCommodity, GtmRegRelatedUDCommodity, GtmRegRelatedLicense and
GtmRegRelatedRegistration

Changes to Item.xsd

Reference Description

31880166 Make HazmatIndicator, HotIndicator and ResidueIndicator as optional for HazmatItem

31955039 Make ExchangeRateInfo as optional for GtmValue

32039106 Deprecate TradeDirection for GtmItemClassification

Changes to LocationContact.xsd

Reference Description

31537024 Make primary key element (GID/Sequence) as optional when using Integration Saved Query

31880166 Make UseGlcredential as optional for Contact

30346467 Deprecate IntQueueName for Contact

31955658 Add IsWMSFacility to Location interface

14
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

Changes to Order.xsd

Reference Description

31537024 Make primary key element (GID/Sequence) as optional when using Integration Saved Query

31880166 Make QuoteLocInfo as optional for SrcLoc and DestLoc elements.

Make ReleaseLineGid as optional for ReleaseLine

Changes to Planning.xsd

Reference Description

31537024 Make primary key element (GID/Sequence) as optional when using Integration Saved Query

31880166 Make IsMultiStop, Perspective, TotalCost, TotalTransitTime, IsDestBundlePreferred, Rank, IsActive,


IsRule11 as optional for Itinerary

Make Duration as optional for ServiceTime

Changes to Shipment.xsd

Reference Description

31537024 Make primary key element (GID/Sequence) as optional when using Integration Saved Query

31222023 Update schema documentation to describe ShipmentStatusType and SSStopSequenceNum elements


for ShipmentStatus interface

31936304 Move ShipmentStatusType out of ShipmentRefnum/ShipmentGroupRefnum choice group for


ShipmentStatus interface

32008611 Make ShipUnit as optional for SShipUnit

Changes to ShipUnit.xsd

Reference Description

31537024 Make ShipUnit as optional for SShipUnit

31880166 Make NumStackingLayers and NumLoadingRows as optional for SEquipmentSShipUnitInfo

Changes to TransmissionCommon.xsd

Reference Description

31537024 Make primary key element (GID/Sequence) as optional when using Integration Saved Query

15
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History

Reference Description

31616383 Support optional Gid elements

16
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

4 Added Element Definitions

Element Definitions
The following global element, type, or attribute definitions have been added.

[Legend: ‘E’ – Element, ‘T’ – Complex Type, ‘A’ – Attribute.]

Release 24C Added Element Definitions


None.

Release 24B Added Element Definitions


GTM.xsd

XML Element Type Description

GtmProdClassPurposeGid E The purpose of classification like GENERAL,


SPECIAL PROGRAM, PENALTY, EXEMPTION,
etc.

Item.xsd

XML Element Type Description

GtmStructureGid E (Outbound) Identifier for the bill of material.

Shipment.xsd

XML Element Type Description

TruckCenterLength E The length between the centers of the two


truck/bogie systems. Applicable only to rail
cars.

TruckCount E The total number of trucks/bogies on the


equipment. Applicable only to rail cars.

TotalAxleCount E The total number of axles on the equipment.


Applicable only to rail cars.

17
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

XML Element Type Description

MaxAxleWeight E Maximum allowed axle weight. Applicable only


to rail cars.

TruckAWeight E Calculated weight on the truck/bogie A. A


represents the bogie nearest to the origin of the
equipment group. Applicable only to rail cars.

TruckAAxleWeight E Calculated axle weight on the truck/bogie A. A


represents the bogie nearest to the origin of the
equipment group. Applicable only to rail cars.

TruckBWeight E Calculated weight on the truck/bogie B.


B represents the bogie at the end of the
equipment group. Applicable only to rail cars.

TruckBAxleWeight E Calculated axle weight on the truck/bogie


B. B represents the bogie at the end of the
equipment group. Applicable only to rail cars.

AxleWeightImbalance E Denotes the ratio between the calculated axles


weights. Applicable only to rail cars.

Release 24A Added Element Definitions


GTM.xsd

XML Element Type Description

GtmDeclarationLine T (Outbound) Represents a Global Trade


Management Customs Declaration line.

Item.xsd

XML Element Type Description

TransportModeType E (Outbound) specifies the transport mode type,


e.g.: TL, LTL, PARCEL, AIR, etc. on the shipment.

18
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

Release 23C Added Element Definitions


Item.xsd

XML Element Type Description

CustomsDescription E Customs description is a description field


available to enter any hints or insights into the
item customs reasoning.

Release 23B Added Element Definitions


There are no element definitions added for 23B.

Release 23A Added Element Definitions


GTM.xsd

XML Element Type Description

GtmTransactionLine E (Outbound) Identifies Child Transaction Line


Items.

Location.xsd

XML Element Type Description

ApptCutoffHours E Service provider appointment cutoff in hours.


For example, to indicate a cutoff hour of 1 hour,
specify a value for 3600 (1 hour after midnight).

ApptBeforeCutoff E Service provider appointment duration before


cutoff.

ApptAfterCutoff E Service provider appointment duration after


cutoff.

19
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

Shipment.xsd

XML Element Type Description

Tag1 E Tag information provided by the service


provider for the spot bid.

Tag2 E Tag information provided by the service


provider for the spot bid.

Tag3 E Tag information provided by the service


provider for the spot bid.

BidComment E Service provider comment for the spot bid.

GrossCGLength E Calculated length wise position of gross center


of gravity (COG) from the equipment bottom
leftmost corner.

GrossCGWidth E Calculated width wise position of gross center


of gravity (COG) from the equipment bottom
leftmost corner.

GrossCGHeight E Calculated height of gross center of gravity


(COG) from the floor.

EmptyCGLength E When equipment is empty, indicates the length


wise position of Empty center of gravity (COG)
from the equipment bottom leftmost corner.

EmptyCGWidth E When equipment is empty, indicates the width


wise position of Empty center of gravity (COG)
from the equipment bottom leftmost corner.

EmptyCGHeight E When equipment is empty, indicates the height


of Empty center of gravity (COG) from the floor.

FloorHeight E Indicates the actual height of the platform or


floor above the ground or the rail.

Release 22C Added Element Definitions


Configuration.xsd

XML Element Type Description

AutoApproveRuleProfileGid E (Both) Auto Approve Rule Profile ID for the user.

Finance.xsd

XML Element Type Description

VoucherInvoiceLineVatType T (outbound) Voucher VAT information per line.

20
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

XML Element Type Description

LineItemSeqNumber E (outbound) Sequence number of line item.


FK Reference to the VOUCHER_INVOICE_
LINEITEM_JOIN table.

VatSeqNumber E (outbound) VAT sequence number.

Shipment.xsd

XML Element Type Description

ProjectedTourName E (Both) Identifier for the projected tour. If the


projected tour is received as input, this is the
supplied tour ID.

ProjectedTourSequenceNum E (Both) Sequence in which the shipment should


appear in the projected tour.

ReservationNumber E (Both) Reservation number for the shipment.

Release 22B Added Element Definitions


GTM.xsd

XML Element Type Description

AlternateDesignator E (Both) To identify alternate bill of material and


link p arent and child bill of material.

Release 22A Added Element Definition


Finance.xsd

XML Element Type Description

AllocSeqNo E (outbound) A sequence number that is used to


uniquely identify each allocation.

AllocCostSeqno E (outbound) A sequence number that is used to


uniquely identify each allocated cost.

21
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

GenericTransaction.xsd

XML Element Type Description

LegPosition E Define where to insert this stop in a multi-


stopsituation. Validation: (L,F)

GTM.xsd

XML Element Type Description

GtmStructureValueType T (Both) Values for the bill of material.

CountryOfExport E (Both) Identifies the Country of Export for the


Trade Transaction and Trade Transaction Line

CountryOfImport E (Both) Identifies the Country of Import for the


Trade Transaction and Trade Transaction Line

Item.xsd

XML Element Type Description

CountryOfImport E (Outbound) Identifies the country where the


Item is imported from.

RVCPercentage E (Outbound) The percentage of the regional


valu e content method associated with an item
qualification.

MinOpsMet E (Outbound) This flag indicates if minimum oper


ations are met under Rules of Origin.

ROOAttribute E (Outbound) Indicates the attribute description


under the product specific rule(suffix/ex) after
the Rules ofOrigin Qualification.

WhollyOriginated E (Outbound) Indicates if the Item is wholly ori


ginating under the trade agreement.

ItemQualificationConditionType T (Outbound) Contains condition details of an


item qualification.

ConditionShortName E (Outbound) The short name given to rules of


origin rule code.

ConditionDescription E (Outbound) Description of the condition.

IsApplied E (Outbound) Indicates if the condition applied.

22
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

LocationContact.xsd

XML Element Type Description

MaximumShipUnitsAllowed E A constraint on the Appointment Rule Set for


the maximum number of ship units for the
appointment slot. The business use case is to
identify dock doors that are 'express' that will
be unloaded or loaded quickly.

Order.xsd

XML Element Type Description

AllocSeqNo E (outbound) A sequence number that is used to


uniquely identify each allocation.

AllocCostSeqno E (outbound) A sequence number that is used to


uniquely identify each allocated cost.

Shipment.xsd

XML Element Type Description

ConditionalSpotBidType T Provides information about the conditional spot


bid.

ShipUnit.xsd

XML Element Type Description

IsFixedEruCount E Y, N. Indicates whether the ERU defined on


shipment ship unit is used or the ERU is derived
from the order.

SShipUnitEquipRefUnit E Used to specify Ship Unit reference unit of a


Shipment.

23
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

Release 21C Added Element Definition


Finance.xsd

XML Element Type Description

AllocTransOrderLineDetail T Specifies the cost breakdown details for the


Allocation to the Order Base Line.

GTM.xsd

XML Element Type Description

PartnerGid E Partner on the component for the bill of


material.

PartnerSiteGid E Partner site on the component for the bill of


material

InventoryOrganizationGid E Inventory organization on the component for


the bill of material.

Item.xsd

XML Element Type Description

ItemValueSet T Item values based on the Inventory


Organization, Partner, Partner Site, Packaged
Item, and Country of Origin.

ItemValue T Item values based on the item value set table


for a given value qualifier.

LocationContact.xsd

XML Element Type Description

EruGrouping E Indicates orders going to this location will be


grouped together for ERU grouping.

Order.xsd

XML Element Type Description

PackWithGroup E Lines with different Pack with Groups cannot


be packed into the same ship unit. This

24
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

XML Element Type Description

rule applies only to AUTO_CALC order


configuration.

EarlySailDt E The early sailing date and time to be used as


a constraint when planning the order release
onto a buy shipment on the primary leg. This
constraint only applies when the primary leg
contains a voyage.

LateSailDt E The late sailing date and time to be used as


a constraint when planning the order release
onto a buy shipment on the primary leg. This
constraint only applies when the primary leg
contains a voyage.

VoyageGid E The voyage GID to be used as a constraint when


planning the order release onto a buy shipment
on the primary leg. This constraint only applies
when the primary leg contains a voyage.

Rate.xsd

XML Element Type Description

OPERAND_QUALIFIER1 E Determines the attribute/qualifier of the object


on which the condition is based.

For example, if the condition checks the value


for flex field attribute1 = TEST, this column will
hold value as attribute1, the flex field column
name.

If condition is on the reference number qualifier


GLOG = ORDER_01 then this column will hold
the value GLOG, the qualifier name.

OPERAND_QUALIFIER2 E Determines the attribute/qualifier of the object


on which the condition is based.

For example, if the condition checks the value


for flex field attribute1 = TEST, this column will
hold value as attribute1, the flex field column
name.

If condition is on the reference number qualifier


GLOG = ORDER_01 then this column will hold
the value GLOG, the qualifier name.

OPERAND_QUALIFIER3 E Determines the attribute/qualifier of the object


on which the condition is based.

For example, if the condition checks the value


for flex field attribute1 = TEST, this column will
hold value as attribute1, the flex field column
name.

25
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

XML Element Type Description

If condition is on the reference number qualifier


GLOG = ORDER_01 then this column will hold
the value GLOG, the qualifier name.

OPERAND_QUALIFIER4 E Determines the attribute/qualifier of the object


on which the condition is based.

For example, if the condition checks the value


for flex field attribute1 = TEST, this column will
hold value as attribute1, the flex field column
name.

If condition is on the reference number qualifier


GLOG = ORDER_01 then this column will hold
the value GLOG, the qualifier name.

CHARGE_QUALIFIER1 E Determines the attribute/qualifier of the object


based on which the charge is to be calculated.

For example, if the charge is based on some


flex field attribute1, this column will hold value
as attribute1, the flex field column name.

If the charge is based on the reference number


qualifier GLOG = ORDER_01 then this column
will hold the value GLOG, the qualifier name.

CHARGE_QUALIFIER2 E Determines the attribute/qualifier of the object


based on which the charge is to be calculated.

For example, if the charge is based on some


flex field attribute1, this column will hold value
as attribute1, the flex field column name.

If the charge is based on the reference number


qualifier GLOG = ORDER_01 then this column
will hold the value GLOG, the qualifier name.

CHARGE_BREAK_COMP_QUALIFIER1 E Determines the attribute/qualifier of the object


based on which the charge using unit breaks is
to be calculated.

For example, if the rate break is based on flex


field attribute1, this column will hold value as
attribute1, the flex field column name.

If the rate break is based on the reference


number qualifier GLOG = ORDER_01 then this
column will hold the value GLOG, the qualifier
name.

CHARGE_BREAK_COMP_QUALIFIER2 E Determines the attribute/qualifier of the object


based on which the charge using unit breaks is
to be calculated.

For example, if the rate break is based on flex


field attribute1, this column will hold value as
attribute1, the flex field column name.

26
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

XML Element Type Description

If the rate break is based on the reference


number qualifier GLOG = ORDER_01 then this
column will hold the value GLOG, the qualifier
name.

Shipment.xsd

XML Element Type Description

PredictedArrival E Denotes the Predicted Arrival time.

PredictedArrivalLow E Denotes the Predicted Arrival Low time.

PredictedArrivalHigh E Denotes the Predicted Arrival High time.

Release 21A Added Element Definition


Configuration.xsd

XML Element Type Description

FirstName E The given name of the user.

LastName E The surname of the user.

EmailAddress E The email address of the user.

GTM.xsd

XML Element Type Description

AuthorizationTypeGid E Authorization type of related manual


Authorization.

LocationContact.xsd

XML Element Type Description

IsWMSFacility E Indicates if the location is a warehouse


management system facility. Default value is N.

27
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions

28
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

5 Changed Element Definitions

Release 24C Changed Element Definitions


GTM.xsd

XML Type Name Description

IntCommand Modified

• IntCommandName

Release 24B Changed Element Definitions


GTM.xsd

XML Type Name Description

ProductClassificationType Added

• GtmProdClassPurposeGid

Item.xsd

XML Type Name Description

ItemQualificationType Modified

• GtmStructureGid

Order.xsd

XML Type Name Description

ReleaseAllocShipmentDetailType Modified

• CostTypeGid (minOccurs to 0)

29
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

Shipment.xsd

XML Type Name Description

EquipmentType Added

• TruckCenterLength
• TruckCount
• TotalAxleCount
• MaxAxleWeight

SEquipmentType Added

• TruckCenterLength
• TruckCount
• TotalAxleCount
• MaxAxleWeight
• TruckAWeight
• TruckAAxleWeight
• TruckBWeight
• TruckBAxleWeight
• AxleWeightImbalance

Release 24A Changed Element Definitions


Document.xsd

XML Type Name Description

GLogXMLTransaction Added

• GtmDeclarationLine

GenericTransaction.xsd

XML Type Name Description

RIQResultType Modified

• SourceLocationGid (minOccurs to 0)

RIQRouteShipmentType Modified

• SourceLocationGid (minOccurs to 0)

30
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

XML Type Name Description

• DestLocationGid (minOccurs to 0)

Item.xsd

XML Type Name Description

PackagingType Added

• HazmatItemRef

Shipment.xsd

XML Type Name Description

PlannedShipment Added

• TransportModeType

Release 23C Changed Element Definitions


Document.xsd

XML Type Name Description

DocumentOwnerType Modified

• ObjectGid (maxOccurs to unbounded)

Item.xsd

XML Type Name Description

GtmItemClassificationType Added

• CustomsDescription

LocationContact.xsd

XML Type Name Description

ContactType Added

31
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

XML Type Name Description

• IntSavedQuery

Order.xsd

XML Type Name Description

ReleaseInstructionType Added

• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates

ShipUnitRelInstInfoType Added

• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates

ShipUnit.xsd

XML Type Name Description

ShipUnitContentType Added

• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates

Release 23B Changed Element Definitions


Shipment.xsd

XML Type Name Description

SSLocationType Added

• LocationGid

32
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

Release 23A Changed Element Definitions


GTM.xsd

XML Type Name Description

GtmTransactionLineType Added

• GtmTransactionLine

Item.xsd

XML Type Name Description

ItemValueSetType Added

• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates

Location.xsd

XML Type Name Description

LocationType Added

• ApptCutoffHours
• ApptBeforeCutoff
• ApptAfterCutoff

ApptRuleSetType Added

• ApptCutoffHours
• ApptBeforeCutoff
• ApptAfterCutoff

Shipment.xsd

XML Type Name Description

ConditionalSpotBidType Added

33
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

XML Type Name Description

• Tag1
• Tag2
• Tag3
• BidComment

SEquipmentType Added

• GrossCGLength
• GrossCGWidth
• GrossCGHeight
• EmptyCGLength
• EmptyCGWidth
• EmptyCGHeight
• FloorHeight

Release 22C Changed Element Definitions


Configuration.xsd

XML Type Name Description

UserType Added

• AutoApproveRuleProfileGid

Finance.xsd

VoucherType Added

• VoucherInvoiceLineVat
• ShipmentGroup
• ShipmentGroupGid

VoucherInvoiceLineVatType Added

• VoucherGid
• InvoiceGid
• LineItemSeqNumber
• VatSeqNumber

34
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

• VatCodeGid
• VatAmount
• ExchangeRateInfo

AllocReleaseDetailType Added

• VatCodeGid

AllocReleaseLineDetailType Added

• VatCodeGid

AllocTransOrderLineDetailType Added

• VatCodeGid

AllocationBaseType Added

• ShipmentGroup
• ShipmentGroupGid

LocationContact.xsd

XML Type Name Description

ServiceProviderType Added

• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates

Order.xsd

XML Type Name Description

ReleaseAllocShipmentDetailType Added

• VatCodeGid

Planning.xsd

XML Type Name Description

ItineraryType Modified

• ItineraryType (made optional)

35
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

Shipment.xsd

XML Type Name Description

ServiceProviderType Added

• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates

ShipmentHeaderType Added

• ReservationNumber

ShipmentHeader2Type Added

• ProjectedTourName
• ProjectedTourSequenceNum

ShipmentCostType Added

• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
• FlexFieldCurrencies

Release 22B Changed Element Definitions


GTM.xsd

XML Type Name Description

GtmStructureType Added

• AlternateDesignator

36
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

Release 22A Changed Element Definitions


Finance.xsd

XML Type Name Description

AllocReleaseDetailType Added

• AllocSeqNo
• AllocCostSeqno

AllocReleaseLineDetailType Added

• AllocSeqNo
• AllocCostSeqno

AllocTransOrderLineDetailType Added

• AllocSeqNo
• AllocCostSeqno

GenericTransaction.xsd

XML Type Name Description

ItemQualificationType Added

• CountryOfImport
• RVCPercentage
• MinOpsMet
• ROOAttribute
• WhollyOriginated
• ItemQualificationConditions

ItemQualificationConditionType Added

• ItemQualificationGid
• ConditionShortName
• ConditionDescription
• IsApplied

37
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

GTM.xsd

XML Type Name Description

GtmTransactionLine Added

• GtmStructureValue
• CountryOfExport
• CountryOfImport

GtmTransaction Added

• CountryOfExport
• CountryOfImport

GtmStructureValueType Added

• GtmValueQualifierGid
• CurrencyValue
• ExchangeRateGid
• ExchangeRateDate

Item.xsd

XML Type Name Description

RIQQueryType Added

• LegPosition

LocationContact.xsd

XML Type Name Description

ApptRuleSetType Added

• MaximumShipUnitsAllowed

Order.xsd

XML Type Name Description

ReleaseType Added

• TrackingEvents

ReleaseAllocShipmentType Added

38
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

XML Type Name Description

• AllocSeqNo

ReleaseAllocShipmentDetailType Added

• AllocSeqNo
• AllocCostSeqno

TransOrderType Added

• Status

Shipment.xsd

XML Type Name Description

TenderResponseType Added

• ConditionalSpotBid

ConditionalSpotBidType Added

• BidAmount
• PickupDate
• SourceLocationGid
• DestLocationGid
• TransportModeGid
• TransitTime

VesselType Added

• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates

ConditionalSpotBidType Added

• IsDirect
• FlightInstanceId

ShipmentType Added

• IsAirRailRouteCodeFixed
• WaybillDate

39
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

ShipUnit.xsd

XML Type Name Description

ShipUnitType Added

• IsFixedEruCount
• SShipUnitEquipRefUnit

EquipmentRefUnitType Modified

• TotalNumReferenceUnits (made optional)

Release 21C Changed Element Definitions


Finance.xsd

XML Type Name Description

AllocReleaseDetail Added

• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
• FlexFieldCurrencies

AllocReleaseLineDetail Added

• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
• FlexFieldCurrencies

AllocTransOrderLineDetail Added

• TransOrderLineGid
• Description
• AccessorialCodeGid
• Cost
• GeneralLedgerGid
• InvoiceGid
• AssignedNum
• CostTypeGid
• FlexFieldStrings

40
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

XML Type Name Description

• FlexFieldNumbers
• FlexFieldDates
• FlexFieldCurrencies

GTM.xsd

XML Type Name Description

GtmStructure Added

• PartnerGid
• PartnerSiteGid
• InventoryOrganizationGid
• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates

GtmStructureComponent Added

• PartnerGid
• PartnerSiteGid
• InventoryOrganizationGid
• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates

Item.xsd

XML Type Name Description

ItemValueSet Added

• TransactionCode
• IntSavedQuery
• InventoryOrganizationGid
• PartnerGid
• PartnerSiteGid
• PackageItemGid
• CountryOfOriginGid
• LotNumber
• SerialNumber
• SeqNumber

41
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

XML Type Name Description

• Identifier1
• Identifier2
• Identifier3
• ItemValue

ItemValueType Added

• GtmValueQualifierGid
• Value
• ExchangeRateGid
• ExchangeRateDate
• SeqNumber

ItemOrigin Added

• GtmStructureGid
Modified

• CountryOfOriginGid

LocationContact.xsd

XML Type Name Description

ActivityTimeDef Added

• ServprovProfileGid
• EquipmentGroupProfileGid

Location Added

• EruGrouping

Order.xsd

XML Type Name Description

ReleaseLine Added
• PackWithGroup

ReleaseHeader Added

• EarlySailDt
• LateSailDt

42
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

XML Type Name Description

ReleaseLine Added
• PackWithGroup

• VoyageGid

Rate.xsd

XML Type Name Description

RATE_GEO_COST Added

• OPERAND_QUALIFIER1
• OPERAND_QUALIFIER2
• OPERAND_QUALIFIER3
• OPERAND_QUALIFIER4
• CHARGE_QUALIFIER1
• CHARGE_QUALIFIER2
• CHARGE_BREAK_COMP_QUALIFIER1
• CHARGE_BREAK_COMP_QUALIFIER2

ACCESSORIAL_COST Added

• OPERAND_QUALIFIER1
• OPERAND_QUALIFIER2
• OPERAND_QUALIFIER3
• OPERAND_QUALIFIER4
• CHARGE_QUALIFIER1
• CHARGE_QUALIFIER2
• CHARGE_BREAK_COMP_QUALIFIER1
• CHARGE_BREAK_COMP_QUALIFIER2

Shipment.xsd

XML Type Name Description

ShipmentStop Added

• PredictedArrival
• PredictedArrivalLow
• PredictedArrivalHigh

43
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

Release 21A Changed Element Definitions


Configuration.xsd

XML Type Name Description

User Added

• FirstName
• LastName
• EmailAddress

Document.xsd

XML Type Name Description

Document Modified

• EffectiveDate
• ExpirationDate

Finance.xsd

XML Type Name Description

WorkInvoice Modified

• WorkInvoiceGid

PaymentHeader Modified

• DomainName

GTM.xsd

XML Type Name Description

ControlScreeningResult Added

• AuthorizationTypeGid

ProductClassification Modified

44
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

XML Type Name Description

• TradeDirection

UserDefinedType Modified

• TypeGid
• Code

UserDefinedCode Modified

• TypeGid
• Code

GtmRegistrationDate Modified

• GtmRegistrationGid

GtmRegRelatedItem Modified

• GtmRegistrationGid

GtmRegRelatedCommodity Modified

• GtmRegistrationGid

GtmRegRelatedUDCommodity Modified

• GtmRegistrationGid

GtmRegRelatedLicense Modified

• GtmRegistrationGid

GtmRegRelatedRegistration Modified

• GtmRegistrationGid

Item.xsd

XML Type Name Description

HazmatItem Modified

• HazmatIndicator
• HotIndicator
• ResidueIndicator

GtmValue Modified

• ExchangeRateInfo

45
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

LocationContact.xsd

XML Type Name Description

Multiple Types Modified

• Primary key element (GID/Sequence) as optional when using Integration Saved Query

Location Added

• IsWMSFacility

Contact Modified

• UseGlcredential

Order.xsd

XML Type Name Description

Multiple Types Modified

• Primary key element (GID/Sequence) as optional when using Integration Saved Query

SrcLoc Modified

• QuoteLocInfo

DestLoc Modified

• QuoteLocInfo

ReleaseLine Modified

• ReleaseLineGid

Planning.xsd

XML Type Name Description

Multiple Types Modified

• Primary key element (GID/Sequence) as optional when using Integration Saved Query

Itinerary Modified

• IsMultiStop
• Perspective
• TotalCost
• TotalTransitTime

46
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

XML Type Name Description

• IsDestBundlePreferred
• Rank
• IsActive
• IsRule11

ServiceTime Modified

• Duration

Shipment.xsd

XML Type Name Description

Multiple Types Modified

• Primary key element (GID/Sequence) as optional when using Integration Saved Query

ShipmentStatus Modified

• ShipmentStatusType

ShipUnit Modified

• SShipUnit

Shipunit.xsd

XML Type Name Description

ShipUnit Modified

• SShipUnit

SEquipmentSShipUnitInfo Modified

• NumStackingLayers
• NumLoadingRows

TransmissionCommon.xsd

XML Type Name Description

Multiple Types Modified

• Primary key element (GID/Sequence) as optional when using Integration Saved Query

47
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions

48
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 6
XML Interface Changes Guide Removed, Restructured, and Deprecated Elements

6 Removed, Restructured, and Deprecated


Elements

Summary of Removed or Restructured Elements


This section summarizes the elements that have been removed from the schema or have had a major modification
such that it will require clients to modify their existing integration code to comply with the change. These elements will
normally have been deprecated in a previous release. Exceptions to this process will be clearly stated. The location of
the element is given as an XPATH expression relative to the schema document root.

Release 24C
None

Release 24B
None

Release 24A
None

Release 23C
None

Release 23B
None

Release 23A
None

Release 22C
None

Release 22B
None.

Release 22A
None.

49
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 6
XML Interface Changes Guide Removed, Restructured, and Deprecated Elements

Release 21C
None.

Release 21A
None.

Summary of Deprecated Elements


This section summarizes the elements that have been deprecated in this release. Deprecated elements have been left
in the schema to minimize the impact to clients, but will be removed in the next major release. For elements that have
been renamed, the old and new element names will be supported on the inbound, but only the new name will be sent
on the outbound. The location of the element is given as an XPATH expression relative to the schema document root.

Release 24C
None

Release 24B
None

Release 24A
None

Release 23C
None

Release 23B
None

Release 23A
None

Release 22C
Item.xsd

XML Element Description

ItemQualificationType/ IsQualified This element is deprecated and its value is reflected in QualificationStatus as 'QUALIFIED' or 'NOT
QUALIFIED'. Any existing integrations using this element should be updated as this element will be
removed in the next major release.

50
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 6
XML Interface Changes Guide Removed, Restructured, and Deprecated Elements

Release 22B
None.

Release 22A
Order.xsd

XML Element Description

OrderMovement/ IsTemporary This element is deprecated and is not used anymore. Any existing integrations using this element
should be updated as this element will be removed in the next release.

Release 21C
None.

Release 21A
Item.xsd

XML Element Description

GtmItemClassification/TradeDirection This element is deprecated and is not used anymore. Any existing integrations using this element
should be updated as this element will be removed in the next release.

LocationContact.xsd

XML Element Description

Contact/IntQueueName Functionality removed. Value will be ignored and field will be removed in a future release.

51
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 6
XML Interface Changes Guide Removed, Restructured, and Deprecated Elements

52

You might also like