Skip to main content

Celonis Product Documentation

Installing new apps and updating existing apps

Q: I just updated to the latest version of the Control Center App, and suddenly there is an error on the KPI List component. I found that the issue is with the KPI Material Availability, as the error message for this kpi displays: “column ‘STOCK_HISTORY.DAYS_MAT_AVAILABLE’ is missing”. See the example screenshot below from a table component that references a field that does not exist in the data model.

image42.png

Answer 1:

This error is likely due to the Inventory Management Connector having added in a new field to the Stock History Table, namely ‘DAYS_MAT_AVAILABLE’ (in January 2022 this field was added in, with the name ‘DAYS_MAT_AVAIL’, which stores the number of days the stock level was greater than zero per month per material. Depending on when you initially installed the connector will influence whether or not that field is available for use inside of the Inventory Management data model. In order to rectify this issue, there are a couple of ways forward.

  1. Update the connector to the latest version by either copying in the new additions to your existing data pool, and copying your customizations into the latest version of the connector

  2. Revert the App to the older version prior to your update (in the event that it was an App update that causes this issue). This would mean you cannot leverage any of the other new features that might have been released inside of this version of the App.

  3. Try to ‘hide’ the missing column from the app, utilizing the “scope: hidden” functionality inside of the App UI. For example, editing the table with the error, and setting that KPI reference to “scope: hidden”, which will remove this kpi from the App’s UI. (least advised, as this process is not always straightforward, and can cause other issues along the way)

I installed the inventory management connector some months ago, and have just tried to install the Inventory Projections App from the Marketplace. After installing the app, I get the following error: “Table with name PLAF cannot be found.” See the screenshot below.

image16.png

Answer 2: This error is likely caused by the fact that the version of the connector you installed in the past did not include the PLAF table in the data model, as it was not required by the earlier Inventory Management Apps. However, since the Inventory Projection app required the Planned Orders from PLAF, it had to be transformed and added to the data model. There are a few ways to resolve this issue.

  1. The advised approach is to install the latest version of the connector, copy the PLAF extractions and transformations into your productive connector, and then add the transformed table into the data model.

  2. If for any reason this table is not used by your company, a second approach would be to create a ‘dummy’ PLAF table. Whereby, you simply create the table with the necessary fields, but don’t load any data into it. You can then join this empty table to the data model.

  3. If the first and second options are not possible, the last suggestion is to modify the KM formulas that reference the PLAF table, whereby you would comment out or delete any reference to PLAF fields. These changes would be stored in your ‘extension’ of the Knowledge model, and can be easily removed in the future if you ever wanted to use the fields again.

    1. This approach is not advised, as it can be very effortful to modify each of the PQL formulas referencing this table (and other tables), especially in the case of PLAF as it is present in a lot of UNION_ALL based functions.