ADOP Fails With Error Unable to Find Appltop_id (Doc ID 1907419.1)

There are duplicates on the table use the following to verify


Query

select node_name from FND_OAM_CONTEXT_FILES

where NAME not in ('TEMPLATE','METADATA','config.txt') and

CTX_TYPE='A' and (status is null or upper(status) in ('S','F'))

and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'run'

and EXTRACTVALUE(XMLType(TEXT),'//oa_service_group_status[@oa_var=''s_web_admin_status'']')='enabled'

and EXTRACTVALUE(XMLType(TEXT),'//oa_service_list/oa_service[@type=''admin_server'']/oa_service_status')='enabled';

SQL> conn apps

Enter password:

Connected.

SQL> select node_name from FND_OAM_CONTEXT_FILES

where NAME not in ('TEMPLATE','METADATA','config.txt') and

  2    3  CTX_TYPE='A' and (status is null or upper(status) in ('S','F'))

and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'run'

and EXTRACTVALUE(XMLType(TEXT),'//oa_service_group_status[@oa_var=''s_web_admin_status'']')='enabled'

and EXTRACTVALUE(XMLType(TEXT),'//oa_service_list/oa_service[@type=''admin_server'']/oa_service_status')='enabled';  4    5    6

NODE_NAME

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

rend

rend

SQL>