General Product Q&A

Hi everyone, I’ve got the following Issue:I have an action flow that queries data and builds up an HTML view in the form of a table for all its entries.In the end I  trigger a Process Automation Skill to send an email via the “Email by Celonis” action. My hyperlink is correctly tagged with:<a href="https://url:port/sap/bc/gui/sap/its/webgui?~transaction=*transactionname%20table-field%3Dsalesorder%3BDYNP_OKCODE%3D%2F00%23" rel="noopener noreferrer" target="_blank"> salesorder</a> but in the mail I only receieve the text “salesorder” without the hyperlink. On the other hand when I use the URL as the hyperlink text it gets through with the mail:<a href="https://url:port/sap/bc/gui/sap/its/webgui?~transaction=*transactionname%20table-field%3Dsalesorder%3BDYNP_OKCODE%3D%2F00%23" rel="noopener noreferrer" target="_blank"&gt

hello team, i want to find how many days between invoice date and clear date in olap table. i just do "clear date" - "invoice date" but the result is weird very big numbers like millions. i just want normal days count. what is wrong with my code please help me

I have a few Architects who want training material for mapping Scenario Process maps - we have had minimal training for this and cannot find any documentation.One question is, once a Scenario is published to the Navigator and its associated processes are clicked on to view, there is no easy way to be taken back to the Scenario home page to explore more processes with in that scenario? 

I am using the free training environment in Celonis Academy.Studio was initially available, but after I deployed an App as the guide instructed, I encountered an error that says "I am not allowed to this page" or some sort. Now the Studio button is missing. I'm only seeing the Data, MarketPlace, Search  and Help Center

Hi receiving this error “Missing value of required parameter ‘Value’. All values are filled in from get rows. I have replaced the values in the write back to data pool saved and deployed and it is still not working correctly.   

Hi everyone,I’m exploring ways to improve real-time communication in process workflows, especially for critical events like payment failures, delivery delays, or approval escalations.Currently, most setups rely on email or SMS notifications, but in some cases, those don’t get immediate attention. I’m considering using programmable voice calls as an alternative for high-priority alerts.For example:Triggering an automated call when an SLA is breached Voice alerts for urgent approvals Escalation calls when a process is stuckHas anyone here tried integrating voice-based notifications with Celonis (via APIs or external systems)?Also curious about:Best way to trigger voice calls from Celonis (Action Flows / APIs?) Handling retries or fallback logic Any real-world use cases where voice alerts improved process efficiencyI came across some programmable voice API

Dear Community,In our Order Management Execution App we use various dropdown filter components.The filters, e.g. Sales Group filter, show the value like Sales Group code and the count of sales documents for each sales group code.However, the filter also brings up old Sales Group codes with 0 sales documents.Is there any way to exclude the filter values with 0 sales documents?I already tried to use a NULL filter on the filter component but this did not work.Any ideas?Looking forward to your replies.Thank you and kind regards,Michaela

In a Celonis Action Flow triggered by Microsoft SharePoint Online (Watch Items), a filter evaluates to FALSE even though it should logically evaluate to TRUE. The filter expression used is substring(lower(23.Fields.Title); length(23.Fields.Title) - 1; 1) = 's', where 23.Fields.Title is a SharePoint list Title field. At runtime, the resolved value of 23.Fields.Title (confirmed via the Filter Inspector and the SharePoint bundle payload) is C310-260430061344S, which clearly ends with the character S, so the expected result is that the filter condition evaluates to TRUE and allows the bundle to pass. However, the actual result is that the bundle does not pass the filter, and the execution log reports “The bundle did not pass through the filter,” with no errors or warnings.As we are currently facing errors when attempting to raise a ticket via Celopeers and the email support channel is not available, we are posting t

In my table Nomination, the following columns are there Key, KeyType, SourceKey. I want to add an augmented attribute called SourceKeyType with the following logic : For each record in Nomination, I need to find its SourceKey and find the KeyType Corresponds to that SourceKey. For example :Key KeyType SourceKey 1 GOM 2 2 TRA NULL  After defining augemented attribute  Key KeyType SourceKey SourceKeyType 1 GOM 2 TRA 2 TRA NULL NULL  How to model the PQL?

I have trigger-based task list configured in a view. Is there any way to close the tasks in bulk instead of one by one?

Hi all, I have a column with multiple values   e.g. col_list = '21651,5615561,50615,561591' per case_keyI need to split the values in four different rows when showing an OLAP table in studio.Some  case_keys present up to 5000 values in that column. Thank you for your help, Leonardo

I am having an issue with dates and exporting to csv. They are both kpis but any way I set it up its not coming over in any format. Need some help to get this working to show as MM/DD/YYYY. Result of the action flow Result after action flow runs  KPI 1

Hi, I was going through academy links for Process Copilot but I don’t see the “Inspect response” option. has this been changed recently? 

Hello CommunityI played a little bit with augmented attributes and now want to fully delete it.As you can see in the screenshot I deleted the augmented attributes within the Knowledge Model but the corresponding records still occur. The “delete” button is disabled.Question: How can I fully delete this unneeded stuff?Best, Thomas  

Hi Everyone, I am working on a particular information to check to extract which is User Group Permission  and User Group through the ML Work bench.  Please keep your thought for helping. Thanks,Shakthi

HiI have a Annotation Builder run that is stuck at 80/100 transactions. When I click the cancel button it does not cancel. When I click the stop button it does not stop. When I do this enough it does stop - but when I run the next set it starts up again

I am working on an engagement where we want to create Purchase Orders (PO) in SAP triggered from Celonis based on Purchase Requisitions (PR). We are trying to implement this via Action Flows using an RFC call (BAPI_PO_CREATE1). We have the following scenarios: Mirror PR – All PR lines in one PO with identical lines Combine PR – Combine several PRs into one PO Individual – Multiple PR lines are converted into individual POs Add PR – Add PR lines into an existing PO For scenarios 1, 2, and 4, there can be multiple PR line items that need to be created within a single PO (or appended to an existing PO).Current ChallengeWe are facing issues in structuring and passing multiple line items from Celonis to SAP within a single RFC call. Specifically:We are able to fetch multiple PR line items using “Get Rows”We are using Array Aggregators to construct r

Dear Colleagues, I have a simple Action Flow where I “Get Rows” (Celonis module), then I “Create Excel” (XLSX Excel files module) containing the data I selected, then I “Send an Email” (Email module) with the excel I had created.Everything works, however in the “Create Excel” module where I do include headers, finally in the excel file they look like this: “O_CELONIS_PURCHASEORDER.PurchaseOrderItem” - is there any way to customize these headers or at least get rid of the first part “O_CELONIS_PURCHASEORDER”?Thanks and kind regards, Malgorzata 

We have a Celonis view with KPIs defined in the Knowledge Model. These KPIs use time-based filters with variables like datefrom and dateto inside the PQL-code.For example:"o_celonis_VendorInvoiceItem"."CreationTime" NOT BETWEEN {d '${datefrom}'} AND ADD_DAYS({d '${dateto}'}, 1)and elsewhere in the same KPI:"el_custom_SalesOrderItem"."TIMESTAMP" BETWEEN {d '${datefrom}'} AND ADD_DAYS({d '${dateto}'}, 1) When exporting this view to Excel via Action Flows, the Get Rows module lets me reference the Knowledge Model, but I cannot pass values for these variables.Using the Data Model instead allows variable injection in PQL, but then I lose access to predefined KPIs and calculated attributes, resulting in very complex, hard-to-maintain code.Question:Is there a way to dynamically set the variables of Knowledge Model KPIs when using Action Flows?

Hello community, I have seen that some features are not working perfectly in the Studo Analysis and there are a lot of migration tool available from Studio Analysis to Views. Is there known the future of Studio Analysis? We have quite some use cases still in this older technology and I would like to assess the urge for migration. Thanks a lot.Jan

Hi, is there a way to see/use autogenerated KPI in the View?

Is there a way to copy an existing asset to a blank tab on another asset within the same package?Context: Separate assets were created vs tabs but want to combine into the same asset so the filtering is carried out through all tabs. Will I have to recreate the “separate” assets within the new tab?

We have 2 spaces for P2P. 1 is P2P dev and other is P2P. The P2P is the one when we deploy users see. So there was a change made by 1 person in P2P dev which I used copy to and I have overwritten the original view in P2P and Published it. Later I got to know few people have crucial changes in P2P which got overwritten and they had not published the changes as well. Is there any way we can revert back to way it was?

“Managing existing users” page (https://docs.celonis.com/en/managing-existing-users.html) is outdated.It is possible to lock users with the “User locking policy” setting but I see no option to unlock them.The only bypass I found was to remove users then to reinvite them. 

I want to calculate cumulative sum for column ‘Net Weight’ by Year . Below picture is result i want to have.Column definition:‘SO Created Year’ = ROUND_YEAR("VBAK"."ERDAT") ‘Created Month’ = ROUND_MONTH("VBAK"."ERDAT") ‘Net Weight’ =  KPI(“so_netweight”) Cumulative Sum=         if I use formula : RUNNING_SUM(kpi("so_netweight"),order by("vbak"."so_creatd_year"), partition by("vbak"."created_month_so_"))  , i got below error.  can anyone help ?