Oracle Apps Forms FAQ

Code
exit_form(no_validate);
OR
BEGIN
do_key(exit_form);
END;

exit_form;

We have to develop interface program and if you are not using SCM application or wms app you have to develop a custom form with custom table based on requirement to join this table to existing tables.

By using Execution Hierarchy we change triggering firing sequence

Execution Hierarchy contains three values

1. override
2. before
3. after

Default is: override

Depending on our requirement we can change either before or after.

Forms triggers used to fire in forms itself for enduser validations.
where as database triggers are created on table and whenever we perform dml operation on table automatically will fire trigger.

By using Zoom function in custom.pll

Forms 6i is a client server based and Forms 10g is an web server based application.

Go to property palletee of the Menu module
There you will find some thing like DEFAULT&SMARTBAR for MenuModule
Remove it and give the path of your Menu(.mmx)

You can use the below API function to execute the files from forms6i.

Win_api_shell.winexec('C:/Program Files/Microsoft Office/OFFICE11/winword.exe c:/temp1.doc');

Writes data in the form to the database, but does not perform a database commit. Form Builder first validates the form. If there are changes to post to the database, for each block in the form Form Builder writes deletes, inserts, and updates to the database.

compile the form from $AU_TOP and then move the fmx to ur custom TOP.

Delete the fmx from the Custom directory and then recompile a new copy to the location. I have encountered when I tried to copy the form to the Custom directory, while the form was still open by some ...

Form customization basically means mapping the requirements of your client's business with oracle by building forms( apart from oracle forms).Now,there are many tools available for building these ...

Customization is the process of Modifying the Standard in oracle apps as per the business application or client requirement .there are two methods of form customization1. customization by modificat...