{"id":1145,"date":"2009-04-17T06:34:30","date_gmt":"2009-04-17T10:34:30","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/"},"modified":"2009-04-17T06:36:24","modified_gmt":"2009-04-17T10:36:24","slug":"isetup-to-transfer-setup-from-one-instance-to-another","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/","title":{"rendered":"Isetup to Transfer Setup from One instance to another"},"content":{"rendered":"

<\/a>Introduction<\/p>\n

This document provides a complete, up-to-date description of Oracle iSetup Minipack 11i.AZ.H (5140723). The main focus of iSetup is to help migrate functional setups from one E-Business Suite instance to another. During migration, setups can be extracted selectively using filters on setup attributes. Extracted setup data can be optionally transformed before loading into target instance.
\nBoth the source and target should be in the same iSetup patch level .<\/p>\n

Attention:
\nOracle iSetup Minipack 11i.AZ.H can be applied only to an existing Oracle Applications Release 11.5.10 system<\/p>\n

Pre-install Steps<\/p>\n

1.\u00a0Upgrade to Oracle Database 9.2.0.5 or Higher (Required)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2. XML DB Setup:
\n\u00a0Oracle iSetup minipack AZ.H requires the Oracle Database version 9.2.0.5 or\u00a0\u00a0 above with Oracle XML DB enabled. Please refer to your version specific Oracle XML Database Developer’s Guide.
\n\u00a0You can determine whether or not Oracle XML DB is already installed. You\u00a0\u00a0 could use the following queries to do this.
\na.Check if the user XDB exists.
\nQuery to use: SELECT * FROM ALL_USERS where username = ‘XDB’
\nb.Confirm that the View RESOURCE_VIEW exists.
\nQuery to use: DESCRIBE RESOURCE_VIEW
\nc.Determine whether Oracle XML DB status is valid.
\nQuery to use: Select status from dba_registry where comp_id = ‘XDB’;<\/p>\n

Pre-requisite Patches
\n4712852 11i.AD.I.4
\n\u00a0 Apply Additional Prerequisites (Required)
\n\u00a0 3641831 Wf_Event_Omb_Qh Is Invalid After Applying HR_PF.D
\n\u00a0 3948369 AOL Security Rollup I.1
\n\u00a0 4104924 Txk (Fnd) Autoconfig Template Rollup Patch K (July 2005)
\n\u00a0 4206181 XDO\/Oracle XML Publisher OA Rollup Patch 5.5.0
\n\u00a0 Apply Additional Prerequisites (Conditionally Required)
\n\u00a0 4505481 When Applying HR_PF.J in JP, XML Publisher Reports
\n\u00a0 The above patch no 4505481 is the only pre-req patch I have applied . Rest of the patches are already applied in my instance .
\n\u00a04334965 11i.ATG_PF.H RUP3
\n\u00a0676589 11i.ATG_PF.H.RUP4 or\u00a0 any ATG 11.5.10 RUP subsequent to ATG RUP4 , then, please apply the following patch:
\n\u00a04505485 When Applying HR_PF.J in JP, XML Publisher Reports S Are Failing
\n\u00a0Applying this minipack
\n\u00a0Oracle iSetup minipack 11i.AZ.H contains a unified patch driver and may contain additional driver files to be applied with AutoPatch.\u00a0 Please apply the u5140723.drv driver file on all application tier server nodes.<\/p>\n

\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

Post-install Steps<\/p>\n

Once you have successfully applied Oracle iSetup minipack 11i.AZ.H, you must apply these patches:
\n\u00a0
\n\u00a04453830 AR Dependency Issue While Loading Accounting And Transaction Types
\n4528356 AR Dependency Issue While Loading System Options
\n4449094 Inventory APIs Not Loading In Proper Sequence
\n4641008 KeyFlexField Dependency Issue
\n4305771 Issue While Loading Customers Into Interface Tables
\n4604123 Exceptions While Loading AR Customers
\n4015970 Item Template Extract Fails For Attribute Payment Terms
\n4612812 Serial Number Extract Errors For Dependent_Asset_Flag
\n4926690 Extract Request Failing For Inter-Company Transaction Flows
\n4604050 Dependency Information Missing For Api ONT_OESysParameters
\n5201280 (Optional)Tracking Bug To Deliver Latest HR Org Apis For Migration
\n4200089 PO Buyers Load Issue
\nNote:-The above patch 5201280 has got pre-req patch 3333633 is an optional , if you HRMS enabled , then you need to apply the patch
\n4188534 Inventory Items Not Attached To Price Lists Due To Missing Profile Values
\n3994238 Partial Migration During Item Templates Load<\/p>\n

Above all the patches, I have applied except the one optional .In my case I don\u2019t need to pay any pre-req patches for the above patches.<\/p>\n

\u00a0Apply Conditionally Mandatory Patches
\nIf you are on 11i.10 baseline, then you need to apply the following patches (conditionally mandatory):<\/p>\n

3878497 GL\/Chart Of Accounts iSetup Patch
\n3924555 Failure While Loading Freight Carriers
\n4628344 Issue While Loading Suppliers
\n3924472 Failure While Loading MSC_Applicationinstances
\n4640953 Improper Load Of OM System Parameters
\n\u00a0
\nIf you are on 11i.10.CU2 baseline, then you need to apply the following patches (conditionally mandatory): (Applied the below patches )<\/p>\n

4628347 Issue While Loading Suppliers
\n4636554 Issue While Loading Supplier Tax Authority
\n4477329 FND Lookup Extraction Issue
\n4557501 ABC Analysis Data Compiled For Sub-Inventory Fails During Load
\n4495836 Exception While Loading WIP Shop Floor Status
\n4495891 WIP Accounting Classes API Fails During Load
\n4586690 QP Modifier Setup API Load Failure
\n4548492 Error While Loading Transaction Types<\/p>\n

Once you are able apply the 11i.AZ.H (5140723) successfully along with all the Pre and post patches , you can go ahead apply the below DELTA-2 patch for isetup , make sure that you go through the metalink doc . The delta-2 has got pre-req patches 5525463 and 5140723 .<\/p>\n

Apply Recommended Patch 11i.AZ.H.DELTA.2 (patch 7293818)<\/p>\n

Oracle recommends that you also apply patch 7293818, Oracle iSetup patch 11i.AZ.H.DELTA.2..<\/p>\n

Implementation and User Documentation<\/p>\n

Apply 5217874\u00a0
\nPost installation Task<\/p>\n

Copy the tns entry from source to target and target to source vice-versa in
\nOracle_8.0.6_Home\/network\/admin .It is good practice to create <SID>_<Hostaname>_ifile.ora file and put tns entry\u00a0 .<\/p>\n

Copy the Directory <SID>_<Hostaname> from $FND_TOP\/secure from source to target and target to source vice versa.<\/p>\n

Set up Source instance .<\/p>\n

Assign XML Publisher Administrator\u00a0 responsibility\u00a0 to your user.
\n\u00a0Click on XML Publisher Administrator ->Administrator ->General->Temporary Directory
\nEnter the value for the temporary directory , which is added in utl_file_dir.<\/p>\n

<\/p>\n

Reference :<\/font>\u00a0 Metal ink note 368670.1<\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction This document provides a complete, up-to-date description of Oracle iSetup Minipack 11i.AZ.H (5140723). The main focus of iSetup is […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1145","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nIsetup to Transfer Setup from One instance to another -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Isetup to Transfer Setup from One instance to another -\" \/>\n<meta property=\"og:description\" content=\"Introduction This document provides a complete, up-to-date description of Oracle iSetup Minipack 11i.AZ.H (5140723). The main focus of iSetup is […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/\" \/>\n<meta property=\"article:published_time\" content=\"2009-04-17T10:34:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2009-04-17T10:36:24+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/04\/iset.thumbnail.JPG\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/\",\"name\":\"Isetup to Transfer Setup from One instance to another -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/04\/iset.thumbnail.JPG\",\"datePublished\":\"2009-04-17T10:34:30+00:00\",\"dateModified\":\"2009-04-17T10:36:24+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/#primaryimage\",\"url\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/04\/iset.thumbnail.JPG\",\"contentUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/04\/iset.thumbnail.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Isetup to Transfer Setup from One instance to another\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Isetup to Transfer Setup from One instance to another -","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:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/","og_locale":"en_US","og_type":"article","og_title":"Isetup to Transfer Setup from One instance to another -","og_description":"Introduction This document provides a complete, up-to-date description of Oracle iSetup Minipack 11i.AZ.H (5140723). The main focus of iSetup is […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/","article_published_time":"2009-04-17T10:34:30+00:00","article_modified_time":"2009-04-17T10:36:24+00:00","og_image":[{"url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/04\/iset.thumbnail.JPG","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/","url":"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/","name":"Isetup to Transfer Setup from One instance to another -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/#primaryimage"},"thumbnailUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/04\/iset.thumbnail.JPG","datePublished":"2009-04-17T10:34:30+00:00","dateModified":"2009-04-17T10:36:24+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/#primaryimage","url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/04\/iset.thumbnail.JPG","contentUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2009\/04\/iset.thumbnail.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2009\/04\/17\/isetup-to-transfer-setup-from-one-instance-to-another\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Isetup to Transfer Setup from One instance to another"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/1145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=1145"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/1145\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=1145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=1145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=1145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}