Oracle in Terfaces Xml-Interface-Changes-Guide
Oracle in Terfaces Xml-Interface-Changes-Guide
Cloud
Transportation
and Global Trade
Management
Release 24C
Oracle Fusion Cloud Transportation and Global Trade Management
XML Interface Changes Guide
Release 24C
F94375-01
Contents
Get Help
There are a number of ways to learn more about your product and interact with Oracle and other users.
Get Support
You can get support at My Oracle Support. For accessible support, visit Oracle Accessibility Learning and Support.
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
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
Reference Description
Changes to TransmissionCommon.xsd
Reference Description
Reference Description
Changes to Item.xsd
Reference Description
Changes to Order.xsd
Reference Description
5
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History
Changes to Shipment.xsd
Reference Description
Reference Description
Changes to GenericTransaction.xsd
Reference Description
Changes to Item.xsd
Reference Description
Changes to Shipment.xsd
Reference Description
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
Changes to LocationContact.xsd
Reference Description
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
Reference Description
7
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History
Reference Description
28796492 Add Child GTM Transaction Lines to Parent GTM Transaction Line
Changes to Item.xsd
Reference Description
Changes to Location.xsd
Reference Description
Changes to Shipment.xsd
Reference Description
34599326 Add Cutoff Fields for Location and Appointment Rule Set
Reference Description
8
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History
Changes to Finance.xsd
Reference Description
Changes to Item.xsd
Reference Description
Changes to LocationContact.xsd
Reference Description
Changes to Order.xsd
Reference Description
Changes to Planning.xsd
Reference Description
Changes to Shipment.xsd
Reference Description
9
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History
Reference Description
Reference Description
Changes to GenericTransaction.xsd
Reference Description
Changes to GTM.xsd
Reference Description
10
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History
Changes to Item.xsd
Reference Description
Add ItemQualificationConditionType
Changes to LocationContact.xsd
Reference Description
Changes to Order.xsd
Reference Description
33285472 IsTemporary for OrderMovement is deprecated and will be removed in a future release
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
11
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History
Reference Description
Changes to ShipUnit.xsd
Reference Description
Reference Description
Changes to GTM.xsd
Reference Description
Changes to Item.xsd
Reference Description
12
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History
Changes to LocationContact.xsd
Reference Description
Changes to Order.xsd
Reference Description
Changes to Rate.xsd
Reference Description
Changes to Shipment.xsd
Reference Description
Reference Description
13
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 3
XML Interface Changes Guide Schema Change History
Changes to Document.xsd
Reference Description
Changes to Finance.xsd
Reference Description
Changes to GTM.xsd
Reference Description
Changes to Item.xsd
Reference Description
Changes to LocationContact.xsd
Reference Description
31537024 Make primary key element (GID/Sequence) as optional when using Integration Saved Query
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
Changes to Planning.xsd
Reference Description
31537024 Make primary key element (GID/Sequence) as optional when using Integration Saved Query
Changes to Shipment.xsd
Reference Description
31537024 Make primary key element (GID/Sequence) as optional when using Integration Saved Query
Changes to ShipUnit.xsd
Reference Description
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
16
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions
Element Definitions
The following global element, type, or attribute definitions have been added.
Item.xsd
Shipment.xsd
17
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions
Item.xsd
18
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions
Location.xsd
19
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions
Shipment.xsd
Finance.xsd
20
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions
Shipment.xsd
21
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions
GenericTransaction.xsd
GTM.xsd
Item.xsd
22
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions
LocationContact.xsd
Order.xsd
Shipment.xsd
ShipUnit.xsd
23
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions
GTM.xsd
Item.xsd
LocationContact.xsd
Order.xsd
24
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions
Rate.xsd
25
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions
26
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 4
XML Interface Changes Guide Added Element Definitions
Shipment.xsd
GTM.xsd
LocationContact.xsd
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
IntCommand Modified
• IntCommandName
ProductClassificationType Added
• GtmProdClassPurposeGid
Item.xsd
ItemQualificationType Modified
• GtmStructureGid
Order.xsd
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
EquipmentType Added
• TruckCenterLength
• TruckCount
• TotalAxleCount
• MaxAxleWeight
SEquipmentType Added
• TruckCenterLength
• TruckCount
• TotalAxleCount
• MaxAxleWeight
• TruckAWeight
• TruckAAxleWeight
• TruckBWeight
• TruckBAxleWeight
• AxleWeightImbalance
GLogXMLTransaction Added
• GtmDeclarationLine
GenericTransaction.xsd
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
• DestLocationGid (minOccurs to 0)
Item.xsd
PackagingType Added
• HazmatItemRef
Shipment.xsd
PlannedShipment Added
• TransportModeType
DocumentOwnerType Modified
Item.xsd
GtmItemClassificationType Added
• CustomsDescription
LocationContact.xsd
ContactType Added
31
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions
• IntSavedQuery
Order.xsd
ReleaseInstructionType Added
• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
ShipUnitRelInstInfoType Added
• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
ShipUnit.xsd
ShipUnitContentType Added
• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
SSLocationType Added
• LocationGid
32
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions
GtmTransactionLineType Added
• GtmTransactionLine
Item.xsd
ItemValueSetType Added
• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
Location.xsd
LocationType Added
• ApptCutoffHours
• ApptBeforeCutoff
• ApptAfterCutoff
ApptRuleSetType Added
• ApptCutoffHours
• ApptBeforeCutoff
• ApptAfterCutoff
Shipment.xsd
ConditionalSpotBidType Added
33
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions
• Tag1
• Tag2
• Tag3
• BidComment
SEquipmentType Added
• GrossCGLength
• GrossCGWidth
• GrossCGHeight
• EmptyCGLength
• EmptyCGWidth
• EmptyCGHeight
• FloorHeight
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
ServiceProviderType Added
• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
Order.xsd
ReleaseAllocShipmentDetailType Added
• VatCodeGid
Planning.xsd
ItineraryType Modified
35
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions
Shipment.xsd
ServiceProviderType Added
• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
ShipmentHeaderType Added
• ReservationNumber
ShipmentHeader2Type Added
• ProjectedTourName
• ProjectedTourSequenceNum
ShipmentCostType Added
• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
• FlexFieldCurrencies
GtmStructureType Added
• AlternateDesignator
36
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions
AllocReleaseDetailType Added
• AllocSeqNo
• AllocCostSeqno
AllocReleaseLineDetailType Added
• AllocSeqNo
• AllocCostSeqno
AllocTransOrderLineDetailType Added
• AllocSeqNo
• AllocCostSeqno
GenericTransaction.xsd
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
GtmTransactionLine Added
• GtmStructureValue
• CountryOfExport
• CountryOfImport
GtmTransaction Added
• CountryOfExport
• CountryOfImport
GtmStructureValueType Added
• GtmValueQualifierGid
• CurrencyValue
• ExchangeRateGid
• ExchangeRateDate
Item.xsd
RIQQueryType Added
• LegPosition
LocationContact.xsd
ApptRuleSetType Added
• MaximumShipUnitsAllowed
Order.xsd
ReleaseType Added
• TrackingEvents
ReleaseAllocShipmentType Added
38
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions
• AllocSeqNo
ReleaseAllocShipmentDetailType Added
• AllocSeqNo
• AllocCostSeqno
TransOrderType Added
• Status
Shipment.xsd
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
ShipUnitType Added
• IsFixedEruCount
• SShipUnitEquipRefUnit
EquipmentRefUnitType Modified
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
• FlexFieldNumbers
• FlexFieldDates
• FlexFieldCurrencies
GTM.xsd
GtmStructure Added
• PartnerGid
• PartnerSiteGid
• InventoryOrganizationGid
• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
GtmStructureComponent Added
• PartnerGid
• PartnerSiteGid
• InventoryOrganizationGid
• FlexFieldStrings
• FlexFieldNumbers
• FlexFieldDates
Item.xsd
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
• Identifier1
• Identifier2
• Identifier3
• ItemValue
ItemValueType Added
• GtmValueQualifierGid
• Value
• ExchangeRateGid
• ExchangeRateDate
• SeqNumber
ItemOrigin Added
• GtmStructureGid
Modified
• CountryOfOriginGid
LocationContact.xsd
ActivityTimeDef Added
• ServprovProfileGid
• EquipmentGroupProfileGid
Location Added
• EruGrouping
Order.xsd
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
ReleaseLine Added
• PackWithGroup
• VoyageGid
Rate.xsd
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
ShipmentStop Added
• PredictedArrival
• PredictedArrivalLow
• PredictedArrivalHigh
43
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions
User Added
• FirstName
• LastName
• EmailAddress
Document.xsd
Document Modified
• EffectiveDate
• ExpirationDate
Finance.xsd
WorkInvoice Modified
• WorkInvoiceGid
PaymentHeader Modified
• DomainName
GTM.xsd
ControlScreeningResult Added
• AuthorizationTypeGid
ProductClassification Modified
44
Oracle Fusion Cloud Transportation and Global Trade Management Chapter 5
XML Interface Changes Guide Changed Element Definitions
• 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
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
• Primary key element (GID/Sequence) as optional when using Integration Saved Query
Location Added
• IsWMSFacility
Contact Modified
• UseGlcredential
Order.xsd
• Primary key element (GID/Sequence) as optional when using Integration Saved Query
SrcLoc Modified
• QuoteLocInfo
DestLoc Modified
• QuoteLocInfo
ReleaseLine Modified
• ReleaseLineGid
Planning.xsd
• 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
• IsDestBundlePreferred
• Rank
• IsActive
• IsRule11
ServiceTime Modified
• Duration
Shipment.xsd
• Primary key element (GID/Sequence) as optional when using Integration Saved Query
ShipmentStatus Modified
• ShipmentStatusType
ShipUnit Modified
• SShipUnit
Shipunit.xsd
ShipUnit Modified
• SShipUnit
SEquipmentSShipUnitInfo Modified
• NumStackingLayers
• NumLoadingRows
TransmissionCommon.xsd
• 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
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.
Release 24C
None
Release 24B
None
Release 24A
None
Release 23C
None
Release 23B
None
Release 23A
None
Release 22C
Item.xsd
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
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
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
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