Did you run fnd_conc_clone.setup_clean ?
sqlplus apps/<source instance apps password >
select name from v$database ; -- Make sure it is target database
run autoconfig in DB tier , then apps tier
Thanks & Regards
I think that is applicable for EBS 12.1.3? or is it still applicable it 12.2.x?
For EBS 12.2.9
I run below:
Run AutoConfig on DB tier and then on apps tier (Run & Patch FS).
1. Backup the fnd_oam_context_files, fnd_nodes, and adop_valid_nodes tables in the EBS env nodes:
create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files;
create table fnd_nodes_bk as select * from fnd_nodes;
create table adop_valid_nodes_bk as select * from adop_valid_nodes;
2. Truncate the following tables:
truncate table applsys.fnd_oam_context_files;
truncate table applsys.fnd_nodes;
truncate table applsys.adop_valid_nodes;
3. Run AutoConfig on the DB tier
Confirm Autoconfig completes successfully
4. Run AutoConfig on the run file system.
Confirm AutoConfig completes successfully
5. Run AutoConfig on the patch file system
Before running AutoConfig on the patch file system the ebs_logon trigger MUST be disabled
After the successful completion of AutoConfig the ebs_logon trigger MUST be re-enabled.
This needs to be done as the SYSTEM schema user.
5.1. Disable the ebs_login trigger using the following SQL.
SQL> alter trigger ebs_logon disable;
At this time Run AutoConfig with the patch environment variables sourced.
Make sure AutoConfig completes successfully
5.2. Enable the ebs_logon trigger using the following SQL.
SQL> alter trigger ebs_logon enable;
Please help if there is some steps I missed?
Yes you can run fnd_conc_clone.setup_clean
Please refer below document . It can be run during cloning .
If you are really concerned , please take a backup .
R12.2: When To Run fnd_conc_clone.setup_clean? (Doc ID 2130750.1)
Thanks & Regards
So it is still supported? Do I need to run both with the scripts I had above?
How about the steps I run above? Does it have supporting ML support notes?
Are you facing any issue because of this ?
duplicate node_name -> These node names are of target server ?
You can have duplicate node names of target server . This is okay .
Please update .
I had similar issue before.
I ran adop phase=fs_clone it fixed the FND_NODES
Mohammed Ali A. Syed