Product Q&A

I have mistakenly registered as a customer in place of partner, how to fix that

As you can see on the print the cases selected is 211 and the graph is showing 217.

Celonis Support ID: 5d3473fe-679f-42ae-ae24-e61c96f4d126

Hi all, I was testing the JDBC Connector 2.85.0-Snapshot on out testing environment, I have test it both in and outside of Docker, I can get the image up and running, however in the logs I have found one line of main] org.ehcache.sizeof.impl.AgentLoader   : Failed to attach to VM and load the agent: class java.io.IOException: Can not attach to current VM --EOM--Does anyone know how can I solve this? Thanks in advance

How we calculate Automation Rate for PR to PO conversion ?

Hello guys,I have this column MAX(TO_TIMESTAMP(LPAD("gb"."demat_entry_date", 19, '0'),'DD.MM.YYYY HH:MI:SS')) AS "date reception" and i want to reduce the date by 2 hours. Exemple : From 2022-10-22 11:51:28 to 2022-10-22 09:51:28 I have tried a lot of formulas without success...

Hello Developers, I am using a dropdown option to select the KPI to display in the world map. My requirement is when i select 1st KPI 100% should be Red but when i select 2nd KPI 100% should be green. Is it possible to update color pattern in this way, if yes could you share details.

I am trying to upload XLS file (just in KBs) . I get the following error. Could you please help?File validation failed. The following error occurred during upload: A part with the name '/docProps/core.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equivalent part names. [M1.12]

Hi Team,I am trying to retrieve the data received from the data connection in a table to machine learning workbench to do some manipulations and write it to another table in datapool.Is it possible?I have tried so far . data_pool = c.data_integration.get_data_pools().find(<pool name>)a=data_pool.get_job(<job id>)b=data_pool.get_table(data_source_id=<sourceid> name=<table name>) But from here i am unable to get the function get_data_frame. Is there any other way?Please let me know.Thank you

Hi Team, would like to know if there is any default integration with the SideTrade (Accounts Receivable) in Celonis?

Is there a use case whereby Celonis was implemented in an Amdocs environment? T-Mobile and Vodafone are both using Amdocs and they are both using Celonis. Was Celonis implemented for Amdocs by these Celonis clients?

Hi, i'd like to count how often cases circle in "waiting" activities. Specificly: How often do cases go from a node like %WAITING% directly to a node like %WAITING% - excluding the source node as target node. Problem: My solution SUM(MATCH_PROCESS(...)) doesn't count multiple waiting loops occurring within the same process but only processes with a waiting loop.Problem: I have no idea how to exclude the source node from the target nodes as both work with the same wildcard. I'm curious for any suggestions for a solution :)

Check Price & Condition, GR with POInvoice ready for paymentcheck price and condition with outline agreement

I have tried looking in the Celonis documentation for a fix but I cannot see this 'succeeded' status explained anywhere. I do not know how to get to the next steps to perform transformations and include the data into my Data Model.

Dear Task mining experts, what are the best practices for Task Mining projects. Like do's and don't, how to start, how long to run data capturing, ......? ThanksBRTimo Peters

Hi all, I'd like to know how to fetch data from data in data pool via pycelonis. Usually I'm using read_excel or read_csv module in my local python but don't know how to read database column from pycelonis. Does anybody know how to do that or sample code in git-hub? Thanks 

Need help to join 2 SAP S/4HANA tables in a data extraction job with child table key value (16 digits leading zeros) and parent (10, 1 leading zero) are formatted slightly differently Tried using Data type conversion CAST_TO_STRING, syntax seems OK, but get error when executing data job: Error setting up extraction. Illegal join path configuration. Used resource neither child nor parent [CAST_TO_STRING(DFKKZP] - [DFKKZP] / [DFKKPOH]. Celonis Support ID: 2b8cab5b-7442-41cc-9878-77ef645eeed1 Able to help?

signup

My hypothesis is because of how the data is setup but wanted to understand why this is happening and how we can fix it.

Hi,In Celonis Studio, I have two different data models: one for AP (Accounts Payable) and another for P2P (Procure-to-Pay). I would like to create a filter on the view that allows me to display documents that have been paid on time or paid late. When I try to apply the filter for the AP model, I receive a message indicating a lack of connection with the corresponding table in the P2P model. My goal is to create a filter that, upon detecting the "paid on time" or "paid late" status in the AP model, will automatically display the documents corresponding to that status in the P2P model. Is there a way to filter documents based on textual values across both models simultaneously, despite the lack of connection between the tables?

I have noticed that Nestle is one of the references. Can you please share what their use case is?

Limited data from client. Header level information/meta data not available. So in case there are 2 activities performed for a single case, the case keys are getting unique but in practical terms, it is duplication.

Hello Celopeers Community, I want to delete or clear a specific range within a table via the Excel Action Flow Module. There is a module which can delete seperate rows but therefor I have to combine it with a repeater.  Is there a way to give a specific range as an input in order to delete these rows? I want to avoid to delete and recreate a new table becase I need the same table IDs for further processes. Many thanks in advanceJan

Hello everyone, Could someone please guide me on how to migrate from C4C to EMS? Or point me to the appropriate documentation, as I can't seem to find it? Thanks in advance.

We have an extractor set-up, but had to manually input a table. Now, we can't call such table in the extractor's data connection schema because it is in a different scope (manual uploads require a global connection, hence the different scope ).