Creating Customer Order Fulfillment in Oracle Retail Merchandising Cloud (RMS)
Oracle has exposed SOAP Web Service to Create an order fulfillment in RMS :
URL : https://<<YOUR_SERVER_URL>>/FulfillOrderBean/FulfillOrderService?wsdl
Sample Payload Request :
<v1:createFulfilOrdColDesc>
<!--Optional:-->
<FulfilOrdColDesc xsi:schemaLocation="http://www.oracle.com/retail/integration/base/bo/FulfilOrdColDesc/v1 http://www.oracle.com/retail/integration/base/bo/FulfilOrdColDesc/v1/FulfilOrdColDesc.xsd " xmlns="http://www.oracle.com/retail/integration/base/bo/FulfilOrdColDesc/v1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<collection_size>4</collection_size>
<ns1:FulfilOrdDesc xmlns:ns1="http://www.oracle.com/retail/integration/base/bo/FulfilOrdDesc/v1">
<ns1:consumer_delivery_date>2013-09-01T09:08:07</ns1:consumer_delivery_date>
<ns1:customer_order_no>13</ns1:customer_order_no>
<ns1:fulfill_order_no>13</ns1:fulfill_order_no>
<ns1:source_loc_type>WH</ns1:source_loc_type>
<ns1:source_loc_id>99990</ns1:source_loc_id>
<ns1:fulfill_loc_type>S</ns1:fulfill_loc_type>
<ns1:fulfill_loc_id>17</ns1:fulfill_loc_id>
<ns1:partial_delivery_ind>N</ns1:partial_delivery_ind>
<ns1:delivery_type>S</ns1:delivery_type>
<ns1:delivery_charges>20.4</ns1:delivery_charges>
<ns1:delivery_charges_curr>USD</ns1:delivery_charges_curr>
<ns1:comments>Test</ns1:comments>
<ns2:FulfilOrdCustDesc xmlns:ns2="http://www.oracle.com/retail/integration/base/bo/FulfilOrdCustDesc/v1">
<ns2:customer_no>55006</ns2:customer_no>
<ns2:deliver_first_name>Andrewq</ns2:deliver_first_name>
<ns2:deliver_last_name>Josephq</ns2:deliver_last_name>
<ns2:deliver_add1>High Street</ns2:deliver_add1>
<ns2:deliver_city>Ontario</ns2:deliver_city>
<ns2:deliver_state>LA</ns2:deliver_state>
<ns2:deliver_country_id>US</ns2:deliver_country_id>
<ns2:deliver_phone>23112</ns2:deliver_phone>
<ns2:bill_first_name>Andrew</ns2:bill_first_name>
<ns2:bill_last_name>Joseph</ns2:bill_last_name>
<ns2:bill_add1>High street</ns2:bill_add1>
<ns2:bill_city>Ontario</ns2:bill_city>
<ns2:bill_state>NY</ns2:bill_state>
<ns2:bill_country_id>US</ns2:bill_country_id>
</ns2:FulfilOrdCustDesc>
<ns8:FulfilOrdDtl xmlns:ns8="http://www.oracle.com/retail/integration/base/bo/FulfilOrdDtl/v1">
<ns8:item>18CHAMOMILE</ns8:item>
<ns8:ref_item/>
<ns8:order_qty_suom>20</ns8:order_qty_suom>
<ns8:standard_uom>EA</ns8:standard_uom>
<ns8:transaction_uom>EA</ns8:transaction_uom>
<ns8:substitute_ind>N</ns8:substitute_ind>
<ns8:unit_retail>20.4</ns8:unit_retail>
<ns8:retail_curr>CAD</ns8:retail_curr>
<ns8:comments>testing</ns8:comments>
</ns8:FulfilOrdDtl>
</ns1:FulfilOrdDesc>
</FulfilOrdColDesc>
</v1:createFulfilOrdColDesc>
Response :
<ns1:createFulfilOrdColDescResponse xmlns:ns1="http://www.oracle.com/retail/rms/integration/services/FulfillOrderService/v1" xmlns:ns16="http://www.oracle.com/retail/integration/base/bo/FulfilOrdCfmCol/v1" xmlns:ns6="http://www.oracle.com/retail/integration/base/bo/FulfilOrdColDesc/v1" xmlns:ns2="http://www.oracle.com/retail/integration/base/bo/FulfilOrdColRef/v1" xmlns:ns5="http://www.oracle.com/retail/integration/base/bo/InvocationSuccess/v1" xmlns:ns17="http://www.oracle.com/retail/integration/base/bo/FulfilOrdCfmDesc/v1" xmlns:ns18="http://www.oracle.com/retail/integration/base/bo/FulfilOrdCfmDtl/v1" xmlns:ns7="http://www.oracle.com/retail/integration/base/bo/FulfilOrdDesc/v1" xmlns:ns8="http://www.oracle.com/retail/integration/base/bo/CustFlexAttriVo/v1" xmlns:ns9="http://www.oracle.com/retail/integration/base/bo/FulfilOrdCustDesc/v1" xmlns:ns10="http://www.oracle.com/retail/integration/base/bo/LocOfFulfilOrdCustDesc/v1" xmlns:ns11="http://www.oracle.com/retail/integration/localization/bo/BrFulfilOrdCustDesc/v1" xmlns:ns12="http://www.oracle.com/retail/integration/localization/bo/BrFulfilOrdPmtDesc/v1" xmlns:ns13="http://www.oracle.com/retail/integration/custom/bo/EOfBrFulfilOrdPmtDesc/v1" xmlns:ns14="http://www.oracle.com/retail/integration/custom/bo/EOfBrFulfilOrdCustDesc/v1" xmlns:ns15="http://www.oracle.com/retail/integration/base/bo/FulfilOrdDtl/v1" xmlns:ns3="http://www.oracle.com/retail/integration/base/bo/FulfilOrdRef/v1" xmlns:ns4="http://www.oracle.com/retail/integration/base/bo/FulfilOrdDtlRef/v1">
<ns16:FulfilOrdCfmCol>
<ns16:collection_size>1</ns16:collection_size>
<ns17:FulfilOrdCfmDesc>
<ns17:customer_order_no>13</ns17:customer_order_no>
<ns17:fulfill_order_no>13</ns17:fulfill_order_no>
<ns17:confirm_type>C</ns17:confirm_type>
<ns17:confirm_no>100000015005</ns17:confirm_no>
<ns18:FulfilOrdCfmDtl>
<ns18:item>18CHAMOMILE</ns18:item>
<ns18:confirm_qty>20</ns18:confirm_qty>
<ns18:confirm_qty_uom>EA</ns18:confirm_qty_uom>
</ns18:FulfilOrdCfmDtl>
<ns17:fulfill_loc_id>17</ns17:fulfill_loc_id>
<ns17:system_cd>MRCH-COMP</ns17:system_cd>
</ns17:FulfilOrdCfmDesc>
</ns16:FulfilOrdCfmCol>
</ns1:createFulfilOrdColDescResponse>
For Validation you can check in following tables :
Tables :
select * from tsfhead where tsf_no='100000015005';
select * from tsfdetail where tsf_no='100000015005';
select * from ORDCUST_DETAIL order by CREATE_DATETIME desc
;
****************************************************************************
