1. Implementing Order Management
  2. Cancel Backorder During Import

Cancel Backorder During Import

You can use the Order Import web service to cancel a backordered line.

  • Assume you import a quantity of 10 on order line 1001.

  • Some time later, Shipping splits the line into two lines, line 1002 with a quantity of 6 and line 1003 with a quantity of 4.

  • Shipping ships line 1002 and sets the status for line 1002 to Awaiting Billing, but sets line 1003 to Backordered because no more inventory is available to ship.

  • You receive a request from your customer to cancel the sales order.

  • The order import service uses SourceTransactionLineIdentifier to identify the entire quantity for line 1001. It doesn't distinguish between lines 1002 and 1003 because it isn't aware that these lines exist.

  • Line 1003 hasn't shipped so you don't need to cancel the quantity for it. You only need to cancel the quantity of the line that has shipped. So, set the OrderedQuantity attribute to 6 on order line 1001 in your web service payload.

Here's an example.

<soap:Envelope
xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">>
<ns1:createOrders
xmlns:ns1="http://xmlns.oracle.com/apps/scm/fom/importOrders/orderImportService/types/">
<ns1:request
xmlns:ns2="http://xmlns.oracle.com/apps/scm/fom/importOrders/orderImportService/">
<ns2:BatchName ></ns2:BatchName>
<ns2:Order>
<ns2:SourceTransactionNumber>ORDER_CANCEL_12</ns2:SourceTransactionNumber>
<ns2:SourceTransactionSystem>LEG</ns2:SourceTransactionSystem>
<ns2:SourceTransactionIdentifier>ORDER_CANCEL_12</ns2:SourceTransactionIdentifier>
<ns2:CustomerPONumber></ns2:CustomerPONumber>
<ns2:BuyingPartyName>Computer Service and Rentals</ns2:BuyingPartyName>
<ns2:TransactionalCurrencyCode>USD</ns2:TransactionalCurrencyCode>
<ns2:TransactionOn>2017-12-06T19:27:11</ns2:TransactionOn>
<ns2:TransactionTypeCode></ns2:TransactionTypeCode>
<ns2:RequestingBusinessUnitIdentifier>204</ns2:RequestingBusinessUnitIdentifier>
<ns2:RequestingLegalUnit>204</ns2:RequestingLegalUnit>
<ns2:BillToCustomerName>Computer Service and Rentals</ns2:BillToCustomerName>
<ns2:ShipToPartyName>Computer Service and Rentals</ns2:ShipToPartyName>
<ns2:ShipToPartySiteIdentifier>1036</ns2:ShipToPartySiteIdentifier>
<ns2:BillToAccountSiteUseIdentifier>1025</ns2:BillToAccountSiteUseIdentifier>
<ns2:PartialShipAllowedFlag>false</ns2:PartialShipAllowedFlag>
<ns2:FreezeShippingChargeFlag>true</ns2:FreezeShippingChargeFlag>
<ns2:FreezeTaxFlag>true</ns2:FreezeTaxFlag>


<ns2:Line>
<ns2:SourceTransactionLineIdentifier>1001</ns2:SourceTransactionLineIdentifier>

<ns2:SourceTransactionScheduleIdentifier>1001</ns2:SourceTransactionScheduleIdentifier>
<ns2:SourceTransactionLineNumber>1</ns2:SourceTransactionLineNumber>
<ns2:SourceTransactionScheduleNumber>1</ns2:SourceTransactionScheduleNumber>
<ns2:ProductNumber>AS54888</ns2:ProductNumber>
<ns2:OrderedQuantity>6</ns2:OrderedQuantity>
<ns2:OrderedUOMCode>Ea</ns2:OrderedUOMCode>
<ns2:RequestedFulfillmentOrganizationIdentifier>204</ns2:RequestedFulfillmentOrganizationIdentifier>
<ns2:RequestingBusinessUnitIdentifier>204</ns2:RequestingBusinessUnitIdentifier>
<ns2:ParentLineReference></ns2:ParentLineReference>
<ns2:RootParentLineReference></ns2:RootParentLineReference>
<ns2:ShippingInstructions></ns2:ShippingInstructions>
<ns2:PackingInstructions></ns2:PackingInstructions>
<ns2:RequestedShipDate>2017-12-06T00:00:00</ns2:RequestedShipDate>
<ns2:PaymentTerms>30 Net</ns2:PaymentTerms>
<ns2:TransactionCategoryCode>ORDER</ns2:TransactionCategoryCode>
<ns2:InventoryOrganizationIdentifier>204</ns2:InventoryOrganizationIdentifier>
<ns2:ShipToPartyName>Computer Associates International</ns2:ShipToPartyName>
<ns2:ShipToPartyContactName>Jimmy Anderson</ns2:ShipToPartyContactName>
<ns2:ShipToAddress1>102, CityView</ns2:ShipToAddress1>
<ns2:ShipToCity>CHATTANOOGA</ns2:ShipToCity>
<ns2:ShipToPostalCode>37401</ns2:ShipToPostalCode>
<ns2:ShipToState>TN</ns2:ShipToState>
<ns2:ShipToCountry>US</ns2:ShipToCountry>
<ns2:ShipToPartyType>ORGANIZATION</ns2:ShipToPartyType>
<ns2:ShipToPartyType>ORGANIZATION</ns2:ShipToPartyType>
<ns2:BillToCustomerName>Computer Associates International</ns2:BillToCustomerName>
<ns2:BillToAccountContactName>Jimmy Anderson</ns2:BillToAccountContactName>
<ns2:BillToAddress1>102, CityView</ns2:BillToAddress1>
<ns2:BillToCity>CHATTANOOGA</ns2:BillToCity>
<ns2:BillToPostalCode>37401</ns2:BillToPostalCode>
<ns2:BillToState>TN</ns2:BillToState>
<ns2:BillToCountry>US</ns2:BillToCountry>
<ns2:BillToPartyType>ORGANIZATION</ns2:BillToPartyType>
<ns2:BillToPartyType>ORGANIZATION</ns2:BillToPartyType>
<ns2:BillToPartyType>ORGANIZATION</ns2:BillToPartyType>
<ns2:PartialShipAllowedFlag>false</ns2:PartialShipAllowedFlag>
<ns2:UnitListPrice>150.0</ns2:UnitListPrice>
<ns2:UnitSellingPrice>150.0</ns2:UnitSellingPrice>
<ns2:ContractStartDate>2016-11-22</ns2:ContractStartDate>
<ns2:ExtendedAmount>150.0</ns2:ExtendedAmount>
<ns2:TaxExempt>S</ns2:TaxExempt>
<ns2:OrigSysDocumentReference>ORIGSYS</ns2:OrigSysDocumentReference>
<ns2:OrigSysDocumentLineReference>ORIGSYSLINE</ns2:OrigSysDocumentLineReference>
<ns2:OrderCharge>
<ns2:ChargeDefinitionCode>QP_SALE_PRICE</ns2:ChargeDefinitionCode>
<ns2:ChargeSubtypeCode>ORA_PRICE</ns2:ChargeSubtypeCode>
<ns2:PriceTypeCode>ONE_TIME</ns2:PriceTypeCode>
<ns2:PricedQuantity>10</ns2:PricedQuantity>
<ns2:PricedQuantityUOMCode>Ea</ns2:PricedQuantityUOMCode>
<ns2:PrimaryFlag>true</ns2:PrimaryFlag>
<ns2:ApplyTo>PRICE</ns2:ApplyTo>
<ns2:RollupFlag>false</ns2:RollupFlag>
<ns2:SourceChargeIdentifier>SC2</ns2:SourceChargeIdentifier>
<ns2:ChargeTypeCode>ORA_SALE</ns2:ChargeTypeCode>
<ns2:ChargeCurrencyCode>USD</ns2:ChargeCurrencyCode>
<ns2:SequenceNumber>2</ns2:SequenceNumber>
<ns2:PricePeriodicityCode></ns2:PricePeriodicityCode>
<ns2:GsaUnitPrice></ns2:GsaUnitPrice>
<ns2:OrderChargeComponent>
<ns2:ChargeCurrencyCode>USD</ns2:ChargeCurrencyCode>
<ns2:HeaderCurrencyCode>USD</ns2:HeaderCurrencyCode>
<ns2:HeaderCurrencyExtendedAmount>150.0</ns2:HeaderCurrencyExtendedAmount>
<ns2:PriceElementCode>QP_LIST_PRICE</ns2:PriceElementCode>
<ns2:SequenceNumber>4</ns2:SequenceNumber>
<ns2:PriceElementUsageCode>LIST_PRICE</ns2:PriceElementUsageCode>
<ns2:ChargeCurrencyUnitPrice>150.0</ns2:ChargeCurrencyUnitPrice>
<ns2:HeaderCurrencyUnitPrice>150.0</ns2:HeaderCurrencyUnitPrice>
<ns2:RollupFlag>false</ns2:RollupFlag>
<ns2:SourceParentChargeComponentId></ns2:SourceParentChargeComponentId>
<ns2:SourceChargeIdentifier>SC2</ns2:SourceChargeIdentifier>
<ns2:SourceChargeComponentIdentifier>SCC3</ns2:SourceChargeComponentIdentifier>
<ns2:ChargeCurrencyExtendedAmount>150.0</ns2:ChargeCurrencyExtendedAmount>
</ns2:OrderChargeComponent>
<ns2:OrderChargeComponent>
<ns2:ChargeCurrencyCode>USD</ns2:ChargeCurrencyCode>
<ns2:HeaderCurrencyCode>USD</ns2:HeaderCurrencyCode>
<ns2:HeaderCurrencyExtendedAmount>150.0</ns2:HeaderCurrencyExtendedAmount>
<ns2:PriceElementCode>QP_NET_PRICE</ns2:PriceElementCode>
<ns2:SequenceNumber>3</ns2:SequenceNumber>
<ns2:PriceElementUsageCode>NET_PRICE</ns2:PriceElementUsageCode>
<ns2:ChargeCurrencyUnitPrice>150.0</ns2:ChargeCurrencyUnitPrice>
<ns2:HeaderCurrencyUnitPrice>150.0</ns2:HeaderCurrencyUnitPrice>
<ns2:RollupFlag>false</ns2:RollupFlag>
<ns2:SourceParentChargeComponentId></ns2:SourceParentChargeComponentId>
<ns2:SourceChargeIdentifier>SC2</ns2:SourceChargeIdentifier>
<ns2:SourceChargeComponentIdentifier>SCC1</ns2:SourceChargeComponentIdentifier>
<ns2:ChargeCurrencyExtendedAmount>150.0</ns2:ChargeCurrencyExtendedAmount>
</ns2:OrderChargeComponent>
</ns2:OrderCharge>
</ns2:Line>
</ns2:Order>
</ns1:request>
</ns1:createOrders>
</soap:Body>
</soap:Envelope>

Related Topics