Monday, 27 July 2015

Steps for Developing an Oracle Form

Steps for Developing an Oracle Form

  •      Create/Use a table on which you want to have the form data stored.

                     Example: Create Table XX_SUPPLIER_INFO with the following columns.

                     CREATE TABLE XX_SUPPLIER_INFO

                     SUPPLIER_NAME    VARCHAR2(100),                     ADDRESS         VARCHAR2(100),
                     PHONE_NUM       NUMBER,
                     FAX             VARCHAR2(50),
                     EMAIL           VARCHAR2(50),

  •      Open Form builder à File à Connect.
              Connect to database.

  •    Open template.fmb file (You can find in $AU_TOP/forms/US)
  •     Click on Template and press F4 to change the name of module.
                   Example: XXSUPPLIER.

  •     In Object Navigator Right click on Data Blocks à Data Block Wizard à Next à Select Table or view à Next à Give table name (Example: XX_SUPPLIER_INFO) and tab out.
  •    List of columns will appear, move them to database items(right side) à next à next à Give data block name XXSUPPLIER à Next à Click on just create the data block à Finish.
  •   Data block XXSUPPLIER will be created. Press F4 on XXSUPPLIER to open property palette and assign subclass information as follows.

  •   For each column in data block provide the subclass information as below.

  •      Create a new canvas. Example: XXSUPPLIER and give subclass information as CANVAS.

  •      Create a new window by giving the above canvas and subclass information.

  •     Double click on XXSUPPLIER canvas, a layout will open, place a frame in the layout and  press F4 on frame and give the following information. (This can be performed by the data wizard while creating the data block also)

Subclass information: FRAME_RECT
Layout Data Block: XXSUPPLIER
Layout Style: Tabular
Number of Records to be displayed: 4

  •      Go to each item in Data block and give the canvas as XXSUPPLIER.

  •        Now arrange the fields in the layout accordingly.

  •   Press F4 on XXSUPPLIER canvas and give window as XXSUPPLIER.

  •                 Press F4 on XXSUPPLIER module and give first navigation data block as                   XXSUPPLIER.

  •    Go to PRE FORM trigger and give the set_window_position as XXSUPPLIER.

  •    Go to APP_CUSTOM package body and give if (wnd = 'XXSUPPLIER') then

  •    Now save the form as XXSUPPLIER.fmb and move it to application_top/form/us folder.
  •   Compile the form using the code

frmcmp_batch module=<Folder Path> /XXSUPPLIER.fmb userid=apps/<pwd> output_file=<application top>/forms/US/XXSUPPLIER.fmx module_type=form batch=yes compile_all=special

  •    Once the form is successfully compiled we will get XXSUPPLIER.fmx otherwise if any error occurs it will be mentioned in XXSUPPLIER.err
  •   Create a Form in oracle Application. Go to Application Developer à Application à Form

  •  Create a Function Go to Application à Function

  •    Assign it to a Menu. System Administrator responsibility à Application à Menu

  •    Go to that responsibility and open the form and we can enter the details and save and it will reflect in XX_SUPPLIER_INFO table.

No comments:

Post a Comment