Go to primary content
Oracle® Retail Store Inventory Management Store User Guide
Release 16.0
E76179-08
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

13 Sequencing

This chapter covers sequencing. The following topics are covered:

Overview

Sequencing functionality provides users the ability to know the relative location of an item in a store. Sequencing a store improves store processes and reduces the time that employees spend looking for items. The retailer can sequence all items in the store and create unique locations to hold the items.

Sequencing defines how many items can be stored in a particular location, and allows the definition of a capacity for that item location combination. The capacity is used for in-store replenishment when generating the shelf replenishment pick list. Sequencing is used within Stock Counts, Customer Order Picking, Transfer Request, and Shelf Replenishment to aid the user in proceeding to the next item during the transaction for efficiency. Lastly, the Sequencing Primary Location is displayed to the user on the Item Detail screen.

Sequencing functionality within SIM can be accomplished on a PC-based deployment, on a wireless handheld device, or on a combination of the two deployment methods.

The following features are available:

  • Add, remove, and rearrange macro locations in Shop floor and Backroom. (Delivery Bay is not a sequenced location)

  • Apply class list to create macro locations.

  • Add, remove, and rearrange items in a macro location (micro sequencing).

  • Apply item list to add items to macro locations.

  • Add locations to an item including primary and secondary locations.

  • Re-sequence an entire macro location (handheld only).

  • Define capacity for items in a location.

  • Define and print shelf edge labels and quantities.

Business Case

  • A grocery retailer originally has a rack with personal care products. Now the Plan-o-gram has changed and this rack will now have oral care products. The user can make updates to the macro location with the items of oral care by using the sequencing dialog on the handheld (sequence location).

  • Sequencing is used to define the capacity for an item in a location which is in turn used for determining shelf replenishment needs.

Sequencing PC Screen Flow

Figure 13-1 Sequencing PC Screen Flow


Sequencing exists under the Inventory Management menu. From the Macro Sequence List screen, the user can filter the records on an item basis to find all locations for a given item. The user can then view, create, edit, and delete locations as well as items in a location.

Configurations

This section covers parameters.

System Parameters

Search Limit Default for Sequencing

  • Valid Values: 1-999

  • Default: 500

  • Topic: UI

  • Editable: Yes

  • This parameter indicates the default search limit for the No Location List screen filter.

Store Parameters

Display Sequence Fields

  • Values: Yes and No

  • Default: No

  • Topic: Sequencing

  • Editable: Yes

  • Indicates whether or not sequencing fields are displayed in the Item Lookup screen.

Assign Shelf Edge Labels

  • Values: Yes and No

  • Default: No

  • Topic: Sequencing

  • Editable: Yes

  • If the value of this option is Yes, users are required to assign shelf edge labels for sequencing.

Security

Security Permissions exists for access, add, delete, and edit for sequencing. Permissions also exist for applying class and Item list for locations, arranging sequencing locations and items within locations. For the handheld, permissions exist for accessing, sequencing, and sequence item within a location.

Functionality

This section describes the screens available for sequencing.

Macro Sequence List

Figure 13-2 Macro Sequence List Screen


This figure shows the Macro Sequence List screen. This screen displays all the macro locations of the store with the number of items in it. The user can choose to edit locations from here. From this screen, the user can search on an item and the system will provide an Item Location List screen with all locations for that item. If a location is double clicked, the user navigates to the Micro Sequence List for that location. The Macro Sequence List screen is mainly informational listing out all of the macro locations in order.

Macro Sequence Edit

Figure 13-3 Macro Sequence Edit Screen


This figure shows the Macro Sequence Edit screen. From the Macro Sequence List, if the user selects the Edit option, the Micro Sequence Edit screen is displayed. This screen allows the user to edit the location description and change the area (Backroom or Shop floor) for locations. In addition, the user can move a location up or down, which will change the relative position of that location to another. If needed, the user can add new locations and remove existing locations. For some retailers, the locations may be based off of the merchandise hierarchy class. If this is the case, the Apply Class List button automatically creates macro locations for each of the classes in the system. The print feature prints out shelf edge labels for all items in the macro sequence location.

Micro Sequence List

Figure 13-4 Micro Sequence List Screen


This figure shows the Micro Sequence List screen. If the user double clicks any location on the Macro Sequence List screen, this screen is displayed. The screen displays the information of the items in the location and their various features.

If the item exists in more than one location, this is indicated. The user can click on an item on the screen and direct to the Item Location List screen to view all of the locations for the item.

Micro Sequence Edit

Figure 13-5 Micro Sequence Edit Screen


The Micro Sequence Edit Screen displays all the items in sequence order in the location they are assigned. The items can be added and removed from the location. The order of the items is considered the micro sequence order; this order can be modified by selecting an item and moving it up and down. If the macro location is a class, the Apply Item List function allows the user to apply all items that are part of the merchandise hierarchy class to the macro location.

The Capacity column is used in shelf replenishment to determine the limit of items on the location. Similarly, Label format allows the user to select the type of ticket the user wants to print which can be printed from ticketing. A user can double click the item and be taken to the Item Locations List Screen.

Item Locations List

Figure 13-6 Item Locations List Screen


The Item Locations List screen shows the user all the store locations for the item. This screen appears when the user double clicks an item from the Micro Sequence List screen. Existing locations can be added and removed for the item. If the user adds a location to an item, the item will be added at the end of the micro sequence within that location. An item can have only one location as its primary location.

No Location

Figure 13-7 No Location Screen


The No Locations List screen allows users to add a primary location, label format, and quantity to an item that does not exist at another store location. The screen displays all the items with no location associated to them. Once the item is added to a location, it will be micro sequenced as the last item in the location. Non-sellable items are not displayed on this screen.

Re-Sequence Location

Figure 13-8 Re-Sequence Location Screen


This screen is reached by selecting the Sequencing option under the Inventory Management menu. The handheld allows for sequencing an item, which means adding and removing locations for an item as well as moving the item within an existing location. The Sequence Location option enables the user to take an existing location and remove all the items in it and re-sequence that location by adding all new items into that location. The handheld does not allow the creation of macro locations.

User Interface Guidelines

The Sequencing dialog allows for creating, editing, and deleting of Macro and Micro Locations on the PC and handheld.

Items can be assigned to the added locations for better tracking of Inventory. Locations can be at Shop floor or Backroom.

Technical

A sequence is a location in a store. Using sequencing functionality, a retailer can divide the store area into multiple sequences and map items to them.

By default, all the items are mapped to a no-location sequence. As the retailer creates sequences and map items to them, the items are moved from a no-location sequence to their corresponding sequence and the mapping records are created in SIM data models.


Note:

The no-location sequence should not be deleted.

Business objects are used within the application code for all business processing. The following business objects are used for sequencing:

Business Object Description
StoreSequenceArea Contains information about the store area that contains sequence items.
StoreSequenceItem Contains information about an item within a store sequence area.

Integration

This section provides information on the integration of sequencing.

RIB

There is no integration specific to sequencing. When an item is created in RMS and integrated to SIM, SIM will create the item. The item will initially appear in the No Location macro sequence location until the user otherwise moves it.

Web Services

There are no web services for sequencing.

Batch

The following batch is supported:

Batch Name Description
Store Sequence Import Batch SIM integrates with an external system using a batch process to obtain sequencing information from the external system:
  • It will create micro locations.

  • It will create macro locations.


Data Structure

The following database tables are used in sequencing:

Table Name Description
STORE_SEQUENCE_AREA Hold data defining different locations defined in a store.
STORE_SEQUENCE_ITEM Defines a map of an item to a location and what order the item is in within the location.