OAF personalization migration script

OAF personalization migration script

In this post , We will discuss , how we can migrate oaf Personalizations with the help of Scripts. Oracle application has provided the scripts which helps to export and import OAF Personalizations from one instance to another. We need to run these scripts in the Oracle application server and then these scripts will automatically export oaf Personalizations from one instance and then we need to put these files in the target instance where we want to create the Exported Personalizations and then run the import script in the target instance and this import scripts will automatically create the OAF Personalizations in this instance.  

 

Details about OAF personalization migration script

 

Run the below command in the Instance where you want to Export your personalization.

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>"

Run the below command in the Instance where you want to import your personalization.

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>"

 

Or Either you can also done from front end too with these below steps.

 

 

Step1 : -  I am sharing below profile , you have to set valid server path of you instance from where you want to copy the Personalizations.

'FND: Personalization Document Root Path'

As an example I set path /usr/tmp

 

Step2:- Go to Functional Administrator.

 

Step3- Go to Personalization Tab

Then Go to Personalization Repository.

 

 

 

 

Step 4:- Then enter the Document path/ page path for which you want to download all your Personalizations as below.
Select pages and click on Export to File System button.

This will save the Personalization registration in a file and will put this file under  path '/usr/tmp'

'FND: Personalization Document Root Path'

As an example I set path /usr/tmp


You have to copy this file in your desktop.

 

Step 8:- After Copy the file in you desktop. Then you have move this file to your target system server path.

You have to copy that path where you have moved this personalization registration file in target system/production.

Then again open the Target system application and set the below profile
'FND: Personalization Document Root Path'  to the path where you have moved the personalization file in your target system.

Step9 :- Then again go to Target system application and go to functional administrator and then personalization tab and Click on Exported Personalization's and upload all the personalization registrations.

After this you can check your personalization has been created in your targeted application.