Monday, October 23, 2017

OAF JDR Utilities and Commands

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.

No comments:

Post a Comment