Migration of OAF Personalization

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"


 


Comments

Post a Comment

Popular posts from this blog

Oracle BI Publisher Tags For-each grouping for Matrix report

For-Each Extensions For-each tags can be confusing.  We will be going over the following tags:     For-each@ section :    For-each@ cell   For-each- group :   field1; field2;     For-each-group: current-group() ;field3;   For-each-group@ column       Sample XML:  <CORPORATION>      <NAME>Vision</NAME>     <DEPT>     <DEPT_NAME>IT</DEPT_NAME>      <EMPLOYEE>         <EMPNO>6</EMPNO>        <ENAME>Rich Walker</ENAME>        <JOB>CLERK</JOB>        <SAL>100</SAL>     </<EMPLOYEE>>     <EMPLOYEE>        ...
Read more

SQL Scripts for Custom Table Creation in Oracle Application 12.2.x

Due to introduction of Online Patching, Post 12.2.x version, there are certain steps to be followed while creating Custom Table. 1. For new table creations - after creating the table in custom schema execute below script to generate edition view and synonym for it in APPS schema. exec AD_ZD_TABLE.UPGRADE('xxcust_schema','xxcust_Table'); 2. For table alterations - after running the DDL run below script to regenerate the edition view for synchronizing any table changes. exec AD_ZD_TABLE.PATCH('xxcust_schema','xxcust_table') 3. Table grants must be done through API to avoid invalids. exec AD_ZD.GRANT_PRIVS('SELECT','xxcust_table,'xx_role') 4. To view objects in all editions, add "_ae" to the data dictionary views select * from user_objects_ae; 5. To update seed data tables in Patch edition, execute prepare command. example:  exec ad_zd_seed.prepare('WF_MESSAGES');  The prepare Procedure will creat...
Read more

Oracle Fusion Business Intelligence Roles

Oracle Business Intelligence roles apply to both Oracle Business Intelligence Publisher and Oracle Fusion Transactional Business Intelligence. They grant access to Business Intelligence functionality, such as the ability to run or author reports. These roles are in addition to the roles that grant access to reports, subject areas, Business Intelligence catalog folders, and HCM data. This topic describes the Business Intelligence roles. This table lists the Business Intelligence roles. Business Intelligence Role Description BI Consumer Role Runs Business Intelligence reports. BI Author Role Creates and edits reports. BI Administrator Role Performs administrative tasks such as creating and editing dashboards and modifying security permissions for reports, folders, and so on. BI Publisher Data Model Developer Role Creates and edits Business Intelligence Publisher data models. BI Consumer Role The predefined Transactional Business Intelligence Transacti...
Read more