{"id":4625,"date":"2014-03-19T12:32:57","date_gmt":"2014-03-19T12:32:57","guid":{"rendered":"http:\/\/erpschools.com\/?p=4625"},"modified":"2014-11-30T20:22:57","modified_gmt":"2014-11-30T20:22:57","slug":"upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader","title":{"rendered":"Workflow migration: WFLOAD | Workflow Definitions Loader"},"content":{"rendered":"<p>Oracle workflow objects can be saved into database or into a file. So We can treat Oracle workflow objects as both file system objects and database objects. We save workflow object into file when working on local system either for development \/ enhancement or debugging. When you execute the workflow from server it will always look at the database object.<\/p>\n<pre>Notes:\n1. Workflow objects need to be deployed into database for execution. \n2. Workflow engine will <span style=\"text-decoration: underline;\">not<\/span> refer to any .wft files during execution.<\/pre>\n<p>We have three approaches to download, upload, upgrade workflow objects.<br \/>\n1) WFLOAD Utility from UNIX command prompt, This approach is usually preferred by DBA&#8217;s.<br \/>\n2) Workflow Builder client tool, Preferred by Technical Developers<br \/>\n3) Use &#8220;Workflow Definitions Loader&#8221; concurrent program. Not many people are aware of this approach and used very less.<\/p>\n<p>The above mentioned approaches can be used to migrate workflow object from one instance to other instance. ex: From Development (DEV) instance to Quality testing instance (QA)<\/p>\n<p><span style=\"text-decoration: underline;\">WFLOAD:<\/span><\/p>\n<p>Download a workflow definition from Database into a file:<\/p>\n<p><code> WFLOAD apps\/pwd 0 Y DOWNLOAD file_name.wft ITEM_TYPE_NAME <\/code><\/p>\n<p>Download multiple workflow definition&#8217;s from Database into one file:<\/p>\n<p><code> WFLOAD apps\/pwd 0 Y DOWNLOAD file_name.wft ITEM_TYPE_NAME1 ITEM_TYPE_NAME2 ITEM_TYPE_NAME3 <\/code><\/p>\n<p>Download all workflow definitions from Database into one file:<\/p>\n<p><code> WFLOAD apps\/pwd 0 Y DOWNLOAD file_name.wft '*' <\/code><\/p>\n<p>Upload a workflow definition from file into Database:<\/p>\n<p><code> WFLOAD apps\/pwd 0 Y UPLOAD file_name.wft <\/code><\/p>\n<p>Upload a workflow definition in database from file (File has the latest changes):<\/p>\n<p><code> WFLOAD apps\/pwd 0 Y UPGRADE file_name.wft <\/code><\/p>\n<p>Force a workflow definition from file into Database ignoring the protection level:<\/p>\n<p><code> WFLOAD apps\/pwd 0 Y FORCE file_name.wft <\/code><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\">Workflow Builder Client Tool:<\/span><\/p>\n<p>To save a workflow into database from file which is on your local machine you need to open the workflow (.wft) in your workflow builder client tool.<\/p>\n<p>1. Open .wft file in workflow builder client tool using File &gt; Open<br \/>\n2. Choose File option and select your file from local machine<br \/>\n3. Go to File &gt; &#8220;Save as&#8221;<br \/>\n4. Choose Database option now and provide your database login credentials<br \/>\n5. Save<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4647\" alt=\"workflow save from file to database\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/workflow-save-to-database.png\" width=\"397\" height=\"538\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>To open a workflow object from database and save it as a file (.wft) on your local machine<\/p>\n<p>1. Open workflow builder client tool and go to File &gt; Open<br \/>\n2. Choose Database and provide login credentials<br \/>\n3. Select the workflow on the right side panel and use arrows button to move it left side<br \/>\n4. Click Ok to open<br \/>\n5. Go to File &gt; &#8220;Save as&#8221; and now choose File Option and save it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4648\" alt=\"workflow save from database to file\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/workflow-save-from-database.png\" width=\"451\" height=\"485\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline;\">Workflow Definitions Loader Concurrent Program:<\/span><\/p>\n<p>Make sure the mentioned concurrent program is added to the corresponding request group of the responsibility from which you wish to run.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4645\" alt=\"Workflow Definitions submit\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Oracle_Applications_workflow_definitions.png\" width=\"1067\" height=\"633\" \/><\/p>\n<p>Submit the concurrent program with your preferred options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-4644\" alt=\"Workflow Definitions submit\" src=\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/Oracle_Applications_wokflow_def_submit.png\" width=\"701\" height=\"499\" \/><\/p>\n<p>Oracle Document:<br \/>\n<a title=\"Workflow Definitions Loader\" href=\"http:\/\/docs.oracle.com\/cd\/B10501_01\/workflow.920\/a95265\/instal68.htm\" target=\"_blank\">http:\/\/docs.oracle.com\/cd\/B10501_01\/workflow.920\/a95265\/instal68.htm<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle workflow objects can be saved into database or into a file. So We can treat Oracle workflow objects as both file system objects and database objects. We save workflow object into file when working on local system either for development \/ enhancement or debugging. When you execute the workflow from server it will always [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,76,499],"tags":[209,210,211,534,212],"class_list":["post-4625","post","type-post","status-publish","format-standard","hentry","category-scripts","category-workflow-tools","category-workflow-scripts","tag-download","tag-upload","tag-wfload","tag-workflow","tag-workflow-definitions-loader"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>upload workflow oracle apps , WFLOAD, Workflow definitions loader<\/title>\n<meta name=\"description\" content=\"upload workflow oracle apps , WFLOAD upload workflow oracle, Workflow definitions loader\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Workflow migration: WFLOAD | Workflow Definitions Loader\",\"datePublished\":\"2014-03-19T12:32:57+00:00\",\"dateModified\":\"2014-11-30T20:22:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader\"},\"wordCount\":392,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/workflow-save-to-database.png\",\"keywords\":[\"download\",\"upload\",\"wfload\",\"workflow\",\"workflow definitions loader\"],\"articleSection\":[\"Scripts\",\"Workflow\",\"workflow scripts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader\",\"url\":\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader\",\"name\":\"upload workflow oracle apps , WFLOAD, Workflow definitions loader\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/workflow-save-to-database.png\",\"datePublished\":\"2014-03-19T12:32:57+00:00\",\"dateModified\":\"2014-11-30T20:22:57+00:00\",\"description\":\"upload workflow oracle apps , WFLOAD upload workflow oracle, Workflow definitions loader\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#primaryimage\",\"url\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/workflow-save-to-database.png\",\"contentUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/workflow-save-to-database.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Workflow migration: WFLOAD | Workflow Definitions Loader\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"upload workflow oracle apps , WFLOAD, Workflow definitions loader","description":"upload workflow oracle apps , WFLOAD upload workflow oracle, Workflow definitions loader","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Workflow migration: WFLOAD | Workflow Definitions Loader","datePublished":"2014-03-19T12:32:57+00:00","dateModified":"2014-11-30T20:22:57+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader"},"wordCount":392,"commentCount":0,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/workflow-save-to-database.png","keywords":["download","upload","wfload","workflow","workflow definitions loader"],"articleSection":["Scripts","Workflow","workflow scripts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader","url":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader","name":"upload workflow oracle apps , WFLOAD, Workflow definitions loader","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/workflow-save-to-database.png","datePublished":"2014-03-19T12:32:57+00:00","dateModified":"2014-11-30T20:22:57+00:00","description":"upload workflow oracle apps , WFLOAD upload workflow oracle, Workflow definitions loader","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#primaryimage","url":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/workflow-save-to-database.png","contentUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/workflow-save-to-database.png"},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/scripts\/upload-workflow-oracle-apps-wfload-upload-workflow-oracle-workflow-definitions-loader#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Workflow migration: WFLOAD | Workflow Definitions Loader"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/4625","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=4625"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/4625\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=4625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=4625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=4625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}