Interface Process

The first step of this process moves data from WMS Activity to WMS Activity Track. Only records in WMS Activity that fall in the range between current date and the past "Number of Days (Process new records)" days are picked up for processing. The create_ts field of WMS Activity is used to identify such records.

The next step in the process validates the User, SKU Line and WMS Screen on each record before consolidating and moving the records to Daily Activity Track. If the user has been deleted or if the SKU Line (and the corresponding SKU Line Group) or WMS Screen is not configured in WFM, the record is marked as ERROR and remains in WMS Activity Track.

Reprocessing Records

Records in WMS Activity Track with errors can be reprocessed by ensuring that missing data is first configured in WFM. For example, if a record fails due to missing SKU Line or SKU Line Group, the corresponding Unknown SKU Line field is populated with the SKU Line that is not configured in WFM. This SKU Line and the corresponding SKU Line Group need to be configured in WFM.

Note: Item Line of an item in WMS is referred to as SKU Line in WFM. If the item line is missing on items when WMS Activity records are written, SKU Line on such records will be empty. These records are marked as ERROR in WMS Activity Track and the Unknown SKU Line field is empty on such records. These records cannot be reprocessed unless the SKU Lines are inserted in the Unknown SKU Line field through data fix.

After configuring missing data, there are two ways in which error records can be reprocessed. The first option is to use the “Process WMS Activities” button on WMS Activity Track view. The other option is to just wait for the next scheduled run of the interface. The second step of the interface always tries to re-process error records first before processing new records.

If the reprocessing is triggered due to scheduled interface run, the “Number of Days – Reprocess Error Records” parameter is used to determine how many records should be reprocessed. Only records that fall in the range between current date and past “Number of Days – Reprocess Error Records” days are picked up for reprocessing. An extra day is added to "Number of Days – Reprocess Error Records" to take into account any user transaction that could have occurred over midnight traversing between two days.

For example, if current date is September 21 and "Number of Days – Reprocess Error Records" has been set as 10, the interface reprocesses records that have "Begin time stamp" later than or equal to September 10th (September 21 – (10+1) days).

Note: : “Number of Days – Reprocess Error Records” parameter is only used for reprocessing error records. Also, this parameter is only used when the reprocessing is triggered by scheduled job. It is not used when reprocessing is triggered using “Process WMS Activities” button on WMS Activity Track view.