Steps to migrate personalization from one instance to another instance

Events in Source instance.

1.       Go to System Administrator set FND: Personalization Document Root Path appropriately before exporting personalization.

2.       Here already  we have set root profile to  \user\tmp

Identify the document path

From Back end:

set serveroutput on;

begin

jdr_utils.printdocuments('/oracle/apps/per/selfservice/personalinformation/webui/MainAddrPG');

end;

From Front End:

Go to Functional Administrator Click on Personalization tab.

Under Import/Export click on Personalization Repository.

Give Document Root Path as “/oracle/apps/per/selfservice/personalinformation/webui” and press

GO Page will Display all the Personalization.

Select which one you wish to Export. (You can migrate more than one at a time also, at that time select all).

Click the Export to File System button.

Click OK button.

Go to the path in FND: Personalization Document Root Path (\user\tmp) 

and run below command 

Syntax: tar -cvf <FILENAME.tar>

Ex: tar -cvf  xxmandatoryPer.tar ./*

Transfer the xxmandatoryPer.tar to destination in Binary mode

Note: Before import the file, first we have to check the .xml file whether the personalization is effected in .xml file or not

Events in Destination instance.

Set profile option FND: Personalization Document Root Path appropriately before importing

Personalization

Set same as 1^st step (\user\tmp).

Copy .tar file to middle tier directory pointed by FND: Personalization Document Root Path (\user\tmp)

Run tar –xvf xxTypemandatoryPer.tar in the location (\user\tmp)

Go to Functional Administrator Click on Personalization tab.

Under Import/Export Click on Exported Personalization.

Select the all file structure

Click on Import from File System

After successfully importing bounce Apache server.

Second Method:

set serveroutput on;

/

begin

jdr_utils.listCustomizations('/oracle/apps/per/selfservice/personalinformation/webui/MainAddrPG');

end;

/oracle/apps/per/selfservice/personalinformation/webui/customizations/site/0/MainAddrPG

Export Script.

Syntax:

java oracle.jrad.tools.xml.exporter.XMLExporter <personalization document from step #2>  \

-username "<username>" -password "<password>"  \

-dbconnection "(description=(address_list=(address=(protocol=tcp)(host=<host>)(port=<port)))(connect_data=(sid=<sid>)))" \

-rootdir "<output directory>"

Example:

java oracle.jrad.tools.xml.exporter.XMLExporter /oracle/apps/per/selfservice/personalinformation/webui/customizations/site/0/MainAddrPG.xml  \

-username "apps" -password "apps"  \

-dbconnection "(description=(address_list=(address=(protocol=tcp)(host=localhost)(port=1521)))(connect_data=(sid=xxsid)))" \

-rootdir "/usr/tmp"

Importer Script:

Syntax:

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

<full path of the file you want to import> \

-username "<username>" -password "<password>"  \

-dbconnection "(description=(address_list=(address=(protocol=tcp)(host=<host>)(port=<port>)))(connect_data=(sid=<sid>)))" -rootdir "<top level directory>" \

-rootPackage "/oracle/apps/<prod>"

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

/oracle/apps/per/selfservice/personalinformation/webui/customizations/site/0/MainAddrPG.xml \

-username apps -password apps \

-dbconnection "(description=(address_list=(address=(protocol=tcp)(host= localhost)(port=1521)))(connect_data=(sid=xxsid)))" -rootdir "/usr/tmp" \

-rootPackage "/oracle/apps/per/selfservice/personalinformation"

Note: After running the importer script. bounce the Apache server