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.
