{"id":211,"date":"2013-05-28T14:10:49","date_gmt":"2013-05-28T14:10:49","guid":{"rendered":"http:\/\/degenio.com\/blog\/?p=211"},"modified":"2013-05-28T14:10:49","modified_gmt":"2013-05-28T14:10:49","slug":"migrating-from-oracle-forms-to-apex","status":"publish","type":"post","link":"https:\/\/degenio.com\/blog\/2013\/05\/migrating-from-oracle-forms-to-apex\/","title":{"rendered":"Migrating from Oracle Forms to APEX"},"content":{"rendered":"<p>Yesterday, I \u00a0gave an impromptu talk about migrating from Oracle Forms to APEX. The aim was to highlight the different options or paths to follow when deciding about a migration strategy. I also touched upon migrating from Excel\/Access to Forms. Here are the screenshots from that presentation. A translation of \u00a0each one is given below the screen capture.<\/p>\n<p><strong>Screen 1<\/strong><\/p>\n<figure id=\"attachment_212\" aria-describedby=\"caption-attachment-212\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/degenio.com\/blog\/2013\/05\/migrating-from-oracle-forms-to-apex\/migration_oracle_1\/\" rel=\"attachment wp-att-212\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-212\" alt=\"Introduction migration to APEX\" src=\"http:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_1-300x225.jpg\" width=\"300\" height=\"225\" srcset=\"https:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_1-300x225.jpg 300w, https:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_1.jpg 555w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-212\" class=\"wp-caption-text\">Introduction migration to APEX<\/figcaption><\/figure>\n<p><!--more-->Why are we\u00a0 obligated to migrate from Oracle Forms ?<\/p>\n<ul>\n<li>New Versions 11g or 12c<\/li>\n<li>Is it a problem with the PL-SQL ?<\/li>\n<li>Configuration problems with the current Forms<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Screen 2<\/strong><\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_213\" aria-describedby=\"caption-attachment-213\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/degenio.com\/blog\/2013\/05\/migrating-from-oracle-forms-to-apex\/migration_oracle_2\/\" rel=\"attachment wp-att-213\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-213\" alt=\"Why we might be required to  migrate.\" src=\"http:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_2-300x268.jpg\" width=\"300\" height=\"268\" srcset=\"https:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_2-300x268.jpg 300w, https:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_2.jpg 455w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-213\" class=\"wp-caption-text\">Why we might be required to migrate.<\/figcaption><\/figure>\n<p>Some other motivations<\/p>\n<ul>\n<li>Audit (internal or external<\/li>\n<li>Resources consolidation, either human or hardware<\/li>\n<li>Software consolidation<\/li>\n<li>May be current technologie offers better performance<\/li>\n<li>Other software vendors have better products<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Screen 3<\/strong><\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_214\" aria-describedby=\"caption-attachment-214\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/degenio.com\/blog\/2013\/05\/migrating-from-oracle-forms-to-apex\/migration_oracle_3\/\" rel=\"attachment wp-att-214\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-214\" alt=\"Migrating from Oracle to Oracle\" src=\"http:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_3-300x239.jpg\" width=\"300\" height=\"239\" srcset=\"https:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_3-300x239.jpg 300w, https:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_3.jpg 509w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-214\" class=\"wp-caption-text\">Migrating from Oracle to Oracle<\/figcaption><\/figure>\n<p>Migrating from Oracle product to Oracle products or other platforms<\/p>\n<ul>\n<li>Forms 6i, 9i, 10g to 11g: use migration tools, inventory all objects. 80% automatically done and 20% manually<\/li>\n<li>Forms to Java: investigate Oracle ADF but do we have the required expertise since most Oracle analysts lack Java expertise. How do we handle the stored procedures, etc.<\/li>\n<li>Forms to .Net: major surgery here. Are we talking about the application and the database that will move to Microsof products ?<\/li>\n<\/ul>\n<p><strong>Screen 4<\/strong><\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_215\" aria-describedby=\"caption-attachment-215\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/degenio.com\/blog\/2013\/05\/migrating-from-oracle-forms-to-apex\/migration_oracle_4\/\" rel=\"attachment wp-att-215\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-215\" alt=\"Migrating to APEX\" src=\"http:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_4-300x243.jpg\" width=\"300\" height=\"243\" srcset=\"https:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_4-300x243.jpg 300w, https:\/\/degenio.com\/blog\/wp-content\/uploads\/2013\/05\/migration_oracle_4.jpg 575w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><figcaption id=\"caption-attachment-215\" class=\"wp-caption-text\">Migrating to APEX<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>Migrating to Oracle APEX<\/p>\n<p>Do we have the tool that will help ?<\/p>\n<p>Might be easy with Excel\/Access to APEX<\/p>\n<p>Forms to APEX: current tool might help with the UI but business rules, PL-SQL and all the other stuff is problematic.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yesterday, I \u00a0gave an impromptu talk about migrating from Oracle Forms to APEX. The aim was to highlight the different options or paths to follow when deciding about a migration strategy. I also touched upon migrating from Excel\/Access to Forms. Here are the screenshots from that presentation. A translation of \u00a0each one is given below [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[89],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/phEMW-3p","_links":{"self":[{"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/posts\/211"}],"collection":[{"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":3,"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":218,"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/posts\/211\/revisions\/218"}],"wp:attachment":[{"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/degenio.com\/blog\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}