Tools to convert .Class files to .Java files

Converting .Class files to .Java file is very important step in OAFramework Extensions. Below are the most used tools to perform this.


Tool : JAD  
             
    Download Link for JAD
  

Command to Convert all class files to java files under all subdirectories with Original Folder Structure

jad -o -r -sjava -dsrc c:/jadnt158/Samp/**/*.class

Command to delete all class files in subdirectories

Del /s *.class –

Tool: FrontEnd                


    Download Link for FrontEnd


Tool: Cavaj

                    

    Download Link for CAVAJ

Important Profile Options realted to OA Framework

Personalize Self-Service Defn / FND_CUSTOM_OA_DEFINTION

This is intended for system administrators who wish to personalize regions at the localization, site, verticalization, org and responsibility levels. On enabling this profile option for the administrator, every OA Framework page will contain a global Personalize button. By clicking on this global button, the administrator can personalize the regions available on that page.

Disable Self-service Personal / FND_DISABLE_OA_CUSTOMIZATIONS

This is a system profile option specifically created for use by Oracle Support. You can set this profile option to "Yes" or "No" at the site or application level. If this system profile option is set to Yes, any personalizations made by the customer, regardless of the level at which the personalizations were made, will not be applied. All pages using OA Framework will now display the regions based on their original definitions.

Note: When this profile is set to "Yes", a warning message that all personalizations are disabled is displayed on every page to which a user navigates.

FND: Personalization Region Link Enabled / FND_PERSONALIZATION_REGION_LINK_ENABLED

Enables the "Personalize Region" links on a page if the Personalize Self-Service Defn / FND_CUSTOM_OA_DEFINTION profile is set to Yes.

Fnd Xliff Export Root Path / FND_XLIFF_EXPORT_ROOT_PATH

Use this profile option to set the root path used to generate the full path where the Xliff files are exported to when users extract their translated personalizations using the Extract Translation Files page in OA Personalization Framework. The permissions for the root path directory that you specify must be set to read, write, create for all users, using chmod 777 [dir_path].

Xliff Import Root Path / FND_XLIFF_IMPORT_ROOT_PATH

Use this profile option to set the root path used to derive the full path from where the Xliff files are uploaded when users use the Upload Translations page in OA Personalization Framework to upload translated personalizations.

FND: Personalization Document Root Path / FND_PERZ_DOC_ROOT_PATH

Use this profile option to define the root path where personalizations documents are exported to or imported from when users use the Database page or the File System page of the Functional Administrator responsibility's Document Manager, respectively.

Recommended this profile set to the $APPL_TOP staging area:

              $APP_TOP/<CompanyIdentifier>/

             <CustomProductShortName>/

            <product-version>/mds/webui

of the current deployed environment, where personalization documents are to be imported from or exported to. This profile option should be set at the Site level.

FND: Diagnostics / FND_DIAGNOSTICS

Setting this to “Yes” causes a Diagnostics global button to render on every page. Select this button to view the log messages for the page. Enabling this profile also automatically renders the "About this page" link at the bottom of every OA Framework page.

Useful Scripts in OA Framework

Upload a Single PG.xml file

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 /

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

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 /

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

From Unix Box

·         java oracle.jrad.tools.xml.importer.JPXImporter 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>)))"

Download Components From Server (Important For Standard Pages Downloading)

From Command Prompt

·         export /custom/oracle/apps/apc/webui/dseInvoiceReviewRn -rootdir U:\viji\Jdeveloepr9i\jdevhome\jdev\myprojects -username apps -password applsys97 -dbconnection "(description = (address_list = (address = (community = tcp.world)(protocol = tcp)(host =d00725)(port = 1525)))(connect_data = (sid = DEVF)))"

From Unix Box

·         java oracle.jrad.tools.xml.exporter.XMLExporter /oracle/apps/rrs/site/user/webui/CreateMethodforSiteTempPG -rootdir $JAVA_TOP/chola -username apps -password apps -dbconnection "(description = (address_list = (address = (community = tcp.world)(protocol = tcp)(host = ) (port = )))(connect_data = (sid = )))"

View  Documents

Begin

Jdr_utils.printDocument(‘/oracle/apps/pon/award/completion/webui/ponCompleteAward2PG’);

End;

To find the personalized file path for a particular PG.xml

begin

jdr_utils.listCustomizations('/oracle/apps/fnd/framework/navigate/webui/AppsNavigateMobilePG');

end;

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;

DELETE A DOCUMENT OR DELETE A PERSONALIZATION OR     DELETE AN EXTENSION OR A SUBSTITUTION

The title says it all. Once you have found the exact name of the document with its full path [using jdr_utils.listdocuments], you can then delete the same by using command below.

For example to delete the Application Module substitution, use command

DECLARE
BEGIN
jdr_utils.deletedocument(p_document => '/oracle/apps/per/irc/candidateSelfService/server/customizations/site/0/VisitorAM');
END;

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.

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

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

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.