How to export and import customization

1. Find the name of the page having required personalization Click the "about this page" link at the bottom of the page Copy the full page name (including path)
2. For every page - find a list of customizations
sqlplus apps/
set lines 300
set serveroutput on
exec dbms_output.enable(1000000);
exec jdr_utils.listCustomizations('');
exit;
3. Download customizations found in the previous stepThe following should be done for every customization:
java oracle.jrad.tools.xml.exporter.XMLExporter "" -username "apps" -password -dbconnection "(description=(address_list=(address=(community=tcp.world)(protocol=tcp)(host= port=)))(connect_data=(sid=)))" –rootdir - source database host - source database port - source database SID This will create a file .xml in current directory
4. Upload customizations to other environmentThe following should be done for every customization downloaded in previous step:
java oracle.jrad.tools.xml.importer.XMLImporter .xml -username "apps" -password -dbconnection "(description=(address_list=(address=(community=tcp.world)(protocol=tcp)(host=)(port=)))(connect_data=(sid=)))" -rootdir . -rootPackage
- target database host
- target database port
- target database SID