Published September 12, 2023 | Version v2
Dataset Open

Order Management Object-centric Event Log in OCEL 2.0 Standard

  • 1. Chair of Process and Data Science, RWTH Aachen

Description

General Description

This process describes the management of customer orders within a company, comprising both the registration and payment of incoming orders, as well as the process of packing and shipping these orders. For these tasks, our company deploys staff in their sales, warehousing, and shipment departments.

This is an artificial event log according to the OCEL 2.0 Standard simulated using CPN-Tools. Both the CPN and the SQLite can be downloaded. The simulation is an extension of the order management log in the former OCEL standard.

Process Overview

At our company, customers place orders (place order) for different products in varying amounts. Each product type has a price and a weight. In the current market situation, there is an inflation that irregularly leads to an increase of prices. These price rises have a negative impact on customers’ purchasing power, i.e., on order volumes.

When a customer places an order, this order is assigned to an employee of our company’s sales department. To foster customer satisfaction, our company has a single-face-to-customer policy. This means that per customer there is one primary sales representative who ought to render all services related to that customer. If that first representative is unavailable, a second sales representative should take care of the order. Should this employee be also unavailable, the order has to be managed by another employee. The tasks of sales employees comprise the registration (confirm order) as well as payment processing (payment reminder, pay order).

In parallel to this, the shipment of goods is prepared. For this, the stock of our company is checked by an employee of the warehousing department for the availability of the ordered items. If necessary, the warehouser reorders the item (item out of stock, reorder item). Items ready for shipment are collected (pick item) for the placement into packages that are addressed to single customers. Here, it may happen that a package content relates to multiple orders, and order volumes are distributed over multiple packages.

After all items allocated to a package have been picked, the package is compiled by a warehousing employee (create package). Later on, this package is picked up by a shipment employee for transport (send package). According to another policy, a warehousing employee should provide assistance to the shipment employee in loading the package. However, oftentimes shippers act contrary to that policy and load packages alone or together with a second shipment employee.

Finally, the package is shipped. Deliveries may fail repeatedly (failed delivery) until successful delivery (package delivered).

The figure below depicts the process in a simplified manner, using an informal process notation to describe the control-flow and the involved object types. A formal description is given along with the artifacts in the next section.

Further information can be found at: https://www.ocel-standard.org/event-logs/simulations/order-management/

General Properties 

An overview of log properties is given below.

Property Value
Event Types 11
Object Types 6
Events 21008
Objects 10840

Control-Flow Behavior 

The behavior of the log is described by a respective object-centric Petri net. Also, individual object types exhibit behavior that can be described by simpler Petri nets. See below.

orders customers
items employees
packages products
Full object-centric Petri net

Object Relationships 

The company pursues the "one-face-to-the-customer" policy, in which every customer has a dedicated sales representative as well as a deputy (secondary representative). These relationships are described in the log.

Source Object Type Target Object Type Qualifier
employees customers primarySalesRep
employees customers secondarySalesRep

Additionally, object-to-object relations can emerge at executions of specific activities:

Activity Source Object Type Target Object Type Qualifier
create package package employee packed by
send package package employee forwarded by
send package package employee shipped by

Simulation Model 

The CPN used to create this event log can also be downloaded.To obtain simulated data, extract the linked ZIP file and play out the CPN therein, e.g., by using CPN Tools.

The play-out produces CSV files according to the schema of OCEL2.0. The provided jupyter notebook can be used to convert these files to an SQLite dump.

For a technical documentation of the simulation model, please open the attached CPN with CPN Tools and see the annotations therein.

Acknowledgements

Funded under the Excellence Strategy of the Federal Government and the LänderWe also thank the Alexander von Humboldt (AvH) Stiftung for supporting our research.

Files

csv_to_sql.ipynb

Files (58.9 MB)

Name Size Download all
md5:8add5ac6a881c2e4b289a892cdef340a
3.9 kB Preview Download
md5:0fbb063db34575c8b5b63a7c2ad5424f
12.6 MB Preview Download
md5:4635d8689ce03687866210afa41457b2
30.6 MB Download
md5:4b7b7ed60b4b9431490ef7c24df96a0c
15.6 MB Preview Download
md5:94f41f9194d5a84dde4891ee3bec53be
26.6 kB Preview Download