Product Q&A

Hello dear community members, A little while ago the process management topic received its own section at the Celonis community page and I would like to take this opportunity to introduce myself and provide a little bit of context around this little part of our larger community website.My name is Caspar Jans and I head up the global go-to-market team for the Celonis Process Management solution (hence the name of this section: process management). I've been in this space (BPM) for about 15-20 years now and I am looking forward to interact with all of you on this community page, at events or in customer calls.One important aspect to highlight here, is that when we speak about process management, we usually refer to process modeling and process governance and not about the process mining aspect (which is covered in the rest of the community website). We have a number of experienced CPM Specialists, Services Consultants and Support Engineers at the ready to answer your questions. I will al

Hi everyone,I’m trying to connect MongoDB to Celonis. At first, I assumed that I’d need to use a custom JDBC driver (based on a thread that I’ve read here and the Celonis documentation).However, when I reached the step to select the “Database Type” in the connector, I couldn’t find a fitting option for MongoDB.Has anyone successfully set this up?Should I use a specific Database Type in this case? Or is there another workaround to get MongoDB connected?Thanks for any tips or guidance! 

Having a frustrating recurring issue and not sure what the actual fix is at this point.We have several Action Flows that send emails via an Outlook account. Every few days, one or more of them deactivate automatically with this error in the Send Email module:Invalid login: 535 5.7.139 Authentication unsuccessful, basic authentication is disabled.Reconnecting the email connection seems to help temporarily but the error comes back after a few days. Has anyone dealt with this, or found a more permanent fix?

Hitting a wall with an extraction of tens of millions of rows from Amazon Athena via the SQL editor. The pull itself seems to finish without complaint, but the pipeline then breaks at the Data Push Job step with an InternalException.A couple of things I've noticed:A similar extraction through the visual editor (same columns, but a much smaller row count) runs without any issue as part of the daily load, so I don't think it's the source system itself causing this. I only moved to the SQL editor because I needed JOIN and CAST logic that the visual editor doesn't support. Not sure yet whether it's the volume or the JOIN/CAST operations that's actually the trigger.Has anyone hit Data Push failures at this scale, or specifically with JOIN/CAST in SQL editor extractions? Any insight into what usually causes this would help.

Hi! I tried to add a new table to my data model (EORD) linked to EINE vía WERKS, MATNR, SYS_ID, MANDT, EKORG, ESOKZ, LIFNR.If I check this unique key in EINE ( Using: select WERKS,MATNR,SYS_ID,MANDT,EKORG,ESOKZ,LIFNR, count(*) AS Amount FROM ALL_NPM_EINE group by WERKS,MATNR,SYS_ID,MANDT,EKORG,ESOKZ,LIFNR order by Amount DESC ) and there is only one case per combination. So in a 1:N relationship it should work or? (EINE 1 → N EORD)Error Message: Case insensitive duplicated joins detected between tables: [EORD] and [EINE].

I'm working with a REST API that returns doubly-nested JSON (think: a top-level array of objects, each containing a nested array, which itself contains another nested array). Celonis splits this correctly into three separate tables, and the parent key from the top level propagates fine into the first nested table. The problem is that it stops there.The second-level nested table has no reference back to the top-level parent. The intermediate ID that's available at that level isn't unique (it's a type identifier that's the same across all top-level records), so I have no way to join the second-level table back to a specific top-level record without getting a cartesian product.The root issue as far as I can tell: in the Connector configurator, you can only choose from fields that exist in the API response as Primary Key. The propagated parent key that Celonis adds to the first nested table isn't available as a selectable column when configuring the second nested table, so there's no way t

Working on an OCPM data model and running into an issue where transformations based on SAP tables won't preview or publish anymore, regardless of which specific transformation it is, even standard Celonis ones fail as long as an SAP table is involved.A few observations:Transformations on other source systems (e.g. Dynamics AX) seem unaffected, so it looks specific to SAP tables somehow. Saving with validation fails outright, saving without validation works, but publish still isn't possible afterward. Existing, unchanged transformations still seem to run fine in the backend, so this feels isolated to the Objects & Events interface specifically.Anyone run into something similar with SAP-table-based transformations?

Been pulling my hair out on this one. I'm the admin of our space and have full permissions, but the gear icon in the ML Workbench that's supposed to let you adjust memory allocation is just... not there. Checked on multiple browsers, different devices, had a colleague confirm it's not showing up for them either.The script I'm trying to run keeps failing or hitting memory errors, and it's something our team relies on daily, so this is becoming a real problem. I've gone through the usual troubleshooting (refreshes, browser switches, confirmed admin rights) and I'm stuck.Is there something I'm missing on the permissions side, or is there a way to enable this?

We're trying to set up an automated PDF report using Action Flows and running into a few limitations we'd like to understand better before deciding how to proceed.Our setup: a view with multiple tabs, one of which renders differently depending on a variable (basically acts like a toggle filter). We want to export a combined PDF that includes content from different tabs, including three versions of that one tab with different variable values, and send it to a group of users automatically at least twice a week.Two things we've hit:Separating tab IDs with commas in the Create PDF module didn't produce the multi-sheet output we expected. Not sure if we're doing something wrong or if this just doesn't work as described. We're not sure if variables can only be set through manual interaction, or whether there's a way to pass them in when an Action Flow runs on a schedule.Is the desired output achievable in some form, and if so, what's the recommended approach?

Large history table extraction keeps hitting an Athena query timeout.I'm stuck on a recurring issue when pulling a large history table through Data Integration → Extractions. No matter whether I build it in the visual editor or the SQL editor, the run dies after a long-running query with:[Simba]AthenaJDBC An error has been thrown from the AWS Athena client. Query timeoutI already tried cutting the row count by joining the history table against a header table first, no change. The only version that actually finishes is one where I add a hard date cutoff, but that obviously leaves out a chunk of history I actually need.Anyone dealt with this on larger Athena-backed extractions? Looking for a way around the timeout that doesn't mean sacrificing part of the dataset.

Hi Everyone,I am currently setting up the Duplicate Invoice Checker (Catalog 3) app using the Accounts Payable Catalog (v3.0.1).After enabling the Accounts Payable catalog in Objects & Events, the objects VendorAccountCreditItem and VendorAccountDebitItem were not created (only VendorAccountItem exists). When running the autogenerated job auto_generated_dic_combine_vendor_credit_debit_account_items, I encounter the following error:Relation "1a2b3c4d5e_OCDM.o_celonis_VendorAccountCreditItem" does not exist. Please review your query and try again.Environment Details: Accounts Payable Catalog: Version 3.0.1 App: Duplicate Invoice Checker (Catalog 3 / OCPM) AI Annotations / Signals: Enabled and in "Ready" status Has anyone encountered this issue when migrating or deploying the OCPM version? Is there an updated perspective or script that replaces the VendorAccountCreditItem reference with VendorAccountItem? Any guidance on how to resolve this missing relation would be greatly apprec

I have the below two columns. I want to extract the portion of the string matching the value in the ‘Seq’ column. Example, for the first row, the seq value is 400. In BIND column, I want to extract the strings that match the value the 400.Till the semicolon. using PQL. 

Hi guys,does anyone has a template to document a project implementation?We mainly have implemented automations, anybody having experience in that?Thanks a lot.

I asked a similar question some time ago, still looking for an elegant solution:Context:Currently we do all the extraction within one Data pool, that does also contain the OCPM objects and events. Since we start to connect additional systems, we want to use the approach “1 dedicated Data pool per system, 1 common Data pool for all OCPM objects and events data”Problem:I hoped to simply rebuild the existing extractions in a new Data pool and then switch the Data source within the OCPM-transformations to the new Data pool. This works totally fine for custom objects, but for Celonis objects the Data source is read-only:  What is the most “elegant” solution?One approach would be to create a view for each table: view in the old data source pointing to the underlaying table of the new data pool. ...quite a lot of (maintenance) effort and not sure whether this would work.Another approach is to create full overwrites of all transformations. But by this you loose the connection to the official c

Dear Community, we have developed a 3-way-match knowledge model with Celonis to implement our touchless invoice case. - SAP S/4 HANA on-premises with Release 2025 FPS01 and the xSuite invoice processing solution- The document is routed via the OCR server to the xSuite Invoice Monitor, where the header table /WMD/FP_IVHD and the line item table /WMD/FP_IFIVI are populated and a unique record number is assigned; up to this point, there is no entry in the standard SAP tables RSEG or RBKP- A delta load is performed every minute into the Celonis Knowledge Model, and a check is carried out to determine whether a 3-way match exists; if so, an action flow is triggered, a JSON payload is created and sent to the SAP Supplier Invoice API, and the document is posted Problem:The SAP document number and ‘closed’ document status are not synchronised with the xSuite tables, so the document remains in the xSuite Invoice MonitorThe Business Transaction Event is normally triggered via the xSuite applicat

Hi everyone,I'm working with Celonis Machine Learning Workbench (MLWB) and a Knowledge Model as the data source.Current setup:Data is queried from a Knowledge Model into MLWB. A Python/scikit-learn model is trained successfully. Predictions are generated and stored in a pandas DataFrame. The goal is to visualize those prediction results in a Studio View/dashboard.The challenge:I can generate the prediction table in MLWB, but I have not found a way to make the prediction output directly available in Studio.I'm specifically looking for a solution that does not require:Exporting a CSV from MLWB Uploading the CSV into Data Integration Manually creating new data tablesInstead, I'm trying to understand whether there is a more native integration pattern between MLWB and Studio.QuestionsIs it possible to expose a DataFrame or ML prediction output from MLWB directly to a Studio View? Can MLWB prediction results be persisted as a Knowledge Model asset, View asset, or another object that Studio c

I want to learn Ai in celonis! can i only focus on a specific Ai path ? as Ai is something I'll really like to learn.. Ai is future and i want to upskill myself in Ai plus celonis.. is there need of anything beforehand?

Hello everyone, Has anyone tried to use PAM models in Process Simulation already?It’s just been released (August 28), but when I tried to create a new scenario, the option to select a PAM model does not exist (neither in Apps nor in Studio when configuring a model).The documentation just says “In Process Simulation, in the Simulation Configuration Wizard, select your PAM model.”Link to the documentation : Using a PAM model in Process Simulation scenarios Thanks in advance,Joao 

Hi everyone,I need help figuring out how to execute a Machine Learning script directly from a button in my Celonis app in views (dashboard). I believe I might need to use Action Flows, but I’m unsure about the exact steps to make this work.Here’s what I want to achieve: When a user clicks a button in the Celonis app, it should trigger an ML script. The script could be hosted externally (e.g., a REST API) or executed within Celonis.( atm its not hosted, there is just a file in ipynb format, stored in ml workbench in  analysis. I need guidance on how to set up the Action Flow and link it to the button. Has anyone implemented something similar? If so, could you share the best approach and any potential challenges I should be aware of?Thank you in advance!

Hello Community,We have a complex data model in which the user must set three date filters (different source fields) with the same date in order to get the desired result.Like I said, he has to do it three times.Is there a convenient solution (data picker) where the user only has to set the date filter once, and the filter is applied to all three source fields?Best, Thomas 

I have multiple action flows seggregated by country and other attributes. All the AFs are writing to the same table in the data pool. Due to the execution runtime limit, I had to create multiple action flows instead of one action flow.Now all the AFs are scheduled to be executed every Monday. I can not schedule all AFs half an hour apart, as the count of AFs will only grow in the future and writing back to the data model for all AFs may take more than a day to complete.  And to use trigger at each AF is troublesome to maintain.Is there any easy way, where I can trigger the first AF execution on Monday and all other AFs will be executed one by one without any deadlock. 

Hey team,I am going through the task mining course by celonis and as I follow through the course, I am unable to create a task mining project under the task mining session, every time when I create a task mining project it is created under data integration session instead of the project session in task mining. Have anyone faced a similar issue if yes what was the solution?Thanks in advance,Akshay

Hi all,I'm trying to build a cumulative distribution curve in Studio using a line chart.Along the X Axis I have a KPI which gives me 1, 2, 3 , 4, days and so on. On the Y Axis I’m trying to show a cumulative count of items which took the amount of days shown on the X Axis to do something.I have the error in the line chart that there is undefined behaviour, no ORDER BY specified, because in the Line Chart I cannot sort by the KPI used for the X Axis.When incorporating ORDER BY as follows:    RUNNING_SUM( KPI("this is a count(distinct….) kpi"),    ORDER BY (KPI("nr. of days") ASC))I am told that I cannot use the count aggregation function together with a dimension function input.Has anyone faced something similar and found a solution? When I put the two data points into a table and sort the table by the Nr of days it works pefectly but the same sorting functionality is not taken over when I switch that sorted and functioning table to a line chart.Any ideas? Your feedback would be very mu

Hi ,We are building a Core-Plus-Delta localization architecture in Celonis Process Designer/Manager (Symbio). We have a single global master process (e.g., HR-7-3-1a) where specific steps (e.g., Step 16) need to trigger country-specific localized tasks across 10 APAC countries (CN-1a, MY-1a, SG-1a, etc.).Since the Process reference field on a task/call activity node enforces a 1-to-1 limit:What is the recommended best practice in Symbio to link 1 global step to 10 country localized sub-processes?How do you configure this so end-users in Process Navigator get a seamless 1-click experience via Scope Filters (Locations attribute) without seeing duplicate global steps?Thanks!

Hi Team, Anyone worked on Apache Kafka data connection, if so please provide relevant documentation and steps how to extract tables from it.