Forms and Reports Conversion Step:
Step 1. Rename all source_code into lower_case. Step 2. Compile *.pll, *.mmb, *.fmb, *.rdf and Convert plsql to 6i using batch Step 3. Check any problem creating executable files (fmx, rep) – most of the problems are with the synonym name that include dblink. Recreate synonym. Step 4. Open Linux virtual box. Backup appl_directory by rename to old_appl_directory. Create new appl _directory. Step 5. Open Fizella - Ftp all 6i files pll, *.mmb, *.fmb, *.rdf into Linux virtual box new appl_directory. Step 6. Convert library $ frmplsqlconv.sh mode=wizard Select *.pll files to compile .pll and change log=converter_pll.log Step 7. Convert menu $ frmplsqlconv.sh mode=wizard Select *.mmb files to compile .mmb and change log= converter_mmb.log Step 8. Convert form $ frmplsqlconv.sh mode=wizard Select *.fmb files to compile .fmb and change log=converter_fmb.log Step 9. Copy rp2rro.pll & EnableDisableItem.pll from /u01/app/oracle/forms to current working directory. directory. rp2rro.pll - converted file will use this library in order to run_report_object. EnableDisableItem.pll – converted file will use this library in order to enable and disable item. $ cp /u01/app/oracle/rp2rro.pll . $ cp /u01/app/oracle/EnableDisableItem.pll . Step 10. Set oracle environment in order to execute any form and report command $ export ORACLE_HOME=/u01/app/oracle $ export ORACLE_TERM=VT220 Step 11. Convert *.rdf report files using batch file - convertreport.sh
$ more convertreport.sh # CONVERT REPORTS for i in `ls *.rdf` do echo Convert Report $i ... rwconverter.sh userid=username/password@dasar batch=yes source=$i stype=rdffile dtype=rdffile overwrite=yes compile_all=yes done $ . /convertreport.sh
Step 12. Convert *.pll report files using batch file - compilelibrary.sh
$ more compilelibrary.sh # COMPILE LIBRARY for i in `ls *.pll` do echo Compile Library $i ... frmcmp_batch.sh userid=username/password@dasar batch=yes module=$i module_type=LIBRARY compile_all=yes window_state=minimize done $ . /compilelibrary.sh /compilelibrary.sh Step 13. Convert *.mmb report files using batch file - compilemenu.sh
$ more compilemenu.sh # COMPILE MENU for i in `ls *.mmb` do echo Compile Menu $i ... frmcmp_batch.sh userid=username/password@dasar batch=yes module=$i module_type=MENU compile_all=yes window_state=minimize done $ . /compilemenu.sh Step 14. Convert *.fmb report files using batch file - compileform.sh
$ more compileform.sh # COMPILE FORM for i in `ls *.fmb` do echo Compile Form $i ... frmcmp_batch.sh userid=username/password@dasar batch=yes module=$i module_type=FORM compile_all=yes window_state=minimize done $ . /compileform.sh Step 15. Convert *.rdf report files using batch file - compilereport.sh
$ more compilereport.sh # COMPILE REPORTS for i in `ls *.rdf` do echo Convert Report $i ... rwconverter.sh userid=latihan/password@dasar batch=yes source=$i stype=rdffile dtype=repfile overwrite=yes compile_all=yes done $ . /compilereport.sh
Step 16. Check log file. If error – modify using form builder or report builder and compile again until no more errors. You need to set oracle environment before run the following command (Step 10). Open Oracle Form Builder to modify library, library, menu and form $ frmbld.sh& You can compile library, library, menu and form in form builder using Ctr l-T Open Oracle Report Builder to modify report $ rwbuilder.sh& Open Oracle Report Converter to compile report $ rwconverter.sh& Compile .pll using command line $ frmcmp_batch.sh userid=username/password@dasar batch=yes module=filename.fmb module_type=LIBRARY compile_all=yes Compile .mmb using command line $ frmcmp_batch.sh userid=username/password@dasar batch=yes module=filename.fmb module_type=MENU compile_all=yes Compile .fmb using command line $ frmcmp_batch.sh userid=username/password@dasar batch=yes module=filename.fmb module_type=FORM compile_all=yes Compile .rdf using command line $ rwconverter.sh rwconverter.sh userid=latihan/password@dasar batch=yes source=reportname.rdf stype=rdffile dtype=repfile overwrite=yes compile_all=yes Step 17. Co nnect to Oracle App lication Server. Server. Create new directory. $ ssh 192.168.1.213 $ pwd /home/oracle $ ls appl_directory If exist then rename appl_directory to old_appl_directory $ mv appl_directory old_appl_directory If not exist then create appl_directory $ mkdir appl_directory $ exit Step 18. Transfer local linux files to application server $ scp *.pll *.plx *.mmb *.mmx *.fmb *.fmx *.rdf *.rep
[email protected]:/home/oracle/appl_directory Step 19. Convert *.ico to *.gif using IrfanView. eg: C:\dbp\gif\*.gif Step 20. Create jar file for *.gif C:\dbp\gif>C:\
\jdk\bin\jar.exe Home>\jdk\bin\jar.exe –cvf .jar *.g if Step 21. Use Filezilla to ftp .jar to [email protected]:/u01/app/oracle/OraHome_1/forms/java/
Step 22. Modify form and report configuration files in application server $ ssh 192.168.1.213 $ pwd /home/oracle $ . envIAS $ cd $ORACLE_HOME/forms/server $ vi default.env add appl_directory into forms_path separate by : $ vi formsweb.cfg create new configuration for appl to be access by user eg: dbp-hr $ cd $ORACLE_HOME/bin $ vi reports.sh add appl_directory into reports_path separate by : Step 23. Stop and Start Application Server (only if default.env and reports.sh is modified) $ opmnctl status check status appl server $ opmnctl stopall stop appl server $ opmnctl status check status appl server make sure already down $ opmnctl startall start appl server Step 24. Open Notepad w ith run .exe as Administrator. Administrator. Open file C:\windows\system32\drivers\etc\hosts. Add the following command: 192.168.1.213 dbpmid.dbp.gov.my dbpmid Step 25. check your appl. Using the following url http:192.168.1.213:7777/forms/frmservlet?config=dbp-hr Step 26. Test your appl. If your applications return error then repeat step 16 to step 18.
