{"id":2749,"date":"2020-10-05T10:34:54","date_gmt":"2020-10-05T17:34:54","guid":{"rendered":"http:\/\/www.projectp.com\/ppblog\/?p=2749"},"modified":"2022-11-17T14:13:43","modified_gmt":"2022-11-17T22:13:43","slug":"customer-solution-success-oracle-e-business-suite-and-oracle-unifier-integration-framework","status":"publish","type":"post","link":"https:\/\/www.projectp.com\/ppblog\/2020\/10\/05\/customer-solution-success-oracle-e-business-suite-and-oracle-unifier-integration-framework\/","title":{"rendered":"Oracle EBS and Unifier Integration Framework"},"content":{"rendered":"<p><strong><em>Project Partners Blog Author:<br \/>\n<span style=\"color: #3366ff;\">Sachin Gupta | Oracle Primavera Solution Architect \u2013 Application Integration Specialist<\/span><\/em><\/strong><\/p>\n<h2><strong>Oracle E-Business Suite and Oracle Primavera Unifier Integration Framework<\/strong><\/h2>\n<p>Project Partners implemented this solution for a large metropolitan transportation customer using an on-premise Oracle EBS solution framework.<\/p>\n<p>The project involved the customer implementing Oracle Unifier cloud a few months prior. They were looking for an effective solution to load actuals from on-premise Oracle EBS to Oracle Unifier Cloud. They had created a business process in Oracle Unifier for actuals transaction and enabled integration.<\/p>\n<p>The customer did have one simple requirement. They needed a scalable solution to load eligible actuals transaction from on-premise Oracle EBS to Oracle Unifier cloud daily using a REST API.<\/p>\n<p>As the project moved forward, we conducted our due diligence and dug deeper, identifying a few more items that needed to be appropriately addressed:<\/p>\n<ul>\n<li>The ability to introduce new attributes in the integration equilibrium may require updating all transactions in Unifier with the data from EBS.<\/li>\n<li>Avoid duplicate transactions.<\/li>\n<li>The capability of identifying and creating\/updating transactions and, in rare scenarios, deleting transactions from Unifier to keep it always in sync with Oracle EBS.<\/li>\n<\/ul>\n<p>After reviewing various options with the customer, they agreed on the framework shown below:<\/p>\n<ol>\n<li>Utilize Oracle EBS concurrent requests to populate data daily in a staging table.<\/li>\n<li>Pull data from Oracle Unifier Cloud in the staging table.<\/li>\n<li>Compare the data in two staging tables to identify new and modified data.<\/li>\n<li>Call Oracle Unifier Rest API to process the data.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/10\/10-5-2020-12-29-46-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-2751\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/10\/10-5-2020-12-29-46-PM.png\" alt=\"\" width=\"726\" height=\"145\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/10\/10-5-2020-12-29-46-PM.png 666w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2020\/10\/10-5-2020-12-29-46-PM-300x60.png 300w\" sizes=\"auto, (max-width: 726px) 100vw, 726px\" \/><\/a><\/p>\n<p>Noted advantages of this framework:<\/p>\n<ul>\n<li>Scalable \u2013 It can easily process a volume of 100,000 transactions daily.<\/li>\n<li>Automated \u2013 It can identify new vs. modified data and discard data that do not require change.<\/li>\n<li>Extensible \u2013 New attributes introduced for integration can be easily populated for all existing transactions in Oracle Unifier Cloud.<\/li>\n<\/ul>\n<p style=\"text-align: left;\">Project Partners: a long-standing Oracle Partner and global leader in optimizing business processes and IT investments within project-driven organizations.<\/p>\n<p style=\"text-align: left;\"><a href=\"http:\/\/www.projectp.com\/\">www.projectp.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog outlines a large Metropolitan Transportation Provider&#8217;s customer success story upon providing an integration framework between Oracle E-Business Suite and Oracle Primavera Unifier. Read about the integration framework our expert implementation consultants provided and the advantages it had for scalability, automation, and visibility: <\/p>\n","protected":false},"author":79,"featured_media":3117,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[115,75],"tags":[255,258],"class_list":["post-2749","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-ebs","category-oracle-primavera","tag-implement-service","tag-client-use-cases"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/2749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/users\/79"}],"replies":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/comments?post=2749"}],"version-history":[{"count":0,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/2749\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/media\/3117"}],"wp:attachment":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/media?parent=2749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/categories?post=2749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/tags?post=2749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}