{"id":2056,"date":"2020-05-20T19:40:35","date_gmt":"2020-05-20T19:40:35","guid":{"rendered":"https:\/\/processminery.com\/?p=2056"},"modified":"2025-06-09T18:37:43","modified_gmt":"2025-06-09T18:37:43","slug":"connect-oracle-erp-cloud-with-celonis-ems","status":"publish","type":"post","link":"https:\/\/processminery.com\/index.php\/connect-oracle-erp-cloud-with-celonis-ems\/","title":{"rendered":"Connect Oracle ERP Cloud with Celonis EMS"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2056\" class=\"elementor elementor-2056\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-634467a4 elementor-section-boxed elementor-section-height-default elementor-section-height-default parallax_section_no qodef_elementor_container_no\" data-id=\"634467a4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6328561c\" data-id=\"6328561c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-361fd053 elementor-widget elementor-widget-text-editor\" data-id=\"361fd053\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In Celonis IBC we can analyse our Procure to Pay process and identify potential improvements and support the execution of these improvements. We can connect Celonis IBC to many systems. In this example we setup the connection between Celonis IBC and Oracle ERP Cloud for the Procure to Pay process.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-19c17a6 elementor-widget elementor-widget-qodef_blockquote\" data-id=\"19c17a6\" data-element_type=\"widget\" data-widget_type=\"qodef_blockquote.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\n<blockquote class=\"qodef-blockquote-shortcode\"  >\n\t<h4 class=\"qodef-blockquote-text\">\n\t<span>Define Data Connection<\/span>\n\t<\/h4>\n<\/blockquote>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-086a7ca elementor-widget elementor-widget-text-editor\" data-id=\"086a7ca\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In Celonis Event Collection we define a new connection to the Oracle ERP Cloud instance. We use the standard available connector to connect to Oracle ERP Cloud. The connector is already configured to use specific API\u2019s in Oracle to extract the data.<\/p><p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-3421 size-medium\" src=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/connection_oracle_erp_cloud-300x175.png\" alt=\"\" width=\"300\" height=\"175\" srcset=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/connection_oracle_erp_cloud-300x175.png 300w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/connection_oracle_erp_cloud.png 316w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter is-resized\">We connect to the Oracle ERP Cloud instance with an integration user that has roles assigned in Oracle that allow extracting Procurement and Payables data via the standard API\u2019s from Oracle.<\/figure><p><img decoding=\"async\" class=\"aligncenter wp-image-3422 size-large\" src=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/new_data_connection_oracle_cloud-1024x822.png\" alt=\"\" width=\"1024\" height=\"822\" srcset=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/new_data_connection_oracle_cloud-1024x822.png 1024w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/new_data_connection_oracle_cloud-300x241.png 300w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/new_data_connection_oracle_cloud-768x617.png 768w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/new_data_connection_oracle_cloud.png 1188w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p><\/div><div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container\"><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><\/figure><\/div><\/div><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t<div class=\"elementor-element elementor-element-73fbccf e-flex e-con-boxed e-con e-parent\" data-id=\"73fbccf\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0b67603 elementor-widget elementor-widget-qodef_blockquote\" data-id=\"0b67603\" data-element_type=\"widget\" data-widget_type=\"qodef_blockquote.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\n<blockquote class=\"qodef-blockquote-shortcode\"  >\n\t<h4 class=\"qodef-blockquote-text\">\n\t<span>Define Data Extraction<\/span>\n\t<\/h4>\n<\/blockquote>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e6edeb1 e-flex e-con-boxed e-con e-parent\" data-id=\"e6edeb1\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-228c5ee elementor-widget elementor-widget-text-editor\" data-id=\"228c5ee\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>We define the data extraction and we see the API\u2019s that are used by the connector. We configure the data to be extracted from Oracle ERP Cloud. Depending on the table we can define a creation date filter to limit the initial extraction and we can add a change date filter for delta loads.<\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" class=\"aligncenter wp-image-3420 size-large\" src=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/data_extraction-1024x860.png\" alt=\"\" width=\"1024\" height=\"860\" srcset=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/data_extraction-1024x860.png 1024w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/data_extraction-300x252.png 300w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/data_extraction-768x645.png 768w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/data_extraction.png 1337w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2ae2cc9 e-flex e-con-boxed e-con e-parent\" data-id=\"2ae2cc9\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-01eabc8 elementor-widget elementor-widget-qodef_blockquote\" data-id=\"01eabc8\" data-element_type=\"widget\" data-widget_type=\"qodef_blockquote.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\n<blockquote class=\"qodef-blockquote-shortcode\"  >\n\t<h4 class=\"qodef-blockquote-text\">\n\t<span>Define Transformations<\/span>\n\t<\/h4>\n<\/blockquote>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-98c177e e-flex e-con-boxed e-con e-parent\" data-id=\"98c177e\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4e4260b elementor-widget elementor-widget-text-editor\" data-id=\"4e4260b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The Oracle ERP Cloud connector in Celonis already contains a large number of transformations. We can define additional transformations depending on the requirements. In this example we only use the standard available transformations.<\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3419 size-large\" src=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/transformations-1024x643.png\" alt=\"\" width=\"1024\" height=\"643\" srcset=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/transformations-1024x643.png 1024w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/transformations-300x188.png 300w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/transformations-768x482.png 768w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/transformations.png 1300w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-cbf3ebc e-flex e-con-boxed e-con e-parent\" data-id=\"cbf3ebc\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a3c5245 elementor-widget elementor-widget-qodef_blockquote\" data-id=\"a3c5245\" data-element_type=\"widget\" data-widget_type=\"qodef_blockquote.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\n<blockquote class=\"qodef-blockquote-shortcode\"  >\n\t<h4 class=\"qodef-blockquote-text\">\n\t<span>Define Data Model<\/span>\n\t<\/h4>\n<\/blockquote>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-985c5cf e-flex e-con-boxed e-con e-parent\" data-id=\"985c5cf\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c2cddc7 elementor-widget elementor-widget-text-editor\" data-id=\"c2cddc7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>We use the standard data model that is linking the activities table, the cases table and all the additional views or tables that contain additional information.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0eba815 e-flex e-con-boxed e-con e-parent\" data-id=\"0eba815\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c2f2728 elementor-widget elementor-widget-qodef_blockquote\" data-id=\"c2f2728\" data-element_type=\"widget\" data-widget_type=\"qodef_blockquote.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\n<blockquote class=\"qodef-blockquote-shortcode\"  >\n\t<h4 class=\"qodef-blockquote-text\">\n\t<span>Execute Data Job and Data Model<\/span>\n\t<\/h4>\n<\/blockquote>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ace176e e-flex e-con-boxed e-con e-parent\" data-id=\"ace176e\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-75104d3 elementor-widget elementor-widget-text-editor\" data-id=\"75104d3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>We execute the data job and load the data model. We define a schedule to execute the data job once a day. The data job is extracting the data from Oracle ERP Cloud and performs the transformations. The data model load is loading the data into the Celonis process mining engine.<\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3415 size-large\" src=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/data_extraction_log-1024x580.png\" alt=\"\" width=\"1024\" height=\"580\" srcset=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/data_extraction_log-1024x580.png 1024w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/data_extraction_log-300x170.png 300w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/data_extraction_log-768x435.png 768w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/data_extraction_log.png 1209w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3b949a1 e-flex e-con-boxed e-con e-parent\" data-id=\"3b949a1\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e773e89 elementor-widget elementor-widget-qodef_blockquote\" data-id=\"e773e89\" data-element_type=\"widget\" data-widget_type=\"qodef_blockquote.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\n<blockquote class=\"qodef-blockquote-shortcode\"  >\n\t<h4 class=\"qodef-blockquote-text\">\n\t<span>Process Analytics<\/span>\n\t<\/h4>\n<\/blockquote>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0ea900f e-flex e-con-boxed e-con e-parent\" data-id=\"0ea900f\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5f52a44 elementor-widget elementor-widget-text-editor\" data-id=\"5f52a44\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"post_inner_content\"><p>Now we can start analyzing all the Procure to Pay process data from Oracle ERP Cloud in Celonis. We can use the process explorer, variant explorer and all other analytical options in Celonis to analyse the process.<\/p><p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-3411 size-large\" src=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/variant_explorer-1024x735.png\" alt=\"\" width=\"1024\" height=\"735\" srcset=\"https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/variant_explorer-1024x735.png 1024w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/variant_explorer-300x215.png 300w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/variant_explorer-768x551.png 768w, https:\/\/processminery.com\/wp-content\/uploads\/2023\/09\/variant_explorer.png 1452w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Connect Oracle ERP Cloud with Celonis IBC In Celonis IBC we can analyse our Procure to Pay process and identify potential improvements and support the execution of these improvements. <\/p>\n","protected":false},"author":2,"featured_media":2182,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[89,65],"tags":[49,93,74],"class_list":["post-2056","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-fusion","category-process-connectors","tag-celonis","tag-oracle-fusion","tag-process-connector"],"_links":{"self":[{"href":"https:\/\/processminery.com\/index.php\/wp-json\/wp\/v2\/posts\/2056","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/processminery.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/processminery.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/processminery.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/processminery.com\/index.php\/wp-json\/wp\/v2\/comments?post=2056"}],"version-history":[{"count":36,"href":"https:\/\/processminery.com\/index.php\/wp-json\/wp\/v2\/posts\/2056\/revisions"}],"predecessor-version":[{"id":3759,"href":"https:\/\/processminery.com\/index.php\/wp-json\/wp\/v2\/posts\/2056\/revisions\/3759"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/processminery.com\/index.php\/wp-json\/wp\/v2\/media\/2182"}],"wp:attachment":[{"href":"https:\/\/processminery.com\/index.php\/wp-json\/wp\/v2\/media?parent=2056"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/processminery.com\/index.php\/wp-json\/wp\/v2\/categories?post=2056"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/processminery.com\/index.php\/wp-json\/wp\/v2\/tags?post=2056"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}