{"id":473,"date":"2008-05-13T11:43:45","date_gmt":"2008-05-13T15:43:45","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/"},"modified":"2008-05-13T14:31:48","modified_gmt":"2008-05-13T18:31:48","slug":"cloning-oam-system-name-pointing-to-source-instance","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/","title":{"rendered":"Cloning : OAM System Name pointing to Source Instance"},"content":{"rendered":"

On one of Oracle Applications 11i cloned instance,\u00a0OAM (Oracle Application Manager)\u00a0was showing\u00a0\u00a0“Application System Name<\/strong>” as source Instance.<\/p>\n

like http:\/\/<url>\/oa_servlets\/weboam\/oam\/oamApps$target=source<\/font><\/strong><\/p>\n

1. <\/strong>My first thought was to look at FND_NODES <\/strong>to see if any node entry still pointing to source instance. All records in this table were pointing to target instance.<\/p>\n

If FND_NODES contain entry to source instance, I could have cleaned it using below methods
\na)<\/strong>Login to sqlplus as user APPS
\nb)<\/strong> EXEC FND_CONC_CLONE.SETUP_CLEAN;\u00a0 (This procedure will delete all nodes from FND_NODES and related data in other tables)
\nc)<\/strong>Repopulate FND_NODES by running Autoconfig on all middle tier nodes (CM, Web Forms)<\/p>\n

2.<\/strong> Next obvious thought was to look at profile option at Server, Responsibility level (During cloning only site level profile options are updated to target instance<\/strong>).<\/p>\n

SQL> select PO.PROFILE_OPTION_NAME,PV.PROFILE_OPTION_VALUE, PV.LEVEL_ID
\nfrom fnd_profile_option_values pv, fnd_profile_options po
\nwhere upper(PROFILE_OPTION_VALUE) like ‘%&enter_source_in_UPPERCASE%’
\nand pv.PROFILE_OPTION_ID=po.PROFILE_OPTION_ID;<\/p>\n

In above query level_id represents following level
\n10001 – SITE
\n10002 – APP
\n10003 – RESP
\n10004 – USER
\n10005 – SERVER
\n10006 – ORG
\n10007 – ServerResponsibility<\/p>\n

No profile option was pointing to source instance (I already changed workflow related profile options mentioned in post clone steps)<\/p>\n

3.<\/strong> Googled to check if others encountered similar issue and I got one hit here<\/a> but solution was to clone again and I wasn’t convinced<\/p>\n

4.<\/strong> Next Step was to identify table and column name from where OAM (Oracle Application Manager) was populating “Application System Name” in Applications Dashboard & Site Map<\/p>\n

SELECT table_name, column_name
\nFROM all_tab_columns
\n–WHERE column_name LIKE ‘%’<\/strong><\/p>\n

After some permutations & combinations I reached to below query<\/p>\n

SELECT table_name, column_name
\nFROM all_tab_columns
\nWHERE column_name LIKE ‘APPLICATION%SYSTEM%NAME%’;<\/strong><\/p>\n

and output was<\/p>\n

TABLE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 COLUMN_NAME
\n—————————— ——————————
\nAD_APPL_TOPS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 APPLICATIONS_SYSTEM_NAME
\nFND_PRODUCT_GROUPS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 APPLICATIONS_SYSTEM_NAME
\nBIN$TQikJhLucVHgRAADuqIcxA==$0 APPLICATIONS_SYSTEM_NAME<\/p>\n

My immediate focus was on table AD_APPL_TOPS <\/strong>& FND_PRODUCT_GROUPS<\/strong>
\nChecked and found that APPLICATIONS_SYSTEM_NAME in FND_PRODUCT_GROUPS was pointing to source instance where as it should be same as SID.<\/strong><\/p>\n

Fix was simply to update table FND_PRODUCT_GROUPS like<\/p>\n

Backup existing table as
\nSQL>create table FND_PRODUCT_GROUPS_BAK as select * from FND_PRODUCT_GROUPS;<\/p>\n

Update table with target name
\nSQL> update FND_PRODUCT_GROUPS
\nset APPLICATIONS_SYSTEM_NAME = ‘<NEW DATABASE NAME>’ ;
\ncommit;
\n5.<\/strong> Final hard thing to find was which step in cloning update this table so I started digging cloning log file.<\/p>\n

– At one step cloning runs Autoconfig on target instance which runs script<\/p>\n

$OAD_TOP\/admin\/install\/$CONTEXT_NAME\/adadmprf.sh<\/strong>\u00a0 (This script set profiles in database) and calls adadmprf.sql<\/p>\n

This script does same as we did above and for some reason it failed during Autocnfig phase of Rapid Clone<\/p>\n

\r\nREMREM Update FND_PRODUCT_GROUPS, if needed  \r\n\r\nREM<\/pre>\n
declare\u00a0 statement varchar2(200);  \r\n\r\n\u00a0 l_new_asn varchar2(30);  \r\n\r\nbegin  \r\n\r\n\u00a0 if :fpg_has_column = 'TRUE' then  \r\n\r\n\u00a0\u00a0\u00a0 l_new_asn := :new_apps_system_name;<\/pre>\n
\u00a0\u00a0\u00a0 statement := 'update fnd_product_groups '||\u00a0\u00a0\u00a0\u00a0\u00a0<\/pre>\n
       'set applications_system_name = :new_asn '||  \r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 'where product_group_id = 1';<\/pre>\n
\u00a0\u00a0\u00a0 execute immediate statement\u00a0\u00a0\u00a0 using l_new_asn;  \r\n\r\n\u00a0 end if;  \r\n\r\n-- end if applications_system_name column<\/pre>\n
exists in fnd_product_groups  \r\n\r\nend;  \r\n\r\n\/<\/pre>\n
6. Finally to ensure that every thing is correct I executed $OAD_TOP\/admin\/install\/$CONTEXT_NAME\/adadmprf.sh again,<\/p>\n
Bounced Apache and Application System Name pointing to target insatnce this time.<\/strong><\/p>\n
Related
\n<\/u>230672.1<\/strong> Cloning Oracle Applications Release 11i with Rapid Clone
\n165195.1<\/strong>Using AutoConfig to Manage System Configurations with Oracle Applications 11i
\n564112.1<\/strong> A Number of Managers Show the Wrong Node Post Clone
\n213339.1 <\/strong>Adpatch Fails : ‘The Applications System names per the APPL_TOP and the database are different’<\/p>\n","protected":false},"excerpt":{"rendered":"
On one of Oracle Applications 11i cloned instance,\u00a0OAM (Oracle Application Manager)\u00a0was showing\u00a0\u00a0“Application System Name” as source Instance. like http:\/\/<url>\/oa_servlets\/weboam\/oam\/oamApps$target=source 1. […]<\/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":[42],"tags":[],"class_list":["post-473","post","type-post","status-publish","format-standard","hentry","category-troubleshooting"],"yoast_head":"\nCloning : OAM System Name pointing to Source Instance -<\/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\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cloning : OAM System Name pointing to Source Instance -\" \/>\n<meta property=\"og:description\" content=\"On one of Oracle Applications 11i cloned instance,\u00a0OAM (Oracle Application Manager)\u00a0was showing\u00a0\u00a0“Application System Name” as source Instance. like http:\/\/<url>\/oa_servlets\/weboam\/oam\/oamApps$target=source 1. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-05-13T15:43:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2008-05-13T18:31:48+00:00\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/\",\"name\":\"Cloning : OAM System Name pointing to Source Instance -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2008-05-13T15:43:45+00:00\",\"dateModified\":\"2008-05-13T18:31:48+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cloning : OAM System Name pointing to Source Instance\"}]},{\"@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":"Cloning : OAM System Name pointing to Source Instance -","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\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/","og_locale":"en_US","og_type":"article","og_title":"Cloning : OAM System Name pointing to Source Instance -","og_description":"On one of Oracle Applications 11i cloned instance,\u00a0OAM (Oracle Application Manager)\u00a0was showing\u00a0\u00a0“Application System Name” as source Instance. like http:\/\/<url>\/oa_servlets\/weboam\/oam\/oamApps$target=source 1. […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/","article_published_time":"2008-05-13T15:43:45+00:00","article_modified_time":"2008-05-13T18:31:48+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/","url":"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/","name":"Cloning : OAM System Name pointing to Source Instance -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2008-05-13T15:43:45+00:00","dateModified":"2008-05-13T18:31:48+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/05\/13\/cloning-oam-system-name-pointing-to-source-instance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Cloning : OAM System Name pointing to Source Instance"}]},{"@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\/473","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=473"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/473\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}