How to Change the System Name in Workflow

After Cloning required to change workflow system name.

Change the service name in TEST:

In apps node

SQL> select NAME from wf_systems;



SQL> select GUID from wf_systems;


SQL> select NAME, SYSTEM_GUID from wf_agents;

Go to bellow path and run the following scripts .

$ cd /TEST/apps/testcomn/admin/install/TEST_oratest2

$ sh apps apps started at Mon Dec 29 03:49:05 EST 2008
The environment settings are as follows ...
apps_HOME : /TEST/apps/testora/8.0.6
apps_SID :
PATH : /TEST/apps/testora/iAS/Apache/perl/bin:/TEST/apps/testora/8.0.6/bin:/TEST/apps/testappl/fnd/11.5.0/bin:/TEST/apps/testappl/ad/11.5.0/bin:/TEST/apps/testcomn/util/java/1.5/jdk1.5.0_11/bin:/TEST/apps/testcomn/util/unzip/unzip/unzip-5.50::/TEST/apps/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/TEST/apps/testora/iAS/Apache/perl/bin:/TEST/apps/testora/8.0.6/bin:/TEST/apps/testcomn/util/java/1.5/jdk1.5.0_11/bin:/TEST/apps/testcomn/util/unzip/unzip/unzip-5.50:/TEST/apps/testora/8.0.6/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/applmgr/bin
LD_LIBRARY_PATH : /TEST/apps/testora/8.0.6/network/jre11/lib/i686/native_threads:/TEST/apps/testora/8.0.6/network/jre11/lib/linux/native_threads:/TEST/apps/testappl/cz/11.5.0/bin:/TEST/apps/testora/8.0.6/lib:/usr/X11R6/lib:/usr/openwin/lib

Executable : /TEST/apps/testora/8.0.6/bin/sqlplus

SQL*Plus: Release - Production on Mon Dec 29 03:49:05 2008

(c) Copyright 1999 apps Corporation. All rights reserved.


PL/SQL procedure successfully completed.

Commit complete.

Disconnected from apps Database 10g Enterprise Edition Release - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

After completing this scripts, now check againg the following query.
Now its changed the service name PROD to TEST.

SQL> show parameter service

service_names string TEST

SQL> select NAME from wf_systems;


SQL> select GUID from wf_systems;


SQL> select NAME, SYSTEM_GUID from wf_agents;

Refered Notes:

The agent could not be found: WF_CONTROL post-clone
Doc ID: 374529.1

How to Change the System Name in Workflow?
Doc ID: 387337.1


Larry said...

I ma tying to a hot rapids clone but keeps getting a forms error whenever
I attempt to launch a forms on the target. Do you have steps for a hot clone?

Ramesh Mani said...


I already posted online cloning steps.

please find this blog.

Anonymous said...

Above Document helped like any thing


Microsoft Office 2007 said...

NEVERTHELESS, THE CIVIL LAW is and must be neutral about who has a more noble or rewarding faith. The breakaway parishes ought to win every Office 2010facet of the lawsuit not becauseMicrosoft Office 2010 their beliefs or their politics are better, Microsoft wordbut because both lawOffice 2007and equity, along with common sense, are on Microsoft Officetheir side.Microsoft Office 2007 Not only does Virginia state law (the Division Statute)Office 2007 keyexplicitly apply to just such a Office 2007 downloadsituation as now exists, but the history Office 2007 Professionalespecially of The Falls Church argues against the claims of Outlook 2010the Virginia Diocese with which theyMicrosoft outlookhave disassociated.Microsoft outlook 2010First, The Falls Church wasWindows 7 founded, formed, and developed long before the diocese, or the national Episcopal Church, even existed.

JP said...

Is it possible to run the via a shell script? We have a requirement to script the cloning process. We need to run this script without getting prompted for the username/password. So far I have not been able to accomplish that.

Return Gifts said...

Excellent blog, I am very Happy with this post
Cheap Return Gifts For Wedding | Wedding Return Gifts Chennai

Sridevi Koduru said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.