1System Overview

System Overview

This section provides details and an overview on configuring the user menu and the system integration framework.

Parent Child Company Hierarchy

In WMS, companies are divided into parent and child companies. This structure exists in order to help 3PLs view and manage their clients’ inventory separately. Depending on how many clients and how many warehouses the 3PL has, views can be managed accordingly:

Parent Child Company Hierarchy

To toggle a specific Distribution Center (DC) view for a company, select the choices from the two drop-down menus located at the top right of the UI screen.

In the following screen, the first drop-down denotes a facility (DC), while the second drop-down denotes the companies in the environment:

Facility and Company Views from the UI

User Menu Configuration

The Oracle Warehouse Management Cloud organizes your structure in the following way:User, Group and Menu Organization

Users, Groups and Menus

Users are separated into groups based on their operational purpose in the warehouse. Every user within a group shares the same user interface (UI) and radio frequency (RF) menus. Within each menu, you can configure your permissions and parameters for RF menus.

What is a UI menu?

The UI menu is a series of windows and dialog boxes that are accessible to you in the WMS via the browser.Warehouse Management System (WMS) User Interface (UI) Menu

Note: When using the RF gun, you must ensure that the RF is in the correct facility. This can be seen at the top right of the RF menu management.

What is an RF menu?

The RF menu is the series of transactions that are made with the RF gun on the warehouse floor. These screens, or modules, are used to perform processes such as Receiving, Put away (also called putaway), Picking, and Loading.

RF Menu

Creating Users

New users can be created through you screen where you can define the following:

  • Username and password
  • The facilities and companies you have access for
  • Your role (Administrator, Management, Supervisor, etc)
  • Your default group (UI and RF Menus)
  • Your language (corresponding/desired/appropriate supported language)
  • Your default printer
  • Your fixed equipment type
Creating New Users
  1. On the Users screen.
  2. Click the Create button and populate the necessary fields:

    Creating New Users

  3. Click Save when done.
  4. To configure the Facilities and Companies that he user has access to, select user and click the Eligible Facilities & Eligible Companies buttons. This takes you to a new screen displaying all records you currently have access to view.

    Viewing Your Eligible Facilities/Companies

  5. Click the Create button to add new Facilities or Companies.

    Updating Your Eligible Records

  6. When finished, click Back to return to the main screen.
  7. To assign Equipment Types to a user:
    1. Select user.
    2. Select an Equipment Type from the dropdown menu.
    3. Click the Assign Equipment Type label.

      Assigning Users with Equipment Types

      Note: Equipment Types must first be defined in the Equipment Types screen before assigning them to users.

Configuring Menus for Users

There are five steps in adding Group menus.

  • Adding Screens
  • Adding Screens to different Menus
  • Assigning Menus to Groups
  • Assigning Groups to Users
  • Creating and Assigning Facilities & Companies to Users
Adding Screens
  1. On the Screens UI screen, click Generate Screens.
  2. Select all the necessary screens for the Group (e.g. ASNs, Appointments, Loads, etc.).
  3. You add both UI and RF screens.
    Note: For RF menus, extra configuration might be required (RF module parameters). To modify its parameters, select the RF screen and click the Details button.
  4. Click Save when done.
Adding Screens to Different Menus
On the Menus screen, to create a new menu (one for the UI and the RF):
  1. Select the menu and click on the Details button. In the new dialog box, you are able to separate screens into different folders.

    Naming Folders

  2. To name a folder:
    1. Select the folder (1)
    2. Type in the name in the field to the right (2).

      Adding Screens to a Folder

To add a screen within the folder:
  1. Select the folder first (1).
  2. Click Insert Screen (2).
  3. Pick the screen to add from the dropdown menu (3).
  4. Repeat steps until all the screens have been added.
  5. Click Save to complete.
Assigning Menus to Groups
Once the Menus have been set up, it is now time to add them to Groups. On the Groups screen:
  1. Click the Create button to create a new group.
  2. Type in the group name.
  3. Select the UI/RF menus from the dropdown menus.
  4. Click Save.
    Note: Accessing a Group’s Permissions List of Permission Activities
Assigning Groups to Users
Now that Groups have been created, you now adds users to each group. On the User screen:
  1. Select a user to assign to a group.
  2. Click on Groups.
  3. Using the Create button, add the Group(s) to assign the user to the Group.
    Note: If the user is assigned to multiple groups, you can toggle between different groups by clicking the gear button at the top right, hovering the mouse over the View menu, and selecting the Group name.
Creating and Assigning Facilities & Companies to Users

Once user and group setup is complete, you must create facilities and companies in Oracle Warehouse Management Cloud.

To create companies, on the Companies screen:
  1. Click the Create button.
  2. Populate the company’s information such as the Code, Name, and Address.
    Note: Parent Company has an Asterisk in the Parent Company Column
  3. Click Save when complete.

Facilities are controlled at the company level. This means that every company has its own set of facilities. This link is defined in the Parent Company column in the Facilities screen. By default, all parent and child company facilities are displayed.

To Create Facilities, on the Facilities screen:
  1. Click the Create button.
  2. Populate the facility’s information such as the Code, Name, and Address.
Functional Field Descriptions for Facilities
  • Default Ship Via Code: This field is used when ship via codes are activated through the company’s PACKING_ROUTING_MODE parameter. The system defaults to this ship via value if the order header doesn’t have a ship via code specified.
  • Parent Company: Denotes the company that the facility belongs to.
  • Accept Transfer Shipment: If checked and if this facility is a warehouse in Oracle Warehouse Management Cloud, this facility accepts ASNs from other facilities configured in the environment.
Once the Companies and Facilities have been created, the next task is to assign them to users. This task defines the companies and facilities that you have access to. On your screen:
  1. Select the user to modify.
  2. Click on Eligible Facilities button.
  3. Using the Create button.
  4. Add the Facilities that this user requires to access.
To add companies:
  1. Select you to modify.
  2. Click the Eligible Companies button
  3. Using the Create button.
  4. Add the Facilities that this user requires to access.

    Assigning Users to Facilities and Companies

A sample User/Group set up is shown below:

Sample User/Group set up in Oracle Warehouse Management Cloud

System Integration Framework

Oracle Warehouse Management Cloud uses the following methods for processing interface files into and out of Oracle Warehouse Management Cloud:

SFTP Method in Oracle Warehouse Management Cloud

Interfacing Methods in Oracle Warehouse Management Cloud

Supported Formats

Oracle Warehouse Management Cloud supports the following formats (both inbound/outbound) with interfaces:

  • Flat files
  • XML files
  • CSV files
  • XLS files
  • EDI files (translated through a 3rd party application)
  • MHE messages (translated through a 3rd party application)
  • FedEx web services
  • UPS web services

Input Interfaces

  • Purchase order
  • Item
  • Item (facility specific)
  • Item barcode
  • Item pre-pack
  • Inbound shipment
  • Order
  • Vendor
  • Appointment
  • Store
  • Locations
  • Route
  • Price label
  • Ship to company
  • Site
  • Asset
  • Cubiscan
  • Point of sale

Output Interfaces

  • ASN verification
  • Parcel Manifest shipment confirmation
  • LTL Shipment confirmation
  • Inventory history
    Note: For more details on each interface, please refer to the Oracle Warehouse Management Cloud Interface File Formats file.

Uploading Interface Files with Oracle Warehouse Management Cloud

If you are manually preparing the input interface file via Excel, it is important to follow these best practices:
  • The filename must start with the phrase as specified in the Input File Formats document (the filename must begin with ORR for uploading Order files).
  • The columns specified as required in the interface specification document must be populated.
  • For Purchase Order, Order, and Inbound Shipment interfaces, you must populate [H1] for every distinct header record and [H2] for each of its detail records.
  • You must populate the correct sequence in the seq_nbr field (i.e. no duplicate values).

Setting Email Notifications for Failed Interfaces

You can set up email notifications for interfaces that fail to process into Oracle Warehouse Management Cloud. The email notification provides the following information:
  • The interface file that failed.
  • Error message – the reason why the file failed.

To Set Up Email Notification

On the Company Parameters screen:
  1. Select INTF_ERROR_EMAIL_LIST parameter and click the Edit button.
  2. In the Parameter Value, populate with the emails that are to receive the error notifications. Separate multiple emails without spaces between emails.

    Email Notification