rapidclone finishing tasks

1. dba_libraries
(see other blog entry, login as sys)

2. dba_directories
(see other blog entry, login as sys)

3. profile options
3.1 hard-coded mounting points in profile options
select * from fnd_profile_optuion_values –search for path
update fnd_profile_option_values
set profile_option_value=replace(profile_option_value,’/data/applprod’,’/data/applptch’);

3.2 update site name
update fnd_profile_option_values set profile_option_value ='Powell GOLD '||to_char(sysdate,'mm/dd/yyyy') where profile_option_id =(select profile_option_id from fnd_profile_options where profile_option_name='SITENAME');

3.3 update color schema (for easy differentiation among different environment)

update fnd_profile_option_values set profile_option_value ='RED' where profile_option_id =(select profile_option_id from fnd_profile_options where profile_option_name='FND_COLOR_SCHEME') and LEVEL_ID=10001 and LEVEL_VALUE=0;

Other colors
select * from fnd_lookups where lookup_type ='COLOR_SCHEME'

LOOKUP_TYPE LOOKUP_CODE MEANING
COLOR_SCHEME BLAF blaf
COLOR_SCHEME BLUE blue
COLOR_SCHEME KHAKI khaki
COLOR_SCHEME OLIVE olive
COLOR_SCHEME PURPLE purple
COLOR_SCHEME RED red
COLOR_SCHEME TEAL teal
COLOR_SCHEME TITANIUM titanium


4. printer settings

5. workflow
5.1 update over email address
update fnd_svc_comp_param_vals set parameter_value='oracle.powell@powellind.com' where parameter_id=(select parameter_id from fnd_svc_comp_params_tl where language='US' and display_name='Test Address');
5.2 update source system SID (PROD) and port (8000) in the URL
wf_notification_attributes.text_value
wf_item_attribute_values.text_value

5.3 wf_system
Select * from wf_system. Need to update name and display_name.
wf_system.GUID
wf_system.name

5.4 wf_agents.address
Select * from wf_agents. Need to update address
wf_agents.address

6. forms (optional)

fnd_form_functions.web_host_name
fnd_form_functions.web_agent_name

7. concurrent requests

fnd_concurrent_requests.log_file_name
fnd_concurrent_requests.out_file_name

8. cookie (in case load balancer and web servers on different domain)

example: web servers: .powellind.pri and load balancer: .powellind.com

update session_cookie_domain using the load balancer domain.

Update icx_parameters set session_cookie_domain = ‘.powellind.com’;

icx_parameters.session_cookie_domain

9. check $APPLCSF

10. dba_services (optional)
(see other blog entry, login as sys)

11. others

check fnd_concurrent_queues.node_name and node_name2, fnd_concurrent_requests.logfile_node_name.