IFS Cloud Clone

FYI, there are a series of tables that you will not want to clone between your PROD and non-PROD environments in order to keep your non-PRODs from connecting with third-party production systems (“Refresh Exclusion Tables”). Below is a list of the these for Cloud 21R2 that I got from IFS. We have used this through several refreshes already. Procedurally, you have to export these before you clone the DB and then import them back after the clone. Re-Quest, our DBA services provider handles all of this for our on-premise install of Cloud. They have also automated this process for our Apps 9 install and are working on this for Cloud.

Refresh Exclusion Tables

1. brbase_property_tab
2. common_messages_tab
3. config_instance_param_tab
4. config_instance_tab
5. connect_envelope_tab
6. connect_print_agent_task_tab
7. connect_queue_tab
8. connect_reader_tab
9. connect_sender_tab
10. connect_server_tab
11. connect_simple_routing_tab
12. connect_transformer_tab
13. custom_connector_library_tab
14. custom_reader_param_tab
15. custom_sender_param_tab
16. edm_location_tab
17. edm_location_user_tab
18. fnd_monitor_category_tab
19. fnd_monitor_entry_tab
20. fnd_setting_tab
21. media_archive_tab
22. plsqlap_environment_tab
23. remote_assist_group_user_tab
24. remote_assistance_customer_tab
25. remote_assistance_group_tab
26. remote_assistance_user_ab
27. report_plugin_settings_tab
28. routing_address_tab
29. routing_rule_address_tab
30. routing_rule_condition_tab
31. routing_rule_tab
32. scheduling_config_tab
33. svcsch_configuration_tab
34. tm_serve_parameters_tab

Refresh Exclusion Tables for Security

Excluding these additional tables will leave your security ‘as is’ in your cloned environment instead of overwriting it from the source.

1. fnd_bpa_grant_tab
2. fnd_grant_role_tab
3. fnd_proj_action_grant_tab
4. fnd_proj_ent_action_grant_tab
5. fnd_proj_entity_grant_tab
6. fnd_projection_grant_tab
7. fnd_role_tab
8. fnd_user_role_tab
9. ifsiamsys
10. pres_object_grant_tab
11. system_privilege_grant_tab