Creating and Maintaining Warehouses (WWHS)
Purpose: You can use the Work with Warehouses function to create, change, delete, or display warehouse information. A warehouse is required for each physical and logical warehouse in which you track inventory.
A logical warehouse can be:
• a section of a physical warehouse that is treated as if it were a separate warehouse. For example, if you have inventory in one building that is both a retail store and a mail order fulfillment center, you can establish this building as two separate warehouses to track retail and mail order inventory separately. Or, you might have areas in the warehouse where defective merchandise and merchandise that will be returned to the vendor is stored.
• a means to track inventory that is not kept in a warehouse; for example, you can map a logical warehouse to a retail outlet, or to represent stock that is in transit between warehouses.
Note: Inventory reservation takes place at the warehouse level. Maintain separate warehouses for defective merchandise and merchandise that you are returning to the vendor, so that these quantities are not included in inventory reservation.
Additionally, you can use this function to:
• create and maintain retail store information for a warehouse that represents a retail store.
• use the Working with Warehouse Lists (WWHL) to create, change, delete, or display the sequence in which warehouses will be selected to fulfill orders if you ship merchandise from more than one warehouse.
• use the Work with Item Warehouse Screen to create, change, delete, or display item warehouse assignments.
• use the Work with Van Routes Screen to create, change, delete, or display van routes defined for the warehouse.
In this chapter:
• Work with Warehouse Devices Screen
• See Working with Warehouse Lists (WWHL)
For more information:
How to display this screen: Enter WWHS in the Fast Path field at the top of any menu, or select Work with Warehouses from a menu.
Field |
Description |
Warehouse |
A number that identifies the warehouse. Numeric, 3 positions; optional. |
Name |
The name of the warehouse. Alphanumeric, 30 positions; optional. |
Store |
This field indicates whether the warehouse represents a retail store rather than a true warehouse. Valid values are: • selected = The warehouse represents a retail store. • unselected = The warehouse does not represent a retail store. |
This field indicates whether you can reserve inventory from the warehouse. Valid values: • selected = the warehouse is allocatable. • unselected = the warehouse is not allocatable. If a warehouse is not flagged as allocatable, its on-hand quantity is not included in the availability calculation for items; also, it is not included in the product import to Oracle Retail Order Broker when the Send Inventory by Warehouse to OROB (L06) system control value is unselected. |
|
O/E (Order entry) |
This field indicates whether inventory availability can be viewed in Order Entry. • selected = inventory availability is displayed in Order Entry. • unselected = inventory availability does not display in Order Entry. |
Telephone # |
The telephone number at the warehouse. Numeric, 14 positions; display-only. |
Screen Option |
Procedure |
Create a new warehouse |
Select Create to advance to the Create Warehouse Screen. |
Change warehouse information |
Select Change for a warehouse to advance to the Change Warehouse Screen. |
Delete a warehouse |
Select Delete for a warehouse to delete it. |
Display warehouse information |
Select Display for a warehouse to advance to the Display Warehouse Screen. |
Work with warehouse device |
Select Devices for a warehouse to advance to the Work with Warehouse Devices Screen. |
Work with item warehouse |
Select Items for a warehouse to advance to the Work with Item Warehouse Screen. |
Work with user defined fields |
Select User Field for a warehouse to advance to the Work with User Fields Screen. |
Work with van routes |
Select Van Routes for a warehouse to advance to the Work with Van Routes Screen. |
Work with warehouse lists |
Select Warehouse List for a warehouse to advance to the Working with Warehouse Lists (WWHL). |
To create: At the Work with Warehouses Screen, select Create.
Field |
Description |
A code to identify the warehouse. Numeric, 3 positions. Create screen: required. Change screen: display-only. |
|
The name of the warehouse. Alphanumeric, 30 positions; required. |
|
Address |
The address of the warehouse. Alphanumeric; three lines, 31 positions each; optional. |
City |
The city where the warehouse is located. Alphanumeric, 25 positions; required. |
State |
The code representing the state or province where the warehouse is located. See Setting Up the Country Table (WCTY). The system validates that the state you enter is assigned to the SCF in the first three positions of the postal code. Alphanumeric, 2 positions; optional. |
Zip code |
The zip code or postal code where the warehouse is located. See Setting Up the Zip/City/State (Postal Code) Table (WZIP). Alphanumeric, 25 positions; optional. |
Country |
The country where the warehouse is located. Country codes are validated against the Country Code table. See Setting Up the Country Table (WCTY). Alphanumeric, 3 positions; optional. |
Drop point |
The shipping point associated with the warehouse, or carrier pick-up point. The drop point is used in determining the correct destination UPS zone for a shipment in relation to the warehouse or carrier pick-up point from which it is shipped, and ultimately the shipping charge for the order. The code is validated against the Drop Point table. Example: If you have a warehouse in Boston and a warehouse in Chicago, the UPS zone assignments will be different for each warehouse. If you ship an order from Boston to Los Angeles, Los Angeles is zone 8 in relation to Boston. If you ship an order from Chicago to Los Angeles, Los Angeles is Zone 4 in relation to Chicago. By assigning different drop points to each warehouse, you can establish the correct UPS zones for each warehouse and have the correct meter charges calculated. |
|
The drop point also represents a carrier pick-up point when zone skipping is used. In zone skipping, orders are shipped from your warehouse to a UPS pick-up point by another carrier. The UPS zone to which the orders are shipped and the meter charges are determined in relation to the carrier pick-up point, and not your warehouse. |
|
Example: If your warehouse is located in Boston, you may ship your west coast orders via common carrier to a UPS pick-up point in Chicago, and then ship the orders via UPS from Chicago to their final destination. The UPS zone and the meter charges must be based upon the zone assignments for Chicago even though your warehouse is actually located in Boston. Note: If you are using the Freight by order weight freight method, the drop point for the warehouse must match the drop point for the SCF/Ship Via on the order. See Working with Weight Tables for Order Weight (WFTB). The drop point field is required even if you have only one warehouse and are not using zone skipping. Numeric, 3 positions; required. |
The name of the warehouse manager. Alphanumeric, 30 positions; optional. |
|
The telephone number of the warehouse. You can define a telephone number format to map to the phone numbers you enter into the system. The system defaults the telephone number formats for the Default Country for Customer Address (B17) for any phone number entered on this screen. See Setting Up the Country Table (WCTY). Numeric, 11 positions; optional. |
|
The fax number of the warehouse. See the Telephone number field description above for information on telephone number formats. Numeric, 11 positions; optional. |
|
The allocatable flag indicates whether merchandise in the warehouse can be reserved to fulfill consumer orders. Valid values are: • Selected = merchandise in this warehouse can be reserved to fulfill orders. The inventory reservation program considers inventory quantities in the warehouse when evaluating whether merchandise is available for shipment. • Unselected = merchandise in the warehouse will not be used to fulfill orders. Examples of non-allocatable warehouses include non-saleable and defective item warehouses. If a warehouse is not flagged as allocatable, its on-hand quantity is not included in the availability calculation for items. This field also controls whether the system displays item availability for the warehouse on the Display Item Availability Screen; also, a non-allocatable warehouse is not included in the product import to Oracle Retail Order Broker when the Send Inventory by Warehouse to OROB (L06) system control value is unselected. |
|
This flag indicates whether inventory availability for the warehouse can be viewed in Order Entry. When you view item availability in Order Entry, a list of all viewable warehouses and the item quantity available in each warehouse is displayed. Valid values are: • Selected = inventory quantities in this warehouse can be viewed in Order Entry. • Unselected = inventory quantities in this warehouse cannot be viewed in Order Entry. |
|
The code that identifies the warehouse to Oracle Retail Order Broker as a location. If this code matches the location code set up in Oracle Retail Order Broker and if the Send Inventory by Warehouse to OROB (L06) system control value is selected: • Order Management System sends inventory information for each item flagged as OROB eligible if it has a record in this warehouse when a system import is initiated in Oracle Retail Order Broker. • The BROKER process in Working with Integration Layer Processes (IJCT) sends fulfillment requests to the Order Broker requesting any new retail pickup or delivery orders assigned to this warehouse for fulfillment. If the Send Inventory by Warehouse to OROB (L06) system control value is unselected, then these activities are aggregated under the OROB Default Location (K51), and item warehouse records are included only if the warehouse is flagged as allocatable. See Oracle Retail Order Broker’s Product, Product Location, and Incremental Inventory Import Process for an overview and examples. If the location code set up in Oracle Retail Order Broker contains any non-numeric characters, they should be uppercase. Alphanumeric, 10 positions; optional. |
|
The Sharing warehouse and Shared company/warehouse fields appear only if the Inventory Sharing (A69) system control value is selected. |
|
This field indicates whether the warehouse serves as a sharing warehouse for orders you take in another company. Valid values are: • Selected = This warehouse provides inventory to fulfill orders you take in another company. • Unselected (default) = This is not a sharing warehouse |
|
These fields indicate whether to reserve and fulfill orders from a different warehouse in a different company. Company The company where the sharing warehouse (the warehouse that provides the inventory) is located. Company codes are defined in and validated against the Company table; see Working with Companies (WCMP). Numeric, 3 positions; optional. Warehouse The warehouse in the company, specified in the Company field, that is providing the inventory to fulfill orders against the current company and warehouse. Numeric, 3 positions; optional. |
|
To change: Select Change for the warehouse at the Work with Warehouses Screen to advance to the Change Warehouse screen. At this screen you can change any information except the warehouse code. See the Create Warehouse Screen for field descriptions.
To display: Select Display for a warehouse at the Work with Warehouses Screen to advance to the Display Warehouse screen. You cannot change any information on this screen. See Create Warehouse Screen for field descriptions.
Purpose: Use this screen to define van routes for a warehouse. Van routes are used to define the routes used to deliver merchandise to a customer.
How to display this screen: Select Van Routes for a warehouse at the Work with Warehouses Screen.
Van routes display on this screen alphanumerically in ascending van route order.
Field |
Description |
Warehouse |
The warehouse selected at the Work with Warehouses Screen. The description displays to the right. Warehouse code: numeric, 2 positions; display-only. Warehouse description: alphanumeric, 30 positions; display-only. |
Van Route |
The route used to deliver merchandise to a customer. Enter a full or partial van route and select OK to display van routes in alphanumeric order, starting with your entry. Alphanumeric, 4 positions; optional. |
Name |
The name of the van route. Enter a full or partial name and select OK to display van routes that contain your entry. Alphanumeric, 30 positions; optional. |
Screen Option |
Procedure |
Create a van route |
Select Create to advance to the Create Van Route Screen. |
Change a van route |
Select Change for a van route to advance to the Change Van Route Screen. |
Delete a van route |
Select Delete for a van route to delete it. The system advances you to the Confirm Delete window; select Delete to confirm the delete; otherwise, select Exit to cancel. |
Display a van route |
Select Display for a van route to advance to the Display Van Route screen. All fields on this screen are display-only. See the Change Van Route Screen for field descriptions. |
Purpose: Use this screen to create a van route for a warehouse.
How to display this screen: Select Create at the Work with Van Routes Screen.
Field |
Description |
Warehouse |
The warehouse selected at the Work with Warehouses Screen. The description displays to the right. Warehouse code: numeric, 2 positions; display-only. Warehouse description: alphanumeric, 30 positions; display-only. |
The route used to deliver merchandise to a customer. Alphanumeric, 4 positions; required. |
|
The name of the van route. Alphanumeric, 30 positions; required. |
To create: Complete the Van Route and Van Route Name fields and select OK.
Purpose: Use this screen to change a van route.
How to display this screen: Select Change for a van route at the Work with Van Routes Screen.
Field |
Description |
Warehouse |
The warehouse selected at the Work with Warehouses Screen. The description displays to the right. Warehouse code: numeric, 2 positions; display-only. Warehouse description: alphanumeric, 30 positions; display-only. |
Van Route |
The route used to deliver merchandise to a customer. Alphanumeric, 4 positions; display-only. |
The name of the van route. Alphanumeric, 30 positions. Change screen: required. Display screen: display-only. |
To change: Update the Van Route Name and select OK. The system returns you to the Work with Van Routes Screen.
Work with Warehouse Devices Screen
Purpose: Use this screen to define the default PC manifest, pick slip, and report output devices for a warehouse.
Note: It is not necessary to define PC manifest server devices if you use the PC Manifesting Interface.
How to display this screen: Select Devices a warehouse on the Work with Warehouses Screen.
Field |
Description |
Type |
The type of output device. Valid values are: • PC Manifest Server ID = You must define this device if you are using batch PC manifesting. Note: It is not necessary to define PC manifest server devices if you use the PC Manifesting Interface. • Pick Output Queue • Report Output Queue Optional. |
Description |
The description of the device type. Types and descriptions are system-defined. Alphanumeric, 25 positions; display-only. |
The name of the output device. Alphanumeric, 10 positions; optional. |
Screen Option |
Procedure |
Create a new warehouse device |
Select Create to advance to the Create Warehouse Device Window. At this window, you can enter the device type and name. See above for field descriptions. |
Change warehouse device information |
Select Change for a warehouse device to advance to the Change Warehouse Device Window. At this window, you can change the device name. See above for more information. |
Delete a warehouse device |
Select Delete for a warehouse device to delete it. |
| Managing Warehouses | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Working with Warehouse Lists (WWHL) |
WWHS OMSCS 18.1 April 2019 OTN