Scenario Home

Scenario 9 illustrates the process for creating a customer order on-line, sourcing it from a vendor, fulfilling it in a store, and a customer pick-up in store via POS.   

1.       An order is created on-line via a retailer’s Online Order Capture system (OOC),which can represent a web channel, mobile device, or call center.

2.       The OOC will query existing customer information from an external customer master and associate it to an order as part of the order capture process.   If the customer doesn’t already exist, then a new customer may be created.

3.       During the order creation process, the OOC will verify inventory is available to fulfill the order using its local copy of inventory (3A), or by exception validating inventory availability via RMS (3B).

Note:  Oracle Retail assumes retailers will use a local source copy of inventory as its default method for checking inventory availability and will only use the real time inventory availability lookup process in exception cases, such as for items with low stock on hand, or fast selling items. 

4.       Once the order has been created, it will be sent to the Order Management System(OMS) to determine the sourcing and fulfilling locations, if not already determined by the OOC. 

5.       Optional - During the order sourcing and fulfillment process, the OMS will verifyinventory is available to fulfill the order using its local copy of inventory.  For this scenario, it is assumed that the supplier is determined to be the bestfulfillment option, so this step may be skipped.

 

6.       Once the order is created, it will be sent to RMS for execution. The order information sent from the OMS will include the pertinent information to execute the order, including items, quantities, pricing, fulfillment location, and customer information.  Upon receipt of the order in RMS, a reserved customer order PO will be created to the physical store.  

 

7.       If payment has been taken from the customer as part of the order creation/fulfillment process, the OMS will send an Order Initiate (ORI) transaction to ReSA. 

 

8.       Total ORI transactions will be periodically interfaced to the General Ledger from ReSA.

 

9.        RMS will send the PO to the vendor with the customer order number and delivery details.

 

10.   RMS will also send a Purchase Order to SIM with the customer order number and delivery details

 

11.   After shipping the order to the store, the vendor will send an Advanced Shipment Notification (ASN) to SIM, RMS and the OMS.  The OMS will use this information to update the customer order.

 

12.   After the customer order has been fulfilled, the vendor will send an invoice to the Retail Invoice Match System (ReIM).  Once the transaction is complete ReIM processes will match the invoice to the purchase order andreceipt and post the invoice for payment.

 

13.   After receiving the shipment in the store, SIM will send a Receipt notification message to the OMS and RMS. Upon receipt of the order in SIM, SIM can be configured to reserve inventory on delivery from avendor or based on receipt of the second fulfillment order from the OMS.

 

14.   Once the OMS has confirmed that the product is available in the store, it will send a second fulfillment order to RMS and SIM.  Upon receipt of the order in SIM, SIM will reserve inventory.

 

Note:  The second fulfillment order may be sent earlier in the process, depending on how a retailer’s OMS is configured.

 

15.   Once the product has been picked, SIM will notify RMS and the OMS via Stock Order Status (SO Status) that the order is ready for pickup.

 

Note:  SIM can be configured to auto pick upon receipt of the store delivery.

 

Note: it is assumed that upon receipt of this update, OMS will also update the OOC and oneof the applications will inform the customer that the order is ready for pickup.

 

16.   When the customer arrives in the store, a cashier will look up the customer’s order using POS. POS will call the OMS, and the OMS will return a list of customer orders matching the customer’s information.  The cashier will then select theappropriate order being picked up.

 

17.   After the customer order pickup process is complete at POS, POS will notify SIM to relieve reserved inventory and decrement stock on hand.

 

18.   POS sends an RTLOG to ReSA for all sales transactions, including customer order pickups (ORD transaction type), periodically through the day. 

 

19.   POS will send an order complete transaction to the OMS with the pickup details.

 

20.   The OMS will periodically send ReSA RTLOG transactions to record all customer order fulfillments (ORD transaction type), which could beat either order fulfillment or after proof of delivery to recognize the sale, based on rules defined. 

 

Note: rules exist in ReSA to prevent transactions from being processed twice from both the OMS and POS. 

 

21.   Total ORD transactions will be periodically interfaced to the General Ledger from ReSA.   These will offset the ORI transactions recorded at order creation.

 

22.   When RMS receives the sales transaction associated with in-store fulfillment from ReSA, it will recognize that the sale occurred as a result of a customer order in a stock holding store and decrement customer order reserved quantity, as well as stock on hand.