Migration of OAF Personalization

Steps To Migrate Personalizations In OAF

Steps To Be Performed In Source Instance

• Set profile option "FND: Personalization Document Root Path" with the location (path) of the server where personalization should be extracted before exporting personalization.
• Go to Functional Administrator.Click on Personalization tab.
• Under Import/Export click on Personalization Repository.
• Give Document Root Path as "/oracle/apps/pos/supplier/webui" and press Go.Page will display all the Personalizations.
• Select all the listed Personalizations which you want to export and press Export to File System.
• Go to the path in "FND: Personalization Document Root Path" and run "  tar -cvf xxPersonalizations.tar ./*  ".
• Transfer the xxPersonalizations.tar to destination in Binary mode.

Steps To Be Performed in Destination Instance

• Set profile option "FND: Personalization Document Root Path" with the location (path) of the server (from where personalizations will be imported) before importing personalizations.
• Copy .tar file to middle tier directory pointed by "FND: Personalization Document Root Path".
• Run " tar -xvf xxPersonalizations.tar ".
• Go to Functional Administrator.Click on Personalization tab.
• Under Import/Export click on Exported Personalizations.
• Click on Import from File System as shown in the following screenshot

Note:  You can Run the below command to Import

java oracle.jrad.tools.xml.importer.XMLImporter \


Using Exporter and Importer Commands

1. Identify the Path of the Page (About this Page)

2. Copy the Path and find the Document Path using below 

begin

 jdr_utils.listCustomizations('/oracle/apps/icx/por/wf/webui/ReqLinesNotificationsRN');

end; 

OUTPUT: /oracle/apps/icx/por/wf/webui/customizations/site/0/ReqLinesNotificationsRN

Export Command to Get the files to the Folder:

java oracle.jrad.tools.xml.exporter.XMLExporter /oracle/apps/icx/por/wf/webui/customizations/site/0/ReqLinesNotificationsRN -username apps -password w3lcome123 -dbconnection "(description=(address_list=(address=(protocol=tcp)(host=myhost)(port=12345)))(connect_data=(sid=dev)))" -rootdir "$XXSCM_TOP/install" 

Import command To Upload the XML File

java oracle.jrad.tools.xml.importer.XMLImporter $XXSCM_TOP/install/ReqLinesNotificationsRN.xml -username apps -password w3lcome123 -dbconnection "(description=(address_list=(address=(protocol=tcp)(host= myhost)(port=12345)))(connect_data=(sid=dev)))" -rootdir "$XXSCM_TOP/install" -rootPackage "oracle/apps/icx/por/wf/server"