OAF JDR Utilities and Commands
Jpximport, export and import commands
are located in below path
<JDEV INSTALL DIR>\jdevbin\oaext\bin
For ex:-
E:\JDeveloper\jdevbin\oaext\bin
JPXImport
Command for applying substitutions
jpximport jpx_file_path
-username "username"
-password "password"
-dbconnection "database
connection string in TNSNAMES format"
Example:
<JDEV INSTALL DIR>\jdevbin\oaext\bin\jpximport
d:\myprojects\project1.jpx -username "apps" -password "<apps password>" -dbconnection
"(description=(address_list=(address=(protocol=tcp)(host=<hostname>)(port=<port>)))(connect_data=(sid=<YOUR SID>)))"
d:\myprojects\project1.jpx contains substitution details.
Export command for exporting OAF pages from server
export package or document name
-rootdir
"Output directory"
-username
"Username"
-password
"Password"
-dbconnection "Database connection string in TNSNAMES format"
Example:-
Navigate to <JDEV_HOME>\myprojects and execute below
command, so that ReqLinesNotificationsRN.xml file will be created in <JDEV_HOME>\myprojects\oracle\apps\icx\por\wf\webui
directory i.e.
cd <JDEV_HOME>\myprojects
<JDEV INSTALL DIR>\jdevbin\oaext\bin\export
/oracle/apps/icx/por/wf/webui/ReqLinesNotificationsRN -username "apps" -password
"<apps password>" -dbconnection
"(description=(address_list=(address=(protocol=tcp)(host=<hostname>)(port=<port>)))(connect_data=(sid=<YOUR SID>)))" -rootdir .
Import command for importing OAF pages into the server
import package directory path* or XML file path
-rootdir
"XML source directory"
-username
"Username"
-password
"Password"
-dbconnection "Database connection string in TNSNAMES format"
For ex:-
Navigate to <JDEV_HOME>\myprojects and execute below
command, so that <JDEV_HOME>\myprojects\xxcust\oracle\apps\icx\por\webui\XXFileUploadPG.xml
file will be imported to the server
cd <JDEV_HOME>\myprojects
<JDEV INSTALL DIR>\jdevbin\oaext\bin\import xxcust/oracle/apps/icx/por/webui/XXFileUploadPG.xml
-username "apps" -password "<apps
password>" -dbconnection
"(description=(address_list=(address=(protocol=tcp)(host=<hostname>)(port=<port>)))(connect_data=(sid=<YOUR SID>)))" -rootdir .
Some JDR Utilities
1. jdr_utils.listdocuments
prints
the list of all OAF customizations/personalizations done for a given path.
For ex:- jdr_utils.listdocuments('/oracle/apps/icx/por/wf/server',TRUE);
Second parameter denotes whether it
should be recursive search or not. Above command prints all customizations/personalizations
under /oracle/apps/icx/por/wf/server path
Sample output for above command, if
ReqLinesNotificationsVO, RCOReqLinesNotificationsVO, RCOBuyerApprovalNotfnVO
are substituted with custom VOs is:-
Printing contents of /oracle/apps/icx/por/wf/server
recursively
/oracle/apps/icx/por/wf/server/customizations/site/0/RCOBuyerApprovalNotfnVO
/oracle/apps/icx/por/wf/server/customizations/site/0/RCOReqLinesNotificationsVO
/oracle/apps/icx/por/wf/server/customizations/site/0/ReqLinesNotificationsVO
2. jdr_utils.listcustomizations
Lists the details of levels of Personalizations/customizations
done for a given document .
For ex:-
jdr_utils.listcustomizations('/oracle/apps/icx/por/req/webui/ShoppingCartPG');
Lists below output to denote that there are
personalizations/customizations done at site level, at 34 org level, and at 50345
responsibility level.
/oracle/apps/icx/por/req/webui/customizations/site/0/ShoppingCartPG
/oracle/apps/icx/por/req/webui/customizations/org/34/ShoppingCartPG
/oracle/apps/icx/por/req/webui/customizations/responsibility/50345/ShoppingCartPG
3. jdr_utils.printdocument
prints the details of customization/personalization
done, given the path for document.
For ex:-
jdr_utils.printdocument('/oracle/apps/icx/por/wf/server/customizations/site/0/ReqLinesNotificationsVO');
Prints below output, to denote that
standard VO “/oracle/apps/icx/por/wf/server/ReqLinesNotificationsVO” is
substituted with custom VO “/xxcust/oracle/apps/icx/por/wf/server/xxReqLinesNotificationsVO”
<?xml version='1.0'
encoding='UTF-8'?>
<customization
xmlns="http://xmlns.oracle.com/jrad" xmlns:ui="http://xmlns.oracle.com/uix/ui"
xmlns:oa="http://xmlns.oracle.com/oa"
xmlns:user="http://xmlns.oracle.com/user"
version="10.1.3_1312" xml:lang="en-US"
customizes="/oracle/apps/icx/por/wf/server/ReqLinesNotificationsVO">
<replace with="/xxcust/oracle/apps/icx/por/wf/server/xxReqLinesNotificationsVO"/>
</customization>
4. jdr_utils.deletedocument
This deletes the personalization/customization,
given the corresponding document path.
For ex:- jdr_utils.deletedocument(‘/oracle/apps/icx/por/wf/server/customizations/site/0/ReqLinesNotificationsVO’);
deletes the VO substitution.
