For personalized pages that have been created in or migrated to Oracle JDeveloper OA Extension, the meta data can either be in the form of XML files on the file system or stored in the MDS (Meta Data Services) repository. By exporting meta data into XML files on the file system, you can easily move those files to another system or simply login to a different environment and import those XML files to a new database instance. The Functional Administrator responsibility provides a simple UI that lets you both export meta data to XML files, and import XML files into a MDS repository.
Set the profile option FND: Personalization Document Root Path (FND_PERZ_DOC_ROOT_PATH) to a root directory in your file system where your files are to be exported to or imported from.
For more information about the FND: Personalization Document Root Path profile option, refer to the Personalization section in the OA Framework Profile Options appendix of the Oracle Application Framework Developer's Guide.
Log in to the Oracle E-Business Suite under the Functional Administrator responsibility.
Select the Personalizations tab, then select the Import/Export sub tab.
The Personalization Repository page renders an HGrid that represents the personalized contents of the MDS repository. You may expand nodes in the HGrid to search for and select specific personalized regions or pages to export to an XML file. Note that base documents are not shown in this repository. You may also select nodes (packages) from this HGrid to export to an XML file. Note that if you select a node to export, then all packages and documents contained within that selected node are exported.
The focus of the HGrid is initially set to the /oracle/apps/ node. The root path when the HGrid first renders, is always /oracle.
You may expand the HGrid at the initial focus, but note that there are a large number of applications to browse through at this level. Instead, you may want to plan ahead and use the Search region above the HGrid to identify specific applications or personalized pages, regions or packages. The Search region allows you to search by Application Name or Document Path and well as by a range of Last Updated dates. The search results are shown in the HGrid.
Select the pages, regions or packages you wish to export, then select Export to File System to export the selection to the directory specified by the profile option FND: Personalization Document Root Path (FND_PERZ_DOC_ROOT_PATH). You may also select Delete to delete your selection from the repository.
Once you export your meta data to XML files on the file system, you should login to the other Oracle E-Business Suite environment that you want to import these files to, and set the profile option FND: Personalization Document Root Path (FND_PERZ_DOC_ROOT_PATH) to the file system location of the exported XML files.
To import the XML files from your file system into another MDS repository, login to the other Oracle E-Business Suite environment as a Functional Administrator. Select the Personalizations tab, then select the Import/Export sub tab. Select Exported Personalizations from the side navigation menu to display the Exported Personalizations page.
The HGrid in the Exported Personalizations page displays all the documents present in the directory specified by the profile option FND: Personalization Document Root Path (FND_PERZ_DOC_ROOT_PATH). Select all the documents you wish to import and choose Import from File System.
You may expand nodes in the HGrid to search for and select specific personalized regions or pages to import from the file system. You may also select nodes (packages) from this HGrid to import all packages and documents contained within that selected node.