validation

 col directory_path  for a100

set pages 1000 lines 150            

select directory_name,directory_path from dba_directories;

SET LINESIZE 150

COLUMN owner FORMAT A20
COLUMN directory_name FORMAT A25
COLUMN directory_path FORMAT A80

SELECT *
FROM   dba_directories
ORDER BY owner, directory_name;

+++++++++

SQL:

 

select 'CREATE OR REPLACE DIRECTORY '||directory_name||' as '''|| directory_path||''';' from dba_directories;

                                      

OR

 

update dir$ set OS_PATH=replace(OS_PATH,'&OLD_VALUE','&NEW_VALUE') where OS_PATH like '%&OLD_VALUE%';

+++

Update Site Name:

 

Update the Below function. Change the value according to the instance

 

update fnd_form_functions_tl

set user_function_name = ' from PROD (BKP 16-MAY-16)'

where function_id in (select function_id from fnd_form_functions where function_name = 'FWK_HOMEPAGE_BRAND') and LANGUAGE='US';

 

 

set pages 1000 lines 150

col user_function_name for a80

select LANGUAGE,FUNCTION_ID,user_function_name  from fnd_form_functions_tl where function_id in (select function_id from fnd_form_functions where function_name = 'FWK_HOMEPAGE_BRAND') and LANGUAGE='US';

 +++

Once REGOID is completed, we need to follow the attached mail steps to populate the data in OID tables.

 SQL>  execute fnd_oid_plug.setPlugin;

 

SQL> SELECT * FROM fnd_user_preferences WHERE user_name='#INTERNAL' AND module_name='OID_CONF';