Saturday, August 23, 2008

How to export and import OAF XML customization.

Title: How to export and import customization.
steps to complete
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 step
The 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 environment
The 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

No comments: