{"id":2509,"date":"2015-02-10T14:50:13","date_gmt":"2015-02-10T13:50:13","guid":{"rendered":"http:\/\/iamwcew.fr.oracle.com\/blog\/?p=2509"},"modified":"2017-11-24T21:46:51","modified_gmt":"2017-11-24T20:46:51","slug":"integration-embed-oracle-docs-dans-une-application-apex","status":"publish","type":"post","link":"https:\/\/gpmfactory.com\/index.php\/2015\/02\/10\/integration-embed-oracle-docs-dans-une-application-apex\/","title":{"rendered":"Int\u00e9gration EMBED Oracle Docs dans une application Apex"},"content":{"rendered":"<h2>Intro<\/h2>\n<p>Pour d\u00e9montrer l\u2019usage de Docs dans une application (avec la technique EMBED), voici une <a href=\"https:\/\/apex.oracle.com\/pls\/apex\/f?p=65218:59:5941263103032::NO:::\">int\u00e9gration simple \u00e0 une application APEX<\/a>\u00a0 d\u00e9j\u00e0 existante .\u00a0<!--more--><\/p>\n<h2>Acc\u00e8s au d\u00e9monstrateur<\/h2>\n<ul>\n<li>Se <a href=\"https:\/\/apexea.oracle.com\/pls\/apex\/f?p=331:100:11450463383170::NO:::\">connecter\u00a0sur le d\u00e9monstrateur<\/a> :<\/li>\n<\/ul>\n<p style=\"padding-left: 60px;\">login:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <strong>vision<\/strong><br \/>\npassword: \u00a0 <b>ll<\/b><\/p>\n<ul>\n<li>Aller dans <em>Customers<\/em><\/li>\n<li>Cliquer sur un des clients existants (<strong><em>Cephalon<\/em><\/strong>, par exemple)<\/li>\n<li>Scroller vers le bas et cliquer sur <em>invoices<\/em>.<\/li>\n<\/ul>\n<p>Pour des raisons de s\u00e9curit\u00e9, il faudra peut-\u00eatre faire glisser un pictogramme d&rsquo;une zone vers une autre.<\/p>\n<h2>Authentification<\/h2>\n<p>Dans ce cas particulier, c&rsquo;est Apex qui a \u00e9t\u00e9 utilis\u00e9 pour le d\u00e9veloppement de l&rsquo;application h\u00f4te. Comme Apex et Docs partagent le m\u00eame I<em>dentity Domain<\/em>, on b\u00e9n\u00e9ficie naturellement du SSO.<br \/>\nS&rsquo;il s&rsquo;agit d&rsquo;une application en <em>on-premise<\/em>, d\u00e9velopp\u00e9e avec une autre technologie, il faut se rappeler que<a href=\"http:\/\/iamwcew.fr.oracle.com\/blog\/index.php\/configuration-de-oracle-docs-en-service-provider-saml\/\"> Oracle Service Cloud peut \u00eatre param\u00e9tr\u00e9 en Service Provider, au sens SAML<\/a>. Par exemple, l&rsquo;utilisateur s&rsquo;authentifie su un ADFS en interne, et sera reconnu automatiquement sur Oracle Docs.<\/p>\n<h2>Annexes<\/h2>\n<h3>Tag html utilis\u00e9:<\/h3>\n<p><span class=\"html-tag\">&lt;iframe <\/span><span class=\"html-tag\"><span class=\"html-attribute-name\">SRC<\/span>=\u00a0\u00bb<a class=\"html-attribute-value html-resource-link\" href=\"https:\/\/scdemos-scuscdc.documents.us2.oraclecloud.com\/documents\/embed\/link\/LF276EB8FFCC7627789757B7C78580E8114D4B29CFDB\/folder\/FA02D85FD3C353E2855E3537C78580E8114D4B29CFDB\/_Invoices\" target=\"_blank\" rel=\"noopener\">https:\/\/XXXXXXXXX.documents.us2.oraclecloud.com\/documents\/<strong>embed<\/strong>\/link\/XXXXXXXX\/folder\/F2855E3537C78580E8114B29CFDB\/_Invoices<\/a>\u00a0\u00bb <\/span><span class=\"html-tag\"><span class=\"html-attribute-name\">width<\/span>=\u00a0\u00bb<span class=\"html-attribute-value\">100%<\/span>\u00a0\u00bb <\/span><span class=\"html-tag\"><span class=\"html-attribute-name\">height<\/span>=\u00a0\u00bb<span class=\"html-attribute-value\">450<\/span>\u00a0\u00bb <\/span><span class=\"html-tag\"><span class=\"html-attribute-name\">frameborder<\/span>=\u00a0\u00bb<span class=\"html-attribute-value\">0<\/span>\u00ab\u00a0&gt;<\/span> <span class=\"html-tag\">&lt;\/iframe&gt;<\/span><\/p>\n<h3>Code PLSQL ajout\u00e9 \u00e0 l&rsquo;application pour g\u00e9n\u00e9rer le tag iframe<\/h3>\n<pre>DECLARE\r\n  folder VARCHAR2(200);\r\nBEGIN\r\n  select CUSTOMER_FLEX_01 \r\n  into folder \r\n  from EBA_CUST_CUSTOMERS \r\n  where id = :P50_id;\r\n  htp.p('&lt;iframe SRC=\"https:\/\/&lt;tenant&gt;.documents.us2.oracleclo  ud.com\/documents\/embed' || folder ||'\" width=\"100%\" height=\"450\" \r\n  frameborder=\"0\"&gt; &lt;\/iframe&gt;');\r\nEND;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Intro Pour d\u00e9montrer l\u2019usage de Docs dans une application (avec la technique EMBED), voici une int\u00e9gration simple \u00e0 une application APEX\u00a0 d\u00e9j\u00e0 existante .\u00a0<\/p>\n","protected":false},"author":1,"featured_media":2849,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"ppma_author":[150],"class_list":["post-2509","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"authors":[{"term_id":150,"user_id":1,"is_guest":0,"slug":"admin8700","display_name":"Patrick","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/209d5ed69b74d288390621ab4c1d3773?s=96&d=mm&r=g","0":null,"1":"","2":"","3":"","4":"","5":"","6":"","7":"","8":""}],"_links":{"self":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/2509","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/comments?post=2509"}],"version-history":[{"count":4,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/2509\/revisions"}],"predecessor-version":[{"id":3922,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/posts\/2509\/revisions\/3922"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/media?parent=2509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/categories?post=2509"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/tags?post=2509"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/gpmfactory.com\/index.php\/wp-json\/wp\/v2\/ppma_author?post=2509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}