Fusion Apps Tech Oracle Integration Cloud

Oracle OM OTM Integration|OM GTM Integration

Q: Getting OTM Integration Error: Failed Authentication, failed to assert identity with username token.

The most common reasons are: - Not using the OTM internal user for integration and rather using external email user in OIC connection - Certificates of OTM not imported in OIC - OTM user not having required roles for Integration

Q: How to Get the OTM Certificates?

Follow MOS Doc How to Retrieve Security Certificates for Inbound Integration using Firefox (Doc ID 2105818.1)

2894 Views

SaveSavedRemoved 0

We saw the basic Order to Cash Cycle in Fusion Order management in the previous post. And we may need to integrate with systems like OTM / GTM for transportation planning and Trade compliance.

Below are some snippets and screenshots to implement Oracle OM cloud to OTM GTM Cloud integration using Oracle Integration Cloud (OIC).

This also covers the OIC integration from OTM cloud to Fusion Shipping .

These snippets are generated while implementing the Oracle MOS Note: Sample Integration with OTM/GTM using ICS (Doc ID 2209248.1)

Table of Contents

OIC Integrations

OM_GTM > Oracle Cloud OM to Cloud GTM Integration
GTM_OM > GTM Send Trade Compliance Result to OM
OM_OTM > Oracle Cloud OM to Cloud OTM Integration (Order Release Created in OTM)
OTM_OM > Cloud OTM sends response to OM Cloud after Transportation Planning
OTM _WSH > OTM Plans the shipment and sends it to Fusion Shipping.

OM OTM Integration Flow using OIC

Expected Result after OM_OTM OIC Flow Completes

When OM_OTM OIC process completes successfully you should be able to see Orders created in OTM.

and the order status in fusion would be ‘Awaiting transportation Planning’

ERP Cloud Connection

https://(yourfusiondomain)/fndAppCoreServices/ServiceCatalogService?wsdl

OTM / GTM Connection

https://(yourOTMDomain)/GC3Services/TransmissionService/call?wsdl

Setups

OM Configurations

Task : Manage Orchestration Process Definitions

Set Check for Trade Compliance when user submits sales order to ‘YES’.

Setup connector in task “Manage External Interface Web Service Details”

Task : Manage Order Management Parameters

Setup Tasks Manage External Interface Routing Rules

Payload from OM Cloud to OIC

<ns01:onEvent xmlns:ns01="http://xmlns.oracle.com/cloud/adapter/erp/OM_REQUEST/types"><ns0:getOrderFulfillmentRequestDetailsResponse xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns0="http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/orderFulfillmentRequestService/types/" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsa="http://www.w3.org/2005/08/addressing"><ns3:result xmlns:ns0="http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/orderInformationService/" xmlns:ns1="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns2="http://xmlns.oracle.com/apps/scm/doo/processOrder/model/" xmlns:ns3="http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/orderFulfillmentRequestService/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns0:OrchestrationOrder"><ns0:SourceTransactionIdentifier>300000220097446</ns0:SourceTransactionIdentifier><ns0:SourceTransactionSystemIdentifier>300000000096992</ns0:SourceTransactionSystemIdentifier><ns0:SourceTransactionSystemName>Oracle Fusion Order Orchestration And Planning</ns0:SourceTransactionSystemName><ns0:SourceTransactionSystemCode>OPS</ns0:SourceTransactionSystemCode><ns0:TargetSystemName>Oracle Fusion Order Orchestration And Planning</ns0:TargetSystemName><ns0:TargetSystemCode>OPS</ns0:TargetSystemCode><ns0:TargetSystemIdentifier>300000000096992</ns0:TargetSystemIdentifier><ns0:FusionSystemName>Oracle Fusion Order Orchestration And Planning</ns0:FusionSystemName><ns0:FusionSystemCode>OPS</ns0:FusionSystemCode><ns0:FusionSystemIdentifier>300000000096992</ns0:FusionSystemIdentifier><ns0:SourceTransactionNumber>97586</ns0:SourceTransactionNumber><ns0:BuyingPartyIdentifier>300000219242093</ns0:BuyingPartyIdentifier><ns0:BuyingPartyName>University of Arkansas</ns0:BuyingPartyName><ns0:BuyingPartyNumber>796445</ns0:BuyingPartyNumber><ns0:BuyingPartyPersonFirstName xsi:nil="true"/><ns0:BuyingPartyPersonLastName xsi:nil="true"/><ns0:BuyingPartyPersonMiddleName xsi:nil="true"/><ns0:BuyingPartyPersonNameSuffix xsi:nil="true"/><ns0:BuyingPartyPersonTitle xsi:nil="true"/><ns0:BuyingPartyContactIdentifier>300000219242123</ns0:BuyingPartyContactIdentifier><ns0:BuyingPartyContactName>Matt Waller</ns0:BuyingPartyContactName><ns0:BuyingPartyContactNumber>796446</ns0:BuyingPartyContactNumber><ns0:BuyingPartyContactFirstName>Matt</ns0:BuyingPartyContactFirstName><ns0:BuyingPartyContactLastName>Waller</ns0:BuyingPartyContactLastName><ns0:BuyingPartyContactMiddleName xsi:nil="true"/><ns0:BuyingPartyContactNameSuffix xsi:nil="true"/><ns0:BuyingPartyContactTitle>Dean</ns0:BuyingPartyContactTitle><ns0:PreferredSoldToContactPointIdentifier>300000219242126</ns0:PreferredSoldToContactPointIdentifier><ns0:PreferredSoldToContactPointOrigSystemReference xsi:nil="true"/><ns0:CustomerPONumber xsi:nil="true"/><ns0:TransactionalCurrencyCode>USD</ns0:TransactionalCurrencyCode><ns0:TransactionalCurrencyName>US Dollar</ns0:TransactionalCurrencyName><ns0:TransactionOn>2021-03-31T07:42:42.0Z</ns0:TransactionOn><ns0:RequestingBusinessUnitIdentifier>300000046987012</ns0:RequestingBusinessUnitIdentifier><ns0:RequestingBusinessUnitName>US1 Business Unit</ns0:RequestingBusinessUnitName><ns0:TransactionDocumentTypeCode xsi:nil="true"/><ns0:TransactionDocumentTypeName xsi:nil="true"/><ns0:RequestingLegalUnitIdentifier>300000046973970</ns0:RequestingLegalUnitIdentifier><ns0:RequestingLegalUnit xsi:nil="true"/><ns0:HeaderIdentifier>300000220097446</ns0:HeaderIdentifier><ns0:OrderNumber>97586</ns0:OrderNumber><ns0:ChangeVersionNumber>1</ns0:ChangeVersionNumber><ns0:SourceTransactionRevisionNumber>1</ns0:SourceTransactionRevisionNumber><ns0:SubmittedFlag>true</ns0:SubmittedFlag><ns0:BuyingPartyType>ORGANIZATION</ns0:BuyingPartyType><ns0:BuyingPartyLastUpdateDate>2021-03-04T19:52:05.701Z</ns0:BuyingPartyLastUpdateDate><ns0:OperationCode>CREATE</ns0:OperationCode><ns0:TransactionTypeCode xsi:nil="true"/><ns0:TransactionType xsi:nil="true"/><ns0:PartialShipAllowedFlag>true</ns0:PartialShipAllowedFlag><ns0:OrchestrationOrderLine><ns0:SourceTransactionIdentifier>300000220097446</ns0:SourceTransactionIdentifier><ns0:SourceTransactionLineIdentifier>300000220097463</ns0:SourceTransactionLineIdentifier><ns0:SourceTransactionScheduleIdentifier>1</ns0:SourceTransactionScheduleIdentifier><ns0:SourceTransactionLineNumber>1</ns0:SourceTransactionLineNumber><ns0:SourceTransactionScheduleNumber>1</ns0:SourceTransactionScheduleNumber><ns0:SourceTransactionSystem>OPS</ns0:SourceTransactionSystem><ns0:SourceTransactionNumber>97586</ns0:SourceTransactionNumber><ns0:ProductIdentifier>300000219241801</ns0:ProductIdentifier><ns0:OrderedQuantity xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" unitCode="zPK">1</ns0:OrderedQuantity><ns0:OrderedUOMCode>zPK</ns0:OrderedUOMCode><ns0:OrderedUOM>PK</ns0:OrderedUOM><ns0:OrderedQuantityInPrimaryUOM xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" unitCode="zPK">1</ns0:OrderedQuantityInPrimaryUOM><ns0:PrimaryUOMCode>zPK</ns0:PrimaryUOMCode><ns0:PrimaryUOM>PK</ns0:PrimaryUOM><ns0:RequestedFulfillmentOrganizationIdentifier>300000047274447</ns0:RequestedFulfillmentOrganizationIdentifier><ns0:RequestedFulfillmentOrganizationCode>002</ns0:RequestedFulfillmentOrganizationCode><ns0:RequestedFulfillmentOrganizationName>Atlanta</ns0:RequestedFulfillmentOrganizationName><ns0:CancelReasonCode xsi:nil="true"/><ns0:ShippingInstructions xsi:nil="true"/><ns0:PackingInstructions>CustomDOO_ShipOrderGenericProcess_Transportation_IDC</ns0:PackingInstructions><ns0:ScheduleShipDate>2021-03-31T23:59:59.0Z</ns0:ScheduleShipDate><ns0:ScheduleArrivalDate>2021-04-01T23:59:59.0Z</ns0:ScheduleArrivalDate><ns0:ShippingCarrierCode>300000047303468</ns0:ShippingCarrierCode><ns0:ShippingCarrier>DHL</ns0:ShippingCarrier><ns0:ShippingServiceLevelCode>1DA</ns0:ShippingServiceLevelCode><ns0:ShippingServiceLevel>Next day air</ns0:ShippingServiceLevel><ns0:ShippingModeCode>AIR</ns0:ShippingModeCode><ns0:ShippingMode>Air</ns0:ShippingMode><ns0:FreightTermsCode xsi:nil="true"/><ns0:FreightTerms xsi:nil="true"/><ns0:ShipToPartyIdentifier>300000219242093</ns0:ShipToPartyIdentifier><ns0:ShipToPartyName>University of Arkansas</ns0:ShipToPartyName><ns0:ShipToPartyNumber>796445</ns0:ShipToPartyNumber><ns0:ShipToPartyPersonFirstName xsi:nil="true"/><ns0:ShipToPartyPersonLastName xsi:nil="true"/><ns0:ShipToPartyPersonMiddleName xsi:nil="true"/><ns0:ShipToPartyPersonNameSuffix xsi:nil="true"/><ns0:ShipToPartyPersonTitle xsi:nil="true"/><ns0:ShipToPartySiteIdentifier>300000219242097</ns0:ShipToPartySiteIdentifier><ns0:ShipToAddress1>1 University of Arkansas </ns0:ShipToAddress1><ns0:ShipToAddress2 xsi:nil="true"/><ns0:ShipToAddress3 xsi:nil="true"/><ns0:ShipToAddress4 xsi:nil="true"/><ns0:ShipToCity>Fayetteville</ns0:ShipToCity><ns0:ShipToPostalCode xsi:nil="true"/><ns0:ShipToState>AR</ns0:ShipToState><ns0:ShipToProvince xsi:nil="true"/><ns0:ShipToCounty>Washington</ns0:ShipToCounty><ns0:ShipToCountry>US</ns0:ShipToCountry><ns0:ShipToPartyContactIdentifier>300000219242123</ns0:ShipToPartyContactIdentifier><ns0:ShipToPartyContactNumber>796446</ns0:ShipToPartyContactNumber><ns0:ShipToPartyContactName>Matt Waller</ns0:ShipToPartyContactName><ns0:ShipToContactFirstName>Matt</ns0:ShipToContactFirstName><ns0:ShipToContactLastName>Waller</ns0:ShipToContactLastName><ns0:ShipToContactMiddleName xsi:nil="true"/><ns0:ShipToContactNameSuffix xsi:nil="true"/><ns0:ShipToContactTitle>Dean</ns0:ShipToContactTitle><ns0:ShipToPartyContactOrigSystemReference>300000219242123</ns0:ShipToPartyContactOrigSystemReference><ns0:PreferredShipToContactPointIdentifier>300000219242126</ns0:PreferredShipToContactPointIdentifier><ns0:BillToPartyType>ORGANIZATION</ns0:BillToPartyType><ns0:BillToCustomerIdentifier>300000219242095</ns0:BillToCustomerIdentifier><ns0:BillToPartyIdentifier>300000219242093</ns0:BillToPartyIdentifier><ns0:BillToCustomerName>University of Arkansas</ns0:BillToCustomerName><ns0:BillToCustomerNumber>43117</ns0:BillToCustomerNumber><ns0:BillToAccountPersonFirstName xsi:nil="true"/><ns0:BillToAccountPersonLastName xsi:nil="true"/><ns0:BillToAccountPersonMiddleName xsi:nil="true"/><ns0:BillToAccountPersonNameSuffix xsi:nil="true"/><ns0:BillToAccountPersonTitle xsi:nil="true"/><ns0:BillToAccountSiteUseIdentifier>300000219242099</ns0:BillToAccountSiteUseIdentifier><ns0:BillToPartySiteIdentifier>300000219242097</ns0:BillToPartySiteIdentifier><ns0:BillToAddress1>1 University of Arkansas </ns0:BillToAddress1><ns0:BillToAddress2 xsi:nil="true"/><ns0:BillToAddress3 xsi:nil="true"/><ns0:BillToAddress4 xsi:nil="true"/><ns0:BillToCity>Fayetteville</ns0:BillToCity><ns0:BillToPostalCode xsi:nil="true"/><ns0:BillToState xsi:nil="true"/><ns0:BillToProvince xsi:nil="true"/><ns0:BillToCounty>Washington</ns0:BillToCounty><ns0:BillToCountry>US</ns0:BillToCountry><ns0:BillToAccountContactIdentifier xsi:nil="true"/><ns0:BillToPartyContactIdentifier xsi:nil="true"/><ns0:BillToAccountContactName xsi:nil="true"/><ns0:BillToAccountContactNumber xsi:nil="true"/><ns0:BillToAccountContactOrigSystemReference xsi:nil="true"/><ns0:BillToContactFirstName xsi:nil="true"/><ns0:BillToContactLastName xsi:nil="true"/><ns0:BillToContactMiddleName xsi:nil="true"/><ns0:BillToContactNameSuffix xsi:nil="true"/><ns0:BillToContactTitle xsi:nil="true"/><ns0:PreferredBillToContactPointIdentifier xsi:nil="true"/><ns0:UnitListPrice xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/">109</ns0:UnitListPrice><ns0:UnitSellingPrice xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/">109</ns0:UnitSellingPrice><ns0:LatestAcceptableShipDate xsi:nil="true"/><ns0:LatestAcceptableArrivalDate xsi:nil="true"/><ns0:FOBPointCode xsi:nil="true"/><ns0:LineNumber>1</ns0:LineNumber><ns0:ItemTypeCode>4</ns0:ItemTypeCode><ns0:ItemTypeName xsi:nil="true"/><ns0:ItemSubTypeCode>STANDARD</ns0:ItemSubTypeCode><ns0:ItemSubTypeName>Standard</ns0:ItemSubTypeName><ns0:FulfillLineIdentifier>300000220097454</ns0:FulfillLineIdentifier><ns0:FulfillLineNumber>1</ns0:FulfillLineNumber><ns0:ShippableFlag>true</ns0:ShippableFlag><ns0:HeaderIdentifier>300000220097446</ns0:HeaderIdentifier><ns0:TransactionLineTypeCode>ORA_BUY</ns0:TransactionLineTypeCode><ns0:TransactionLineType>Buy</ns0:TransactionLineType><ns0:ExtendedAmount xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/">109</ns0:ExtendedAmount><ns0:ParentFulfillLineIdentifier xsi:nil="true"/><ns0:RootParentFulfillLineIdentifier xsi:nil="true"/><ns0:SplitFromFlineIdentifier xsi:nil="true"/><ns0:ConfigInventoryItemIdentifier xsi:nil="true"/><ns0:FulfillmentOrganizationLocationId>300000047013190</ns0:FulfillmentOrganizationLocationId><ns0:FulfillmentOrganizationAddress1>3353 Peachtree Rd NE</ns0:FulfillmentOrganizationAddress1><ns0:FulfillmentOrganizationAddress2 xsi:nil="true"/><ns0:FulfillmentOrganizationAddress3 xsi:nil="true"/><ns0:FulfillmentOrganizationAddress4 xsi:nil="true"/><ns0:FulfillmentOrganizationCity>Atlanta</ns0:FulfillmentOrganizationCity><ns0:FulfillmentOrganizationPostalCode>30326</ns0:FulfillmentOrganizationPostalCode><ns0:FulfillmentOrganizationState>GA</ns0:FulfillmentOrganizationState><ns0:FulfillmentOrganizationProvince xsi:nil="true"/><ns0:FulfillmentOrganizationCounty>Fulton</ns0:FulfillmentOrganizationCounty><ns0:FulfillmentOrganizationCountry>US</ns0:FulfillmentOrganizationCountry><ns0:RequestedSupplierCode xsi:nil="true"/><ns0:RequestedSupplierName xsi:nil="true"/><ns0:RequestedSupplierNumber xsi:nil="true"/><ns0:RequestedSupplierSiteCode xsi:nil="true"/><ns0:SupplierAddressLine1 xsi:nil="true"/><ns0:SupplierAddressLine2 xsi:nil="true"/><ns0:SupplierAddressLine3 xsi:nil="true"/><ns0:SupplierAddressLine4 xsi:nil="true"/><ns0:SupplierAddressCity xsi:nil="true"/><ns0:SupplierAddressState xsi:nil="true"/><ns0:SupplierAddressZipCode xsi:nil="true"/><ns0:SupplierAddressProvince xsi:nil="true"/><ns0:SupplierAddressCounty xsi:nil="true"/><ns0:SupplierAddressCountry xsi:nil="true"/><ns0:ShipToPartyType>ORGANIZATION</ns0:ShipToPartyType><ns0:CancelReason xsi:nil="true"/><ns0:SubstitutionReason xsi:nil="true"/><ns0:CustomerProductNumber xsi:nil="true"/><ns0:CustomerProductDescription xsi:nil="true"/><ns0:InvoicingRule xsi:nil="true"/><ns0:AccountingRule xsi:nil="true"/><ns0:DemandClass xsi:nil="true"/><ns0:ReturnReason xsi:nil="true"/><ns0:PaymentTerms>30 Net</ns0:PaymentTerms><ns0:ShipmentPriority xsi:nil="true"/><ns0:InventoryOrganizationIdentifier>300000047274441</ns0:InventoryOrganizationIdentifier><ns0:InventoryOrganization>Operations</ns0:InventoryOrganization><ns0:InventoryOrganizationName>Operations</ns0:InventoryOrganizationName><ns0:TaxClassification xsi:nil="true"/><ns0:FulfillmentSplitReferenceLineNumber xsi:nil="true"/><ns0:FOBPoint xsi:nil="true"/><ns0:ConfigItemReference xsi:nil="true"/><ns0:ConfigInventoryItemNumber xsi:nil="true"/><ns0:ConfiguredInventoryItemDescription xsi:nil="true"/><ns0:BuyerFirstName xsi:nil="true"/><ns0:BuyerMiddleName xsi:nil="true"/><ns0:BuyerLastName xsi:nil="true"/><ns0:ProductNumber>MCK1167628</ns0:ProductNumber><ns0:ProductDescription>Honeywell Uvex™ Fog Eliminator Plus Cloths, pack of 100 - case of 8PK</ns0:ProductDescription><ns0:FulfillmentRequestIdentifier>300000220094810</ns0:FulfillmentRequestIdentifier><ns0:ShipToPartyLastUpdateDate>2021-03-04T19:52:05.701Z</ns0:ShipToPartyLastUpdateDate><ns0:ShipToPartySiteLastUpdateDate>2021-03-04T19:25:37.932Z</ns0:ShipToPartySiteLastUpdateDate><ns0:BillToPartyLastUpdateDate>2021-03-04T19:52:05.701Z</ns0:BillToPartyLastUpdateDate><ns0:BillToPartySiteLastUpdateDate>2021-03-04T19:25:37.932Z</ns0:BillToPartySiteLastUpdateDate><ns0:ShipSetName xsi:nil="true"/><ns0:OperationCode>CREATE</ns0:OperationCode><ns0:RequestedShipDate>2021-03-31T07:42:42.0Z</ns0:RequestedShipDate><ns0:RequestedArrivalDate xsi:nil="true"/><ns0:EarliestAcceptableShipDate xsi:nil="true"/><ns0:PartialShipAllowedFlag>true</ns0:PartialShipAllowedFlag><ns0:TransactionCategoryCode>ORDER</ns0:TransactionCategoryCode><ns0:ExtendedFulfillmentLineNumber>1</ns0:ExtendedFulfillmentLineNumber><ns0:DestinationShippingOrganizationName xsi:nil="true"/><ns0:DestinationShippingOrganizationCode xsi:nil="true"/><ns0:DestinationShippingOrganizationIdentifier xsi:nil="true"/><ns0:DestinationShippingLocationIdentifier xsi:nil="true"/><ns0:DestinationShippingAddressLine1 xsi:nil="true"/><ns0:DestinationShippingAddressLine2 xsi:nil="true"/><ns0:DestinationShippingAddressLine3 xsi:nil="true"/><ns0:DestinationShippingAddressLine4 xsi:nil="true"/><ns0:DestinationShippingAddressCity xsi:nil="true"/><ns0:DestinationShippingAddressState xsi:nil="true"/><ns0:DestinationShippingAddressPostalCode xsi:nil="true"/><ns0:DestinationShippingAddressProvince xsi:nil="true"/><ns0:DestinationShippingAddressCounty xsi:nil="true"/><ns0:DestinationShippingAddressCountry xsi:nil="true"/><ns0:UnreferencedReturnFlag>false</ns0:UnreferencedReturnFlag><ns0:CoveredProductIdentifier xsi:nil="true"/><ns0:CoveredProductNumber xsi:nil="true"/><ns0:CoveredProductDescription xsi:nil="true"/><ns0:CoveredCustomerProductId xsi:nil="true"/><ns0:CoveredCustomerProductNumber xsi:nil="true"/><ns0:CoveredCustomerProductDescription xsi:nil="true"/><ns0:CancellationEffectiveDate xsi:nil="true"/><ns0:CoveredProductSrcsysReference xsi:nil="true"/><ns0:SupplierSiteCode xsi:nil="true"/><ns0:SellingProfitCenterBusinessUnitIdentifier xsi:nil="true"/><ns0:SellingProfitCenterBusinessUnit xsi:nil="true"/><ns0:AdditionalOrderLineInformationCategories xmlns:ns3="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/fulfillLineContextsB/" xmlns:ns4="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/fulfillLineCategories/" xsi:type="ns4:j_FulfillLineEffDooFulfillLinesAddInfoprivate"><ns2:Category>DOO_FULFILL_LINES_ADD_INFO</ns2:Category><ns2:FulfillLineId>300000220097454</ns2:FulfillLineId></ns0:AdditionalOrderLineInformationCategories></ns0:OrchestrationOrderLine><ns0:AdditionalOrderInformationCategories xmlns:ns5="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/headerContextsB/" xmlns:ns6="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/headerCategories/" xsi:type="ns6:j_HeaderEffDooHeadersAddInfoprivate"><ns2:Category>DOO_HEADERS_ADD_INFO</ns2:Category><ns2:HeaderId>300000220097446</ns2:HeaderId></ns0:AdditionalOrderInformationCategories></ns3:result></ns0:getOrderFulfillmentRequestDetailsResponse></ns01:onEvent>

Sent to OTM after mapping

<nstrgmpr:publish xmlns:otm="http://xmlns.oracle.com/apps/otm/transmission/v6.4" xmlns:ns0="http://xmlns.oracle.com/cloud/adapter/Logistics/OTM_REQUEST/types" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:wsp="http://www.w3.org/ns/ws-policy" xmlns:wssutil="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:nsmpr0="http://xmlns.oracle.com/cloud/adapter/Logistics/OTM_REQUEST" xmlns:nsmpr1="http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/orderInformationService/" xmlns:nstrgmpr="http://xmlns.oracle.com/apps/otm/TransmissionService" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"><otm:Transmission><otm:TransmissionHeader><otm:AckSpec><otm:ComMethodGid><otm:Gid><otm:Xid>EMAIL</otm:Xid></otm:Gid></otm:ComMethodGid><otm:EmailAddress>[email protected]</otm:EmailAddress><otm:AckOption>YES</otm:AckOption></otm:AckSpec></otm:TransmissionHeader><otm:TransmissionBody><otm:GLogXMLElement><otm:Release><otm:ReleaseGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>300000220097454</otm:Xid></otm:Gid></otm:ReleaseGid><otm:TransactionCode>IU</otm:TransactionCode><otm:ReleaseHeader><otm:CommercialTerms/><otm:FlexFieldStrings><otm:Attribute20>1</otm:Attribute20></otm:FlexFieldStrings><otm:FlexFieldNumbers><otm:AttributeNumber10>300000000096992</otm:AttributeNumber10></otm:FlexFieldNumbers><otm:FlexFieldDates><otm:AttributeDate10><otm:GLogDate>20210331074529</otm:GLogDate></otm:AttributeDate10></otm:FlexFieldDates></otm:ReleaseHeader><otm:ShipFromLocationRef><otm:LocationRef><otm:LocationGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>002</otm:Xid></otm:Gid></otm:LocationGid></otm:LocationRef></otm:ShipFromLocationRef><otm:ShipToLocationRef><otm:LocationRef><otm:LocationGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>300000219242097</otm:Xid></otm:Gid></otm:LocationGid></otm:LocationRef></otm:ShipToLocationRef><otm:TimeWindow><otm:EarlyPickupDt><otm:GLogDate>20210331235959</otm:GLogDate></otm:EarlyPickupDt><otm:EarlyDeliveryDt><otm:GLogDate>20210401235959</otm:GLogDate></otm:EarlyDeliveryDt></otm:TimeWindow><otm:ReleaseLine><otm:ReleaseLineGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>300000220097454</otm:Xid></otm:Gid></otm:ReleaseLineGid><otm:PackagedItemRef><otm:PackagedItem><otm:Item><otm:ItemName>MCK1167628</otm:ItemName><otm:Description>Honeywell Uvex™ Fog Eliminator Plus Cloths, pack of 100 - case of 8PK</otm:Description></otm:Item></otm:PackagedItem><otm:PackagedItemGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>300000219241801</otm:Xid></otm:Gid></otm:PackagedItemGid></otm:PackagedItemRef><otm:ItemQuantity><otm:ItemTag1>PK</otm:ItemTag1><otm:PackagedItemCount>1</otm:PackagedItemCount></otm:ItemQuantity><otm:Remark><otm:RemarkQualifierGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>PACKING INSTRUCTIONS</otm:Xid></otm:Gid></otm:RemarkQualifierGid><otm:RemarkText>CustomDOO_ShipOrderGenericProcess_Transportation_IDC</otm:RemarkText></otm:Remark></otm:ReleaseLine><otm:ReleaseRefnum><otm:ReleaseRefnumQualifierGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>FULFILLMENT LINE NUMBER</otm:Xid></otm:Gid></otm:ReleaseRefnumQualifierGid><otm:ReleaseRefnumValue>1</otm:ReleaseRefnumValue></otm:ReleaseRefnum><otm:ReleaseRefnum><otm:ReleaseRefnumQualifierGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>ORDER LINE NUMBER</otm:Xid></otm:Gid></otm:ReleaseRefnumQualifierGid><otm:ReleaseRefnumValue>1</otm:ReleaseRefnumValue></otm:ReleaseRefnum><otm:ReleaseRefnum><otm:ReleaseRefnumQualifierGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>ORDER NUMBER</otm:Xid></otm:Gid></otm:ReleaseRefnumQualifierGid><otm:ReleaseRefnumValue>97586</otm:ReleaseRefnumValue></otm:ReleaseRefnum><otm:InvolvedParty><otm:InvolvedPartyQualifierGid><otm:Gid><otm:Xid>SOLD_TO</otm:Xid></otm:Gid></otm:InvolvedPartyQualifierGid><otm:ContactRef><otm:ContactGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>300000219242093</otm:Xid></otm:Gid></otm:ContactGid></otm:ContactRef><otm:ComMethodGid><otm:Gid><otm:Xid>BY CONTACT</otm:Xid></otm:Gid></otm:ComMethodGid></otm:InvolvedParty><otm:InvolvedParty><otm:InvolvedPartyQualifierGid><otm:Gid><otm:Xid>BILL_TO</otm:Xid></otm:Gid></otm:InvolvedPartyQualifierGid><otm:ContactRef><otm:ContactGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>300000219242095</otm:Xid></otm:Gid></otm:ContactGid></otm:ContactRef></otm:InvolvedParty><otm:InvolvedParty><otm:InvolvedPartyQualifierGid><otm:Gid><otm:Xid>ORDEROWNER</otm:Xid></otm:Gid></otm:InvolvedPartyQualifierGid><otm:ContactRef><otm:ContactGid><otm:Gid><otm:DomainName>GTMOP</otm:DomainName><otm:Xid>300000219242093</otm:Xid></otm:Gid></otm:ContactGid></otm:ContactRef><otm:ComMethodGid><otm:Gid><otm:Xid>BY CONTACT</otm:Xid></otm:Gid></otm:ComMethodGid></otm:InvolvedParty></otm:Release></otm:GLogXMLElement></otm:TransmissionBody></otm:Transmission></nstrgmpr:publish>

Acknowledgement Payload from OTM to OM Cloud

<nstrgmpr:processAcknowledgement xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:plnk="http://schemas.xmlsoap.org/ws/2003/05/partner-link/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:nsmpr0="http://xmlns.oracle.com/cloud/adapter/erp/OM_CALLBACK_SUC" xmlns:types="http://xmlns.oracle.com/apps/scm/doo/taskLayer/commonService/types/" xmlns:tns="http://xmlns.oracle.com/apps/scm/doo/taskLayer/commonService/" xmlns:nstrgmpr="http://xmlns.oracle.com/cloud/adapter/erp/OM_CALLBACK_SUC/types" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:errors="http://xmlns.oracle.com/adf/svc/errors/" xmlns:orafault="http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0"><nstrgmpr:fulfillmentRequestAcknowledgement><tns:FulfillmentRequestIdentifier>300000220094810</tns:FulfillmentRequestIdentifier><tns:RequestStatusCode>SUCCESS</tns:RequestStatusCode><tns:FulfillmentSystem>OPS</tns:FulfillmentSystem></nstrgmpr:fulfillmentRequestAcknowledgement></nstrgmpr:processAcknowledgement>

Integration Configurations

Download and upload the required IAR files from MOS Doc ID 2209248.1 to OIC.
Create CSF key (at https://(FADOAMIN/soa/composer) in OM Cloud with OIC credentials
update OIC connections SCM_CONNECTION and LOGISTICS_CONNECTION with OM host and OTM host respectively. ERP service Catalog url: https://(FADOMAIN)/fndAppCoreServices/ServiceCatalogService?wsdl EVENT catlog url https://(fadomain)/soa-infra
Modify the OTM Domain to your target Domain in all OIC mappings.
Create master data on both sides OM and OTM for Customer, address, location, item UOM, etc
Add Roles and Privileges
Create Routing Rules in OM
Create Connector in OM to call OIC process

You may get error : Error :The caller is not authorized to call this service for IntegrationContextCode DOO_TradeCompliance

To address that add Privileges/ Roles to the OM user

-Manage Web Service Interface to Transportation Data for Sales Order
-Manage Orchestration Order Trade Compliance Interface Web Service
-Update Orchestration Order Fulfillment Line Web Service
-Manage Orchestration Order Fulfillment Interface Web Service

https://docs.oracle.com/en/cloud/saas/supply-chain-management/23a/oessc/orderfulfillmentresponseservice-d27777e5477.html#orderfulfillmentresponseservice

fscmService/OrderFulfillmentResponseService?WSDL

OTM OM Integration ( Return from OTM)

Expected Result after OTM_OM OIC Flow Completes

Once OTM OM flow completes successfully you should be able to see the order status in fusion order management Status as Transportation Planning Completed.

The Fulfillment response from OTM to OM

<nstrgmpr:processFulfillmentResponseResponse xmlns="http://schemas.xmlsoap.org/soap/envelope/" xmlns:nstrgmpr="http://xmlns.oracle.com/cloud/adapter/erp/OM_REQUEST/types" xmlns:ns0="http://xmlns.oracle.com/apps/scm/doo/taskLayer/commonService/types/"><nstrgmpr:result xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns1="http://xmlns.oracle.com/apps/scm/doo/taskLayer/commonService/" xsi:type="ns1:ResponseProcessingHeader"><ns1:FulfillmentSystemResponseIdentifier xsi:nil="true"/><ns1:OverallStatusCode>SUCCESS</ns1:OverallStatusCode><ns1:ErrorMessageName xsi:nil="true"/><ns1:ErrorMessageText xsi:nil="true"/><ns1:ResponseProcessingFulfillLine><ns1:OrderNumber>97586</ns1:OrderNumber><ns1:LineNumber xsi:nil="true"/><ns1:FulfillLineNumber>1</ns1:FulfillLineNumber><ns1:FulfillLineIdentifier>300000220097454</ns1:FulfillLineIdentifier><ns1:ExtendedFulfillmentLineNumber xsi:nil="true"/><ns1:ExternalInteractionKey xsi:nil="true"/><ns1:FulfillmentSystemInteractionIdentifier xsi:nil="true"/><ns1:StatusCode>SUCCESS</ns1:StatusCode><ns1:FulfillmentSplitReferenceIdentifier xsi:nil="true"/><ns1:SplitFromExternalInteractionKey xsi:nil="true"/><ns1:TaskInstanceStatusCode>DOO_TP_PLANNED</ns1:TaskInstanceStatusCode></ns1:ResponseProcessingFulfillLine></nstrgmpr:result></nstrgmpr:processFulfillmentResponseResponse>

OM GTM Integration

set-order-management-parameter-for-trade-complaince

Payload Sent to GTM

<ns01:onEvent xmlns:ns01="http://xmlns.oracle.com/cloud/adapter/erp/OM_REQUEST/types"><ns0:getOrderFulfillmentRequestDetailsResponse xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns0="http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/orderFulfillmentRequestService/types/" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd" xmlns:wsa="http://www.w3.org/2005/08/addressing"><ns3:result xmlns:ns0="http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/orderInformationService/" xmlns:ns1="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns2="http://xmlns.oracle.com/apps/scm/doo/processOrder/model/" xmlns:ns3="http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/orderFulfillmentRequestService/types/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns0:OrchestrationOrder"><ns0:SourceTransactionIdentifier>300000220097446</ns0:SourceTransactionIdentifier><ns0:SourceTransactionSystemIdentifier>300000000096992</ns0:SourceTransactionSystemIdentifier><ns0:SourceTransactionSystemName>Oracle Fusion Order Orchestration And Planning</ns0:SourceTransactionSystemName><ns0:SourceTransactionSystemCode>OPS</ns0:SourceTransactionSystemCode><ns0:TargetSystemName>Oracle Fusion Order Orchestration And Planning</ns0:TargetSystemName><ns0:TargetSystemCode>OPS</ns0:TargetSystemCode><ns0:TargetSystemIdentifier>300000000096992</ns0:TargetSystemIdentifier><ns0:FusionSystemName>Oracle Fusion Order Orchestration And Planning</ns0:FusionSystemName><ns0:FusionSystemCode>OPS</ns0:FusionSystemCode><ns0:FusionSystemIdentifier>300000000096992</ns0:FusionSystemIdentifier><ns0:SourceTransactionNumber>97586</ns0:SourceTransactionNumber><ns0:BuyingPartyIdentifier>300000219242093</ns0:BuyingPartyIdentifier><ns0:BuyingPartyName>University of Arkansas</ns0:BuyingPartyName><ns0:BuyingPartyNumber>796445</ns0:BuyingPartyNumber><ns0:BuyingPartyPersonFirstName xsi:nil="true"/><ns0:BuyingPartyPersonLastName xsi:nil="true"/><ns0:BuyingPartyPersonMiddleName xsi:nil="true"/><ns0:BuyingPartyPersonNameSuffix xsi:nil="true"/><ns0:BuyingPartyPersonTitle xsi:nil="true"/><ns0:BuyingPartyContactIdentifier>300000219242123</ns0:BuyingPartyContactIdentifier><ns0:BuyingPartyContactName>Matt Waller</ns0:BuyingPartyContactName><ns0:BuyingPartyContactNumber>796446</ns0:BuyingPartyContactNumber><ns0:BuyingPartyContactFirstName>Matt</ns0:BuyingPartyContactFirstName><ns0:BuyingPartyContactLastName>Waller</ns0:BuyingPartyContactLastName><ns0:BuyingPartyContactMiddleName xsi:nil="true"/><ns0:BuyingPartyContactNameSuffix xsi:nil="true"/><ns0:BuyingPartyContactTitle>Dean</ns0:BuyingPartyContactTitle><ns0:PreferredSoldToContactPointIdentifier>300000219242126</ns0:PreferredSoldToContactPointIdentifier><ns0:PreferredSoldToContactPointOrigSystemReference xsi:nil="true"/><ns0:CustomerPONumber xsi:nil="true"/><ns0:TransactionalCurrencyCode>USD</ns0:TransactionalCurrencyCode><ns0:TransactionalCurrencyName>US Dollar</ns0:TransactionalCurrencyName><ns0:TransactionOn>2021-03-31T07:42:42.0Z</ns0:TransactionOn><ns0:RequestingBusinessUnitIdentifier>300000046987012</ns0:RequestingBusinessUnitIdentifier><ns0:RequestingBusinessUnitName>US1 Business Unit</ns0:RequestingBusinessUnitName><ns0:TransactionDocumentTypeCode xsi:nil="true"/><ns0:TransactionDocumentTypeName xsi:nil="true"/><ns0:RequestingLegalUnitIdentifier>300000046973970</ns0:RequestingLegalUnitIdentifier><ns0:RequestingLegalUnit xsi:nil="true"/><ns0:HeaderIdentifier>300000220097446</ns0:HeaderIdentifier><ns0:OrderNumber>97586</ns0:OrderNumber><ns0:ChangeVersionNumber>1</ns0:ChangeVersionNumber><ns0:SourceTransactionRevisionNumber>1</ns0:SourceTransactionRevisionNumber><ns0:SubmittedFlag>false</ns0:SubmittedFlag><ns0:BuyingPartyType>ORGANIZATION</ns0:BuyingPartyType><ns0:BuyingPartyLastUpdateDate>2021-03-04T19:52:05.701Z</ns0:BuyingPartyLastUpdateDate><ns0:OperationCode>CREATE</ns0:OperationCode><ns0:TransactionTypeCode xsi:nil="true"/><ns0:TransactionType xsi:nil="true"/><ns0:PartialShipAllowedFlag>true</ns0:PartialShipAllowedFlag><ns0:OrchestrationOrderLine><ns0:SourceTransactionIdentifier>300000220097446</ns0:SourceTransactionIdentifier><ns0:SourceTransactionLineIdentifier>300000220097463</ns0:SourceTransactionLineIdentifier><ns0:SourceTransactionScheduleIdentifier>1</ns0:SourceTransactionScheduleIdentifier><ns0:SourceTransactionLineNumber>1</ns0:SourceTransactionLineNumber><ns0:SourceTransactionScheduleNumber>1</ns0:SourceTransactionScheduleNumber><ns0:SourceTransactionSystem>OPS</ns0:SourceTransactionSystem><ns0:SourceTransactionNumber>97586</ns0:SourceTransactionNumber><ns0:ProductIdentifier>300000219241801</ns0:ProductIdentifier><ns0:OrderedQuantity xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" unitCode="zPK">1</ns0:OrderedQuantity><ns0:OrderedUOMCode>zPK</ns0:OrderedUOMCode><ns0:OrderedUOM>PK</ns0:OrderedUOM><ns0:OrderedQuantityInPrimaryUOM xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/" unitCode="zPK">1</ns0:OrderedQuantityInPrimaryUOM><ns0:PrimaryUOMCode>zPK</ns0:PrimaryUOMCode><ns0:PrimaryUOM>PK</ns0:PrimaryUOM><ns0:RequestedFulfillmentOrganizationIdentifier xsi:nil="true"/><ns0:RequestedFulfillmentOrganizationCode xsi:nil="true"/><ns0:RequestedFulfillmentOrganizationName xsi:nil="true"/><ns0:CancelReasonCode xsi:nil="true"/><ns0:ShippingInstructions xsi:nil="true"/><ns0:PackingInstructions>CustomDOO_ShipOrderGenericProcess_Transportation_IDC</ns0:PackingInstructions><ns0:ScheduleShipDate xsi:nil="true"/><ns0:ScheduleArrivalDate xsi:nil="true"/><ns0:ShippingCarrierCode xsi:nil="true"/><ns0:ShippingCarrier xsi:nil="true"/><ns0:ShippingServiceLevelCode xsi:nil="true"/><ns0:ShippingServiceLevel xsi:nil="true"/><ns0:ShippingModeCode xsi:nil="true"/><ns0:ShippingMode xsi:nil="true"/><ns0:FreightTermsCode xsi:nil="true"/><ns0:FreightTerms xsi:nil="true"/><ns0:ShipToPartyIdentifier>300000219242093</ns0:ShipToPartyIdentifier><ns0:ShipToPartyName>University of Arkansas</ns0:ShipToPartyName><ns0:ShipToPartyNumber>796445</ns0:ShipToPartyNumber><ns0:ShipToPartyPersonFirstName xsi:nil="true"/><ns0:ShipToPartyPersonLastName xsi:nil="true"/><ns0:ShipToPartyPersonMiddleName xsi:nil="true"/><ns0:ShipToPartyPersonNameSuffix xsi:nil="true"/><ns0:ShipToPartyPersonTitle xsi:nil="true"/><ns0:ShipToPartySiteIdentifier>300000219242097</ns0:ShipToPartySiteIdentifier><ns0:ShipToAddress1>1 University of Arkansas </ns0:ShipToAddress1><ns0:ShipToAddress2 xsi:nil="true"/><ns0:ShipToAddress3 xsi:nil="true"/><ns0:ShipToAddress4 xsi:nil="true"/><ns0:ShipToCity>Fayetteville</ns0:ShipToCity><ns0:ShipToPostalCode xsi:nil="true"/><ns0:ShipToState>AR</ns0:ShipToState><ns0:ShipToProvince xsi:nil="true"/><ns0:ShipToCounty>Washington</ns0:ShipToCounty><ns0:ShipToCountry>US</ns0:ShipToCountry><ns0:ShipToPartyContactIdentifier>300000219242123</ns0:ShipToPartyContactIdentifier><ns0:ShipToPartyContactNumber>796446</ns0:ShipToPartyContactNumber><ns0:ShipToPartyContactName>Matt Waller</ns0:ShipToPartyContactName><ns0:ShipToContactFirstName>Matt</ns0:ShipToContactFirstName><ns0:ShipToContactLastName>Waller</ns0:ShipToContactLastName><ns0:ShipToContactMiddleName xsi:nil="true"/><ns0:ShipToContactNameSuffix xsi:nil="true"/><ns0:ShipToContactTitle>Dean</ns0:ShipToContactTitle><ns0:ShipToPartyContactOrigSystemReference>300000219242123</ns0:ShipToPartyContactOrigSystemReference><ns0:PreferredShipToContactPointIdentifier>300000219242126</ns0:PreferredShipToContactPointIdentifier><ns0:BillToPartyType>ORGANIZATION</ns0:BillToPartyType><ns0:BillToCustomerIdentifier>300000219242095</ns0:BillToCustomerIdentifier><ns0:BillToPartyIdentifier>300000219242093</ns0:BillToPartyIdentifier><ns0:BillToCustomerName>University of Arkansas</ns0:BillToCustomerName><ns0:BillToCustomerNumber>43117</ns0:BillToCustomerNumber><ns0:BillToAccountPersonFirstName xsi:nil="true"/><ns0:BillToAccountPersonLastName xsi:nil="true"/><ns0:BillToAccountPersonMiddleName xsi:nil="true"/><ns0:BillToAccountPersonNameSuffix xsi:nil="true"/><ns0:BillToAccountPersonTitle xsi:nil="true"/><ns0:BillToAccountSiteUseIdentifier>300000219242099</ns0:BillToAccountSiteUseIdentifier><ns0:BillToPartySiteIdentifier>300000219242097</ns0:BillToPartySiteIdentifier><ns0:BillToAddress1>1 University of Arkansas </ns0:BillToAddress1><ns0:BillToAddress2 xsi:nil="true"/><ns0:BillToAddress3 xsi:nil="true"/><ns0:BillToAddress4 xsi:nil="true"/><ns0:BillToCity>Fayetteville</ns0:BillToCity><ns0:BillToPostalCode xsi:nil="true"/><ns0:BillToState xsi:nil="true"/><ns0:BillToProvince xsi:nil="true"/><ns0:BillToCounty>Washington</ns0:BillToCounty><ns0:BillToCountry>US</ns0:BillToCountry><ns0:BillToAccountContactIdentifier xsi:nil="true"/><ns0:BillToPartyContactIdentifier xsi:nil="true"/><ns0:BillToAccountContactName xsi:nil="true"/><ns0:BillToAccountContactNumber xsi:nil="true"/><ns0:BillToAccountContactOrigSystemReference xsi:nil="true"/><ns0:BillToContactFirstName xsi:nil="true"/><ns0:BillToContactLastName xsi:nil="true"/><ns0:BillToContactMiddleName xsi:nil="true"/><ns0:BillToContactNameSuffix xsi:nil="true"/><ns0:BillToContactTitle xsi:nil="true"/><ns0:PreferredBillToContactPointIdentifier xsi:nil="true"/><ns0:UnitListPrice xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/">109</ns0:UnitListPrice><ns0:UnitSellingPrice xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/">109</ns0:UnitSellingPrice><ns0:LatestAcceptableShipDate xsi:nil="true"/><ns0:LatestAcceptableArrivalDate xsi:nil="true"/><ns0:FOBPointCode xsi:nil="true"/><ns0:LineNumber>1</ns0:LineNumber><ns0:ItemTypeCode>4</ns0:ItemTypeCode><ns0:ItemTypeName xsi:nil="true"/><ns0:ItemSubTypeCode>STANDARD</ns0:ItemSubTypeCode><ns0:ItemSubTypeName>Standard</ns0:ItemSubTypeName><ns0:FulfillLineIdentifier>300000220097454</ns0:FulfillLineIdentifier><ns0:FulfillLineNumber>1</ns0:FulfillLineNumber><ns0:ShippableFlag>true</ns0:ShippableFlag><ns0:HeaderIdentifier>300000220097446</ns0:HeaderIdentifier><ns0:TransactionLineTypeCode>ORA_BUY</ns0:TransactionLineTypeCode><ns0:TransactionLineType>Buy</ns0:TransactionLineType><ns0:ExtendedAmount xmlns:tns="http://xmlns.oracle.com/adf/svc/errors/">109</ns0:ExtendedAmount><ns0:ParentFulfillLineIdentifier xsi:nil="true"/><ns0:RootParentFulfillLineIdentifier xsi:nil="true"/><ns0:SplitFromFlineIdentifier xsi:nil="true"/><ns0:ConfigInventoryItemIdentifier xsi:nil="true"/><ns0:FulfillmentOrganizationLocationId xsi:nil="true"/><ns0:FulfillmentOrganizationAddress1 xsi:nil="true"/><ns0:FulfillmentOrganizationAddress2 xsi:nil="true"/><ns0:FulfillmentOrganizationAddress3 xsi:nil="true"/><ns0:FulfillmentOrganizationAddress4 xsi:nil="true"/><ns0:FulfillmentOrganizationCity xsi:nil="true"/><ns0:FulfillmentOrganizationPostalCode xsi:nil="true"/><ns0:FulfillmentOrganizationState xsi:nil="true"/><ns0:FulfillmentOrganizationProvince xsi:nil="true"/><ns0:FulfillmentOrganizationCounty xsi:nil="true"/><ns0:FulfillmentOrganizationCountry xsi:nil="true"/><ns0:RequestedSupplierCode xsi:nil="true"/><ns0:RequestedSupplierName xsi:nil="true"/><ns0:RequestedSupplierNumber xsi:nil="true"/><ns0:RequestedSupplierSiteCode xsi:nil="true"/><ns0:SupplierAddressLine1 xsi:nil="true"/><ns0:SupplierAddressLine2 xsi:nil="true"/><ns0:SupplierAddressLine3 xsi:nil="true"/><ns0:SupplierAddressLine4 xsi:nil="true"/><ns0:SupplierAddressCity xsi:nil="true"/><ns0:SupplierAddressState xsi:nil="true"/><ns0:SupplierAddressZipCode xsi:nil="true"/><ns0:SupplierAddressProvince xsi:nil="true"/><ns0:SupplierAddressCounty xsi:nil="true"/><ns0:SupplierAddressCountry xsi:nil="true"/><ns0:ShipToPartyType>ORGANIZATION</ns0:ShipToPartyType><ns0:CancelReason xsi:nil="true"/><ns0:SubstitutionReason xsi:nil="true"/><ns0:CustomerProductNumber xsi:nil="true"/><ns0:CustomerProductDescription xsi:nil="true"/><ns0:InvoicingRule xsi:nil="true"/><ns0:AccountingRule xsi:nil="true"/><ns0:DemandClass xsi:nil="true"/><ns0:ReturnReason xsi:nil="true"/><ns0:PaymentTerms>30 Net</ns0:PaymentTerms><ns0:ShipmentPriority xsi:nil="true"/><ns0:InventoryOrganizationIdentifier>300000047274441</ns0:InventoryOrganizationIdentifier><ns0:InventoryOrganization>Operations</ns0:InventoryOrganization><ns0:InventoryOrganizationName>Operations</ns0:InventoryOrganizationName><ns0:TaxClassification xsi:nil="true"/><ns0:FulfillmentSplitReferenceLineNumber xsi:nil="true"/><ns0:FOBPoint xsi:nil="true"/><ns0:ConfigItemReference xsi:nil="true"/><ns0:ConfigInventoryItemNumber xsi:nil="true"/><ns0:ConfiguredInventoryItemDescription xsi:nil="true"/><ns0:BuyerFirstName xsi:nil="true"/><ns0:BuyerMiddleName xsi:nil="true"/><ns0:BuyerLastName xsi:nil="true"/><ns0:ProductNumber>MCK1167628</ns0:ProductNumber><ns0:ProductDescription>Honeywell Uvex™ Fog Eliminator Plus Cloths, pack of 100 - case of 8PK</ns0:ProductDescription><ns0:FulfillmentRequestIdentifier>300000220097509</ns0:FulfillmentRequestIdentifier><ns0:ShipToPartyLastUpdateDate>2021-03-04T19:52:05.701Z</ns0:ShipToPartyLastUpdateDate><ns0:ShipToPartySiteLastUpdateDate>2021-03-04T19:25:37.932Z</ns0:ShipToPartySiteLastUpdateDate><ns0:BillToPartyLastUpdateDate>2021-03-04T19:52:05.701Z</ns0:BillToPartyLastUpdateDate><ns0:BillToPartySiteLastUpdateDate>2021-03-04T19:25:37.932Z</ns0:BillToPartySiteLastUpdateDate><ns0:ShipSetName xsi:nil="true"/><ns0:OperationCode xsi:nil="true"/><ns0:RequestedShipDate>2021-03-31T07:42:42.0Z</ns0:RequestedShipDate><ns0:RequestedArrivalDate xsi:nil="true"/><ns0:EarliestAcceptableShipDate xsi:nil="true"/><ns0:PartialShipAllowedFlag>true</ns0:PartialShipAllowedFlag><ns0:TransactionCategoryCode>ORDER</ns0:TransactionCategoryCode><ns0:ExtendedFulfillmentLineNumber xsi:nil="true"/><ns0:DestinationShippingOrganizationName xsi:nil="true"/><ns0:DestinationShippingOrganizationCode xsi:nil="true"/><ns0:DestinationShippingOrganizationIdentifier xsi:nil="true"/><ns0:DestinationShippingLocationIdentifier xsi:nil="true"/><ns0:DestinationShippingAddressLine1 xsi:nil="true"/><ns0:DestinationShippingAddressLine2 xsi:nil="true"/><ns0:DestinationShippingAddressLine3 xsi:nil="true"/><ns0:DestinationShippingAddressLine4 xsi:nil="true"/><ns0:DestinationShippingAddressCity xsi:nil="true"/><ns0:DestinationShippingAddressState xsi:nil="true"/><ns0:DestinationShippingAddressPostalCode xsi:nil="true"/><ns0:DestinationShippingAddressProvince xsi:nil="true"/><ns0:DestinationShippingAddressCounty xsi:nil="true"/><ns0:DestinationShippingAddressCountry xsi:nil="true"/><ns0:UnreferencedReturnFlag>false</ns0:UnreferencedReturnFlag><ns0:CoveredProductIdentifier xsi:nil="true"/><ns0:CoveredProductNumber xsi:nil="true"/><ns0:CoveredProductDescription xsi:nil="true"/><ns0:CoveredCustomerProductId xsi:nil="true"/><ns0:CoveredCustomerProductNumber xsi:nil="true"/><ns0:CoveredCustomerProductDescription xsi:nil="true"/><ns0:CancellationEffectiveDate xsi:nil="true"/><ns0:CoveredProductSrcsysReference xsi:nil="true"/><ns0:SupplierSiteCode xsi:nil="true"/><ns0:SellingProfitCenterBusinessUnitIdentifier xsi:nil="true"/><ns0:SellingProfitCenterBusinessUnit xsi:nil="true"/><ns0:AdditionalOrderLineInformationCategories xmlns:ns3="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/fulfillLineContextsB/" xmlns:ns4="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/fulfillLineCategories/" xsi:type="ns4:j_FulfillLineEffDooFulfillLinesAddInfoprivate"><ns2:Category>DOO_FULFILL_LINES_ADD_INFO</ns2:Category><ns2:FulfillLineId>300000220097454</ns2:FulfillLineId></ns0:AdditionalOrderLineInformationCategories></ns0:OrchestrationOrderLine><ns0:AdditionalOrderInformationCategories xmlns:ns5="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/headerContextsB/" xmlns:ns6="http://xmlns.oracle.com/apps/scm/doo/processOrder/flex/headerCategories/" xsi:type="ns6:j_HeaderEffDooHeadersAddInfoprivate"><ns2:Category>DOO_HEADERS_ADD_INFO</ns2:Category><ns2:HeaderId>300000220097446</ns2:HeaderId></ns0:AdditionalOrderInformationCategories></ns3:result></ns0:getOrderFulfillmentRequestDetailsResponse></ns01:onEvent>

Process acknowledgement

<nstrgmpr:processAcknowledgement xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:plnk="http://schemas.xmlsoap.org/ws/2003/05/partner-link/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:nsmpr0="http://xmlns.oracle.com/cloud/adapter/erp/OM_CALLBACK_SUC" xmlns:types="http://xmlns.oracle.com/apps/scm/doo/taskLayer/commonService/types/" xmlns:tns="http://xmlns.oracle.com/apps/scm/doo/taskLayer/commonService/" xmlns:nstrgmpr="http://xmlns.oracle.com/cloud/adapter/erp/OM_CALLBACK_SUC/types" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:errors="http://xmlns.oracle.com/adf/svc/errors/" xmlns:orafault="http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0"><nstrgmpr:fulfillmentRequestAcknowledgement><tns:FulfillmentRequestIdentifier>300000220097509</tns:FulfillmentRequestIdentifier><tns:RequestStatusCode>"SUCCESS"</tns:RequestStatusCode><tns:FulfillmentSystem>Oracle Fusion Order Orchestration And Planning</tns:FulfillmentSystem></nstrgmpr:fulfillmentRequestAcknowledgement></nstrgmpr:processAcknowledgement>

GTM_OM Return

Setup Out XML profiles

Setup Out XML profiles in GTM External system configuration to GTM_MIN from default GLOG_MIN. This would send the required GTM Transaction elements to OIC.

GTM Response

<nstrgmpr:processFulfillmentResponse xmlns:ns1="http://xmlns.oracle.com/cloud/adapter/erp/OM_REQUEST" xmlns:plnk="http://schemas.xmlsoap.org/ws/2003/05/partner-link/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:types="http://xmlns.oracle.com/apps/scm/doo/taskLayer/commonService/types/" xmlns:nstrgdfl="http://xmlns.oracle.com/adf/svc/metadata/" xmlns:tns="http://xmlns.oracle.com/apps/scm/doo/taskLayer/commonService/" xmlns:nstrgmpr="http://xmlns.oracle.com/cloud/adapter/erp/OM_REQUEST/types" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:errors="http://xmlns.oracle.com/adf/svc/errors/" xmlns:orafault="http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0" xmlns="http://schemas.xmlsoap.org/soap/envelope/"><nstrgmpr:responseMessageHeader><tns:IntegrationContextCode>DOO_TradeCompliance</tns:IntegrationContextCode><tns:FulfillmentSystemResponseIdentifier>208327</tns:FulfillmentSystemResponseIdentifier><tns:TradeComplianceScreeningResultCode>ORA_PASSED</tns:TradeComplianceScreeningResultCode></nstrgmpr:responseMessageHeader><nstrgmpr:fulfillLineList><tns:OrderNumber>97586</tns:OrderNumber><tns:FulfillLineIdentifier>300000220097454</tns:FulfillLineIdentifier><tns:TradeComplianceScreeningResultCode>ORA_PASSED</tns:TradeComplianceScreeningResultCode><tns:TaskInstanceStatusCode>ORA_PASSED</tns:TaskInstanceStatusCode><tns:TradeComplianceScreeningDate>2021-03-31T07:44:21.058Z</tns:TradeComplianceScreeningDate><tns:FulfillmentDetail><tns:TradeComplianceTypeCode>ORA_RESTRICTED_PARTY</tns:TradeComplianceTypeCode><tns:TradeComplianceScreeningResultCode>ORA_PASSED</tns:TradeComplianceScreeningResultCode></tns:FulfillmentDetail></nstrgmpr:fulfillLineList></nstrgmpr:processFulfillmentResponse>

For multiple trade compliance checks FulfillmentDetail element will be repeating

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/scm/doo/taskLayer/commonService/types/" xmlns:com="http://xmlns.oracle.com/apps/scm/doo/taskLayer/commonService/" xmlns:mod="http://xmlns.oracle.com/apps/scm/doo/processOrder/model/">
   <soapenv:Header/>
   <soapenv:Body>
    <typ:processFulfillmentResponse>
     <typ:responseMessageHeader>
		<com:IntegrationContextCode>DOO_TradeCompliance</com:IntegrationContextCode>
		<com:FulfillmentSystemResponseIdentifier>2236546</com:FulfillmentSystemResponseIdentifier>
		<com:TradeComplianceScreeningResultCode>ORA_PASSED</com:TradeComplianceScreeningResultCode>
	</typ:responseMessageHeader>
	<typ:fulfillLineList>
		<com:OrderNumber>97447</com:OrderNumber>
		<com:FulfillLineIdentifier>300000223149424</com:FulfillLineIdentifier>
		<com:TradeComplianceScreeningResultCode>ORA_PASSED</com:TradeComplianceScreeningResultCode>
		<com:TaskInstanceStatusCode>ORA_PASSED</com:TaskInstanceStatusCode>
		<com:TradeComplianceScreeningDate>2021-05-19T20:07:02.414Z</com:TradeComplianceScreeningDate>
	<com:FulfillmentDetail>
		<com:TradeComplianceTypeCode>ORA_TRADE_CONTROL</com:TradeComplianceTypeCode>
		<com:TradeComplianceScreeningResultCode>ORA_PASSED</com:TradeComplianceScreeningResultCode>
	</com:FulfillmentDetail>
	<com:FulfillmentDetail>
		<com:TradeComplianceTypeCode>ORA_RESTRICTED_PARTY</com:TradeComplianceTypeCode>
		<com:TradeComplianceScreeningResultCode>ORA_PASSED</com:TradeComplianceScreeningResultCode>
	</com:FulfillmentDetail>
	</typ:fulfillLineList>
      </typ:processFulfillmentResponse>
   </soapenv:Body>
</soapenv:Envelope>

OTM WSH Integration

Once OTM WSH integration completes shipment records from OTM will be inserted into fusion tables

WSH_DEL_DETAILS_INTERFACE and

WSH_DELIVERY_DETAILS.

Then we need to run the Receive shipment Request ESS Job

Response from OTM to WSH Interface.

Request to Target Service - payload(post-mapping) <nstrgmpr:processBatchShipmentRequestOrder xmlns:plnk="http://schemas.xmlsoap.org/ws/2003/05/partner-link/" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/" xmlns:nsmpr0="http://xmlns.oracle.com/cloud/adapter/erp/GetShipmentFromOTM_REQUEST" xmlns:nsmpr1="http://xmlns.oracle.com/apps/scm/shipping/shipConfirm/shipmentRequests/shipmentRequestServiceV2/" xmlns:types="http://xmlns.oracle.com/apps/scm/shipping/shipConfirm/deliveries/shipmentService/types/" xmlns:tns="http://xmlns.oracle.com/apps/scm/shipping/shipConfirm/deliveries/shipmentService/" xmlns:nstrgmpr="http://xmlns.oracle.com/cloud/adapter/erp/GetShipmentFromOTM_REQUEST/types" xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:errors="http://xmlns.oracle.com/adf/svc/errors/" xmlns:orafault="http://xmlns.oracle.com/oracleas/schema/oracle-fault-11_0" xmlns="http://schemas.xmlsoap.org/soap/envelope/"><nstrgmpr:changeOperation>Create</nstrgmpr:changeOperation><nstrgmpr:batchShipmentRequestOrder><nsmpr1:ActionType>TPUPDATE</nsmpr1:ActionType><nsmpr1:SourceDocumentType>SALES_ORDER</nsmpr1:SourceDocumentType><nsmpr1:SourceSystemId>300000000096992</nsmpr1:SourceSystemId><nsmpr1:SourceHeaderNumber>97586</nsmpr1:SourceHeaderNumber><nsmpr1:ShipmentRequestOrderLine><nsmpr1:LineActionType>TPUPDATE</nsmpr1:LineActionType><nsmpr1:SourceLineNumber>1</nsmpr1:SourceLineNumber><nsmpr1:SourceShipmentNumber>1.1.</nsmpr1:SourceShipmentNumber><nsmpr1:OrderedQuantity>1</nsmpr1:OrderedQuantity><nsmpr1:OrderedQuantityUOMName>PK</nsmpr1:OrderedQuantityUOMName><nsmpr1:CarrierPartyName/><nsmpr1:ServiceLevel/><nsmpr1:ModeOfTransport/><nsmpr1:DateScheduled>2021-03-31T23:59:59Z</nsmpr1:DateScheduled><nsmpr1:TransportationShipment>99192339</nsmpr1:TransportationShipment><nsmpr1:InitialDestinationLocationId/><nsmpr1:TransportationShipmentLine>10153605##1</nsmpr1:TransportationShipmentLine><nsmpr1:TransportationPlanningDate/></nsmpr1:ShipmentRequestOrderLine></nstrgmpr:batchShipmentRequestOrder></nstrgmpr:processBatchShipmentRequestOrder>

Run Scheduled process ‘Receive Shipment Request’

To receive the shipment from interface to fusion shipping .

After request completes successfully

Navigate to: Inventory > Manage Shipment Lines > Query for order and check transportation planning status.

Enter quantity and Ship Confirm. After some time the order line status will be shipped

The transportation planning status should be same as order line status and should have same shipping method from OTM.

Incase of ESS job going in error/ warning , check the interface

inventoryManagement > Show Tasks > Select Shipments > Manage Shipment Message Interface >

Download the ADFDI excel > Login with fusion admin use > Enter Query Fields like creation date > hit search from menu bar.

The records with errors will show up with error message.

WSDL for Shipment interface

/fscmService/ShipmentRequestServiceV2?WSDL

Useful SQLs to check Shipping Interface

select * from fusion.WSH_DEL_DETAILS_INTERFACE where source_header_number =’97586′
select * from fusion.WSH_DELIVERY_DETAILS where source_header_number= ‘97586’
select * from fusion.WSH_NEW_DELIVERIES order by creation_date desc
select * from fusion.WSH_NEW_DEL_INTERFACE order by creation_date desc
select * from WSH_INTERFACE_ERRORS order by creation_date desc

<typ:changeOperation>Create</typ:changeOperation>
<typ:batchShipmentRequestOrder>
    <ship:ActionType>TPUPDATE</ship:ActionType>
    <ship:SourceDocumentType>SALES_ORDER</ship:SourceDocumentType>
    <ship:SourceSystemId>300000000096992</ship:SourceSystemId>
    <ship:SourceHeaderNumber>97580</ship:SourceHeaderNumber>
    <ship:ShipmentRequestOrderLine>
        <ship:LineActionType>TPUPDATE</ship:LineActionType>
        <ship:SourceLineNumber>1</ship:SourceLineNumber>
        <ship:SourceShipmentNumber>1.1.</ship:SourceShipmentNumber>
        <ship:OrderedQuantity>1</ship:OrderedQuantity>
        <ship:OrderedQuantityUOMName>PK</ship:OrderedQuantityUOMName>
        <ship:CarrierPartyName>Schneider</ship:CarrierPartyName>
        <ship:ServiceLevel>TRUCK</ship:ServiceLevel>
        <ship:ModeOfTransport>TRUCK</ship:ModeOfTransport>
        <ship:DateScheduled>2021-03-30T23:59:59Z</ship:DateScheduled>
        <ship:TransportationShipment>99191359</ship:TransportationShipment>
        <ship:InitialDestinationLocationId/>
        <ship:TransportationShipmentLine>10153474##1</ship:TransportationShipmentLine>
        <ship:TransportationPlanningDate/>
        </ship:ShipmentRequestOrderLine>
</typ:batchShipmentRequestOrder>

OTM External System Configuration

Refer MOS Support note for more information

Sample Integration with OTM/GTM using ICS (Doc ID 2209248.1)

FA:SCM:OM: Integrating Fusion Order Management Cloud with Oracle Transportation Management Cloud – Setup and Common Issues (Doc ID 2740173.1)

GTM Trade Compliance documentation

FAQs:

Getting OTM Integration Error: Failed Authentication, failed to assert identity with username token.

The most common reasons are:
– Not using the OTM internal user for integration and rather using external email user in OIC connection
– Certificates of OTM not imported in OIC
– OTM user not having required roles for Integration

How to Get the OTM Certificates?

Follow MOS Doc How to Retrieve Security Certificates for Inbound Integration using Firefox (Doc ID 2105818.1)

How to import Certificates in OIC?

Go to Oracle Integration menu> Settings >Certificates> upload .
upload the certificates downloaded from the OTM instance.

Fusion OM side Authentication Error?

Check the connection used in the OIC is using the right user. CSF is configured with OIC credentials in Fusion SOA Composer

The user should have roles

-Manage Web Service Interface to Transportation Data for Sales Order
-Manage Orchestration Order Trade Compliance Interface Web Service
-Update Orchestration Order Fulfillment Line Web Service
-Manage Orchestration Order Fulfillment Interface Web Service

Why OTM/ GTM Elements not coming over to OIC?

Check the Ouput XML Profiles in External System Configuration. It should have the elements which has to be sent to external system.

5 Comments

Kiran Chanda June 4, 2021 at 10:09 pm

thanks for the detailed artcile ..HOw do we integrate EBS Parties and Items data to GTM ?
- Reply
  Admin June 5, 2021 at 6:56 am
  
  Depends upon the exact use case, ideally if your transaction raises a business event in EBS, subscribe to the event and trigger an external integration call, enrich data that can be consumed by GTM .
Kiran Chanda June 7, 2021 at 3:01 pm

Thank you…this is really helpful…So would an OIC developer know if a transaction(creating a contact) raises and business event in EBS ? if yes , all we have to do is to subscribe to it
- Reply
  Admin June 7, 2021 at 4:12 pm
  
  You should have an EBS apps technical resource to confirm that the transaction raises an event, and get the event name to be subscribed. if OIc developer knows eBS he /she can handle.
Kiran Chanda June 7, 2021 at 5:11 pm

Great..thanks a lot