1. WFM User Guide
  2. WMS Data

WMS Data

User activities performed using Oracle Cloud Warehouse Management System are called System Activities. The facility parameter WRITE_WMS_ACTIVITY_RECORDS controls the recording of these activities in WMS. If the facility parameter is to set to “Yes”, all user activities performed using WMS RF options are recorded in WMS.

As of Release 24D, user activity information can also be posted through the following WMS REST APIs:

  • POST .../entity/iblpn/receive/
  • POST .../entity/iblpn/modify_item_qty/
  • POST .../entity/oblpn/create_from_iblpn/
  • POST .../pick_pack/pick_confirm/
  • POST .../replenishment/replenish_to_active/
  • POST .../repack/pack_inventory/
  • POST .../entity/iblpn/split_lpn_for_replen/
  • POST .../entity/iblpn/composite_create/
  • POST .../entity/location/update_active_inventory/

Three new parameters have been introduced in these APIs – screen_name, begin_ts and end_ts.

  • Screen_name can be used to send the name of an app or screen that is used by an external system to capture user activity.
  • Begin_ts should mark the beginning of the activity performed by the user.
  • End_ts should mark the end of the activity performed by the user.

For more information about these APIs and the new parameters, refer WMS REST API Guide.

User Activity records captured by WMS RF transactions and WMS REST APIs contain both the time taken as well as the measure (in terms of UOM, Qty and SKU Line Group) of the activity performed. This data is extracted from WMS at regular intervals by the WMS WFM Interface scheduled job. Data is consolidated and moved to WMS Activity Track view in WFM.

WMS Activity Track

As a first step “WMS WFM interface” validates the SKU line, User , and the WMS Screen Name of each record that is moved from WMS to WFM. If SKU Line and WMS Screen are configured in WFM and the user exists in WMS, the status on the record is marked as “SUCCESS”.

However, if the user has been deleted or the SKU Line/ WMS Screen is not configured in WFM, the record fails, and the appropriate “Unknown” field is populated. For example, if the SKU Line is not configured, the status on the record is marked as “ERROR” and the “Unknown SKU Line” field is populated with the SKU Line that was on the record. The begin and end time stamp capture the total time taken for the user to perform the activity. Nbr Pallets, Nbr LPNs and Qty show the total quantity of Pallets, LPNs or Qty handled during the activity. Additional details such as Pallet Nbr, LPN Nbr, handling UOM and pre-pack can be viewed in the details screen.

WMS Activity Track
Note: In order for records created by WMS REST APIs to succeed “Screen Name”validations, the screen_name that is sent over in the WMS REST APIs have to be created as a screen in WMS using an RF module and mapped to an activity in WFM (Refer WMS Screens under WFM configuration)

Daily Activity Track

As a second step “WMS WFM Interface”, consolidates all the successful records in WMS Activity Track and moves to Daily Activity Track view in WFM. Similar transactions (for example, same user, same SKU Line Group and same WMS Screen) are consolidated per day and written to this view.

Daily Activity Track