Concurrent Manager Node is in Lowercase Causing Adgendbc.sh to Fail

When we are performing a clone, We observed concurrent managers were not coming up due to node name issue, We tried to run autoconfig, But adgendbc of autoconifg was failing with below issue

java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.FND_APP_SERVER_PKG", line 298
ORA-06512: at line 1

 1.As per the error report we observed that the issue was due to lower case of concurrent manager node name

SQL> select node_name from apps.fnd_nodes;

NODE_NAME

------------------------------

AUTHENTICATION

ebstestapp

EBSTESTDB

2. The metalink id 1539713.1 matches the error we are facing and we performed the below steps which resolved the issue.

A. Clean the FND_NODES

Execute following commands in SQLPlus :

SQL>EXEC FND_CONC_CLONE.SETUP_CLEAN;

SQL>COMMIT;

SQL>EXIT;

B. Run autoconfig.sh

C. Make a backup copy of the existing FND_NODES table then run the command in SQLPLUS to set the node_name to upper case:

SQL> create table fnd_nodes_backup_08_June as select * from apps.fnd_nodes;

Table created.

update fnd_nodes set node_name = upper(node_name);

commit;

D. Run adgendbc.sh

$COMMON_TOP/admin/install/EBSTST2_EBSTESTAPP/adgendbc.sh

E. Run this command:

update fnd_nodes set host='EBSTESTAPP', domain='US.NIFCOAMERICAS.COM'

where node_name = ' EBSTESTAPP ';

F. Following instructions given in Note 735148.1:

1. Connect SQLPLUS as APPS user

2. cd to $FND_TOP/patch/115/sql

3. Run the script: afdcm037.sql and cmclean.sql

SQL> show user

USER is "APPS"

SQL> @afdcm037.sql             

sql>@cmclean.sql

After this action plan we were able to start the concurrent managers.