Hire me on UpWork

Sunday, June 5, 2011

How to Compile All Oracle Forms(.fmb to .fmx) Together ?

You need to write a script on the operating system to call "frmcmp" executable.


1.Pls open a note pad and paste the following lines...


::compile_forms.bat
cls
Echo compiling Forms....
for %%f IN (*.fmb) do frmcmp.exe userid=user_name/password@db  module=%%f batch=yes
    module_type=form compile_all=yes window_state=minimize
ECHO FINISHED COMPILING



2. change the user name , password and the database alias accordingly...
3. Pls save the file with a name.bat then...
4.put this file in the forms folder then...
5.Double click on that batch it will compile all the forms in that folder consequently...

Posted by at
Labels:

28 comments:

  1. sap testing toolsJanuary 9, 2012 at 11:39 PM

    This is very interesting topic which describe how you can compile all Oracle forms together. The method is not difficult but you need to be bit careful while applying it as there is no chance of error. Consider the above points. Thanks.

    ReplyDelete
  2. husainAugust 18, 2012 at 4:23 AM

    Hi.
    Batch file is executing but not creating fmx.. is there any way we can generate a log of the same.

    Thanks & Regards
    Hussain Zaki

    ReplyDelete
  3. Md. Hamidur Rahman SiddiqueAugust 26, 2012 at 7:52 PM

    Salam Hussain Zaki,

    Did you put the batch file in the same folder, where the .fmb exist ?
    And what is your form version ?
    --if 6i then frmcmp.exe should be ifcmp60.exe

    Thanks

    ReplyDelete
  4. RasselJanuary 26, 2013 at 11:26 AM

    Thank You very much.

    ReplyDelete
  5. AnonymousMarch 1, 2013 at 1:37 PM

    Thank you!! perfect compilation, regards

    ReplyDelete
  6. In Joe and Yoly's World...March 14, 2013 at 12:40 AM

    This comment has been removed by the author.

    ReplyDelete
  7. AnonymousMay 30, 2013 at 7:22 AM

    Thanks, very useful!!!

    ReplyDelete
  8. Md. Hamidur Rahman SiddiqueMay 30, 2013 at 12:13 PM

    Thanks Allah (swt) for this... your are welcome @ anonymous

    ReplyDelete
  9. ImranJune 1, 2013 at 12:14 AM

    It's very helpful bro ..!!

    ReplyDelete
  10. UnknownAugust 22, 2013 at 7:30 PM

    .err file generating, pls help

    ReplyDelete
    Replies
    1. Giri BabuSeptember 23, 2013 at 4:52 PM

      Please make sure that files are not in read-only mode. For me .err file and .fmx is generating and if i open ".err" it contatins the message "Created form file xxx.fmx"

      Delete
  11. Giri BabuSeptember 23, 2013 at 4:47 PM

    Thank you. It is very helpfull...

    ReplyDelete
  12. kiran negiloniDecember 15, 2013 at 12:02 AM

    Thanks alot.. it helped

    ReplyDelete
  13. AnonymousFebruary 5, 2014 at 11:43 AM

    Thanks bro...it helps me.

    ReplyDelete
  14. Md. Hamidur Rahman SiddiqueFebruary 11, 2014 at 9:45 AM

    you are welcome..

    ReplyDelete
  15. AnonymousFebruary 15, 2014 at 12:41 AM

    Hi,
    I have 19 forms which are giving error FRM-30085: Unable to adjust form for output.
    All of them compile and build fine when compiling in forms builder.
    i tried with frmcmp.sh module=example.fmb userid=$UP module_type=FORM
    19 forms errored - same error no other message
    Then I changed the command to frmcmp.sh module=example.fmb userid=$UP module_type=FORM compile_all=YES
    Now 9 forms erred same error message... what other setting do u think i should add and check?

    ReplyDelete
    Replies
    1. AllisonFebruary 20, 2016 at 12:09 AM

      were you able to resolve this issue? I have a form with the same error that has successfully compiled previously and still compiles in builder without error - please email me at aleech@fs.fed.us if you found a solution

      Delete
  16. UnknownApril 8, 2014 at 6:28 PM

    hi,
    i am new in development.i saw your answer. but i am not understand where i have to put that file means in which form

    ReplyDelete
    Replies
    1. AnonymousApril 20, 2014 at 10:24 AM

      put the batch file along with your forms.

      Delete
  17. supriya kMarch 18, 2016 at 10:28 AM

    hi,
    i have migrated forms from 6i to 11g .few fmbs when opened from forms builder 11g compiles(shift+ctrl+k) and generates fmx (ctrl+T) but if i run the same fmb using compile.bat file it will give forms error FRM-30085: Unable to adjust form for output.
    I tried converting into xml and xml back to fmb still it dint work .
    Kindly help .

    ReplyDelete
    Replies
    1. Md. Hamidur Rahman SiddiqueMarch 18, 2016 at 5:19 PM

      Please post at https://community.oracle.com/community/development_tools/forms

      Delete
  18. AnonymousApril 1, 2016 at 12:56 PM

    Bundles of thanks sir, be blessed always!

    ReplyDelete
  19. UnknownFebruary 13, 2017 at 6:32 PM

    thank you very much for this help

    ReplyDelete
  20. AnonymousJanuary 3, 2018 at 12:57 PM

    hello,

    thank you for this topic. i just wanna ask if this kind of commands is applicable in linux environment or not ?

    if it does not then what commands that can run compile all fmb at once in linux ?

    thank you for your help.

    ReplyDelete
  21. UnknownFebruary 7, 2018 at 4:27 PM

    Hi, I am also facinng the frm-30085- unable to adjuct form output. could you please me on this issue

    ReplyDelete
  22. Krishna Balan BDecember 1, 2018 at 4:09 PM

    Hi i am Krishna Balan ,

    i want one help, My script is run well but i want my .fmb fil name as .fmx file name as output_file

    ReplyDelete
  23. YervandAugust 30, 2019 at 3:50 AM

    Anyway to compile the forms remotely? I am running the same command using Powershell with enabled Remote to the Server, but doesn't seem to do anything. However, it works on the server itself.

    Thanks

    ReplyDelete
  24. NguyenSeptember 19, 2023 at 12:21 AM

    "You need to write a script on the operating system to call "frmcmp" executable."
    Everything else below this sentence was well explained in detail except this sentence...sigh. What is the script? why not listed out?

    ReplyDelete

Subscribe to: Post Comments (Atom)