Useful Scripts in OA Frame Work

1.1. Upload a Single PG.xml file

1.1.1.  From Command Prompt

·         <JDEV_DIR>\jdevbin\jdev\bin\import <JDEV_DIR>\jdevbin\jdev\myclasses\xxt\oracle\apps\pon\registration\webui\XXTSupplierRegistrationPG.xml -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<DB_HOST_NAME>)(PORT=<DB_PORT>))(CONNECT_DATA=(SID=<DB_SID>)))" -rootDir <JDEV_DIR>\jdevbin\jdev\myclasses\ -rootPackage /


·         java oracle.jrad.tools.xml.importer.XMLImporter CarLoanViewOnlyPG.xml  -username <user name> -password <password> -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=<port number>))(CONNECT_DATA=(SID=<SID>)))" -rootdir ./ -rootPackage /xxmhp/oracle/apps/per/carloan/webui

1.1.2.  From Unix Box

·         java oracle.jrad.tools.xml.importer.XMLImporter CarLoanViewOnlyPG.xml  -username <user name> -password <password> -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<hostname>)(PORT=<port number>))(CONNECT_DATA=(SID=<SID>)))" -rootdir ./ -rootPackage /xxmhp/oracle/apps/per/carloan/webui


1.2. Upload multiple PG.xml files

·         <JDEV_DIR>/jdevbin/jdev/bin/import <JDEV_DIR>/jdevbin/jdev/myclasses /oracle/apps/xxpo/pdt/ordering/webui -rootDir <JDEV_DIR>/jdevbin/jdev/myclasses / -username apps -password <APPS_PASSWORD> -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<DB_HOSTNAME>)(PORT=<DB_PORT>))(CONNECT_DATA=(SID=<DB_SID>)))" -includeSubpackages -jdk13 -mmddir <JDEV_DIR>/jdevbin/jdev/lib/ext/jrad/config/mmd -rootPackage /

1.3. When you have the Substitutions upload the JPX using the following script from the UNIX prompt

1.3.1.  From Command Prompt

·         export /oracle/apps/ap/oie/server/HomePageAM –rootdir D:\JDev9\jdevbin\jdev\bin\myprojects -username apps -password apps –dbconnection "(description = (address_list = (address = (community = tcp.world)(protocol = tcp)(host =192.168.2.222)(port = 1521)))(connect_data = (sid = vis)))"

1.3.2.  From Unix Box

·         java oracle.jrad.tools.xml.importer XXMHPIprocChargeAccountDesc.jpx -username <Database User Id> -password <Password> -dbconnection "(description=(address_list=(address=(protocol=tcp)(host=<Host Name>)(port=<Port Number>)))(connect_data =(sid=<SID>)))"


1.4.               Download Components From Server (Important For Standard Pages Downloading)

1.4.1.  From Command Prompt
·         export /oracle/apps/ap/oie/server/HomePageAM –rootdir D:\JDev9\jdevbin\jdev\bin\myprojects -username apps -password apps –dbconnection "(description = (address_list = (address = (community = tcp.world)(protocol = tcp)(host =192.168.2.222)(port = 1521)))(connect_data = (sid = vis)))"

1.4.2.  From Unix Box
·         java oracle.jrad.tools.xml.exporter.XMLExporter /oracle/apps/icx/icatalog/shopping/webui/NonCatalogRequestPG -rootdir $JAVA_TOP/xxtgf -username apps -password Y6wNI1mh -dbconnection "(description = (address_list = (address = (community = tcp.world)(protocol = tcp)(host = auohstgfu01.oracleoutsourcing.com) (port = 12510)))(connect_data = (sid = TTGF2I)))"

1.5.               View  Documents
Begin
Jdr_utils.printDocument(‘/oracle/apps/pon/award/completion/webui/ponCompleteAward2PG’);
End;

1.6.               To find the personalized file path for a particular PG.xml
begin
jdr_utils.listCustomizations('/oracle/apps/fnd/framework/navigate/webui/AppsNavigateMobilePG');
end;

1.7.               To download the personalized file, first run the above script in SQL, that will display the full path for the personalized file, then run the below command
Begin
Jdr_utils.printDocument (‘/oracle/apps/fnd/framework/navigate/webui/customizations/site/0/AppsNavigateMobilePG’);
End;

1.8. To create translations for the personalized page or for a custom page, download the corresponding xlf file for the personalized page or the custom page. Then change the prompts in the destination language and import the page again.

1.8.1.  Extract XLF file for a particular directory (For arabic language, for a different language, change accordingly).

·         <JDEV_DIR>\jdevbin\jdev\bin\xliffextract /xxt/oracle/apps/pon/registration/webui -includeSubpackages -mmd_dir D:\Jdev1150CU2\jdevbin\jdev\lib\ext\jrad\config\mmd -root D:\Temp\XLIF\registration -xliff_dir D:\Temp\XLIF\registration -source db -username apps -password <APPS_PASSWORD> -dbconnection "(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=<DB_HOSTNAME>)(PORT=<DB_PORT>))(CONNECT_DATA=(SID=<DB_SID>)))" -languages ar-AE

1.8.2.  Extract XLF file for a particular file(For arabic language, for a different language, change accordingly).

·         <JDEV_DIR>\jdevbin\jdev\bin\xliffextract /oracle/apps/pon/outcome/creation/webui/customizations/site/0/ponCreatePOPG -root D:\temp -xliff_dir D:\temp -mmd_dir <JDEV_HOME>\jdevbin\jdev\lib\ext\jrad\config\mmd\ -source db -username apps -password <APPS_PASSWORD> -dbconnection " (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL= TCP)(HOST = <DB_HOSTNAME>)(PORT = <DB_PORT>)) ) (CONNECT_DATA = (SERVICE_NAME = <DB_SID>) ) )" -languages ar-AE

1.9.  To find the personalization for a particular object or for the whole system or for a particular package.

Login with the user who has Functional Administrator responsibility, you search the Object you have substituted (Functional Administrator=>Personalization=>Import/Export).
Search with a particular path, Eg. /oracle/apps/icx will give all the personalization under the path.
If the the profile option “FND: Personalization Document Root Path” set properly, the personalization can be exported to the system directly.