Export/ Import of OAF Personalization Pages

Export Personalization

1) Set profile option FND: Personalization Document Root Path (Eg: /tmp)

The path specified by this profile will be used by Functional Administrator Responsibility for importing and exporting personalization.

2) Go to Functional Administrator Responsibility. Click on Personalization Tab > Import/Export

In Search window give application name like "Enterprise Asset Management"
Select the pages for which you want to Export personalization.
Click on Export to File System Button.

All personalization will be exported to the location specified by the profile option.

The personalization will be moved with complete directory structure at the location specified by the profile under directory 'oracle'. We have to make a tar file using following command

tar -cvf file_name.tar oracle/

This is to create TAR for complete directory structure with files. Else specify full directory structure to get your file like below

tar -cvf file_name.tar oracle/apps/eam/workorder/webui/customizations/site/0/ExpressWorkOrderPG.xml

Note- If you are doing personalization for first time, take all the files with complete directory structure using tar command and from second time make tar of only particular file(s).

If you create a TAR every time with complete directory, it may result in overwriting of directory structure at the time of untaring.


Import Personalization

1) Set profile option FND: Personalization Document Root Path (Eg: /tmp)

The path specified by this profile will be used by Functional Administrator Responsibility for importing and exporting personalization.

2) Place your tar file at the location set above in profile option. Untar the file at this location using below command

tar -xvf file_name.tar

3) Go to Functional Administrator Responsibility. Click on Personalization Tab > Import/Export

Select Exported Personalization from menu.

We can see the directory structure on the window. Expand the structure to select the files.
Click on Import to file System Button.

View SQL Statement from OAF Page

Below are the detailed steps:

1) Update the following Profile Option Values to Yes at User level.
• FND: Diagnostics
• Personalize Self-Service Defn

2) Go to the Java OAF Page where the SQL Query executes

3) Click on the link About this Page in the bottom Left Hand Side of the page

4) Navigate to the Page Tab on the Top Left Hand Side of the page

5) In the Business Component References Details Section (You may need to expand this
section), Go to the View Objects Sub Section.

6) Find the Object that describes the piece of information that you want to find the query for

7) Click on the Link

8) The full Query used can be cut and pasted into a SQL Editor and the query run.
Note: You will have to find the Bind Variables passed to the query in order to do this!!