title: Remove All References link: https://onemoretech.wordpress.com/2008/10/05/remove-all-references/ author: lembobro description: post_id: 448 created: 2008/10/05 18:25:00 created_gmt: 2008/10/05 18:25:00 comment_status: open post_name: remove-all-references status: publish post_type: post

Remove All References

Although the title sounds somewhat intimidating, like “Destroy All Monsters”, the procedure to “remove all references” in Oracle EBS-speak actually “refers” to the process of finally and completely setting an Enterprise Business Suite 11i instance back to its original, non-SSO and OID integrated state. This is especially important if one instance is cloned from another that was SSO/OID integrated at the time of the clone. The procedure is fairly simple.

Log in as the EBS instance user. Then change directory to $APPL_TOP. Source the instance environment with a . ./APPS[instance SID]_[hostname].env (e.g. “APPSebstest1_testbox23.env”). Then change directory to $FND_TOP/bin. Finally, run the txkrun.pl script with the following parameters:

To remove references to SSO:

txkrun.pl -script=SetSSOReg -removereferencessso=Yes -appspass=[APPS database user password] -systempass=[SYSTEM database user password]

Removing references to OID is done with the same script, with the following command:

txkrun.pl -script=SetSSOReg -removereferencesoid=Yes -appspass=[APPS database user password]

For EBS 12 the process is simpler. After setting the environment and changing into the $FND_TOP/bin directory, you simply enter:

txkrun.pl -script=SetSSOReg -removereferences=Yes -appspass=[APPS database user password]

That’s all there is to it.

<[img src="/wp-content/images/destroy-all-monsters-dvd.jpg" alt="" title="Kaij

Copyright 2004-2019 Phil Lembo