Learn Oracle Database and Applications Here

How to Develop Oracle Form for Oracle E-Business Suite?

As an Oracle E-Business Suite technical developer, you might have got chances to customize or develop Oracle Forms from scratch. Many people say so that Oracle Forms is an obsolete application looking forward to futuristic technologies Oracle Corporation is launching. But I would say, for the organizations to implement these new technologies, it will take considerable amount of time and training. Keeping that in mind we can say that Oracle Forms will still exist for decade or more.

To carry out development in Oracle forms is reasonably interesting and quite simple task. But before you start development, you must follow some prerequisite steps to make it well-suited with Oracle E-Business Suite.

Change <first_window> to the name of the window you have created. Keep single quotes as it is.

Once you feel your form is ready, time has come to move and compile your form.

Move and Compile Oracle Forms

Make sure to fully compile your form before moving it to your development or vision instance.

Shift + Ctrl + Kis the command to do full compilation of the form on your standalone machine. You can also compile from Oracle forms directly by going from Program -> Compile PL/SQL -> All.

FTP the form to desired path using PUTTY or WinSCP in binary mode.

Usually the path will be like $XXPO_TOP/forms/US where $XXPO_TOP is custom PO top. Most of developers prefer to keep their .fmb file in /forms/US path of the respective custom application. You can change the path as you wish.

Note: Set the environment file if in PUTTY to access your custom top. Ask your DBA whether you need to set environment file or it is automatically after the login.

Change the permission of your .fmb file to 777 or 755

WinSCP: Right click on the file and change permission to 777 or 755

PUTTY: chmod 755 yourform.fmb

Compile Oracle Forms

Go to path $AU_TOP/forms/US

If you are working on Oracle Applications R12 the compile command will be

Thanks for stopping by at OracleMine.com. Speaking about my brief introduction, I work for a multinational organisation in Oracle related technologies. Being an avid blogger, I would like to inform you about my productivity and motivational blog XpressPlanet.com. Speaking of OracleMine.com, I will try my best to share knowledge on technologies in as simple and understandable manner as possible. You can also contribute your knowledge on OracleMine by writing to us at hioraclemine@gmail.com. Again I appreciate your visit. Hope to see you again and again!