Infolinks

Monday 13 May 2013

APPS FORM CREATION USING (TEMPLATE.fmb)


   ******* APPS FORM CREATION USING (TEMPLATE.fmb) ********

--> Befor going to create form we need to know some deffrens is there in between Narmal D2K Form & Apps Form
      t.e
          --> Narmal D2k Forms are Directly we can Create but we con't Register in Apps.
          --> But in Apps Form We can register in Oracle Apps by using the Bellow steps.( Using TEMPLATE.fmb)

-->1. First we need to create Custom (our own) Directory of Oracle Apps Forms.

      Ex: D:\FORM_10g_PLL

-->2. And then we need to Copy some files like (.FMB,.PLL) File and Paste in Custom (Our Own) Direcory of D:\FORM_10g_PLL
  
      That files are : AU--Top,  forms, Resources Folders

      Ex: D:\oracle\VIS\apps\apps_st\appl\au\12.0.0\forms\US

      Note: Hear we need to copy the files are    (TEMPLATE.fmb , APPSTAND.fmb)

---> And paste into the Custom (Our Own) directory of D:\FORM_10g_PLL

-->3. And then we need to Copy the file are pll (resource-All Folder)

      Ex: D:\oracle\VIS\apps\apps_st\appl\au\12.0.0\resource

      Note: Hear We need to copy the All Files to the Custom (Our Own) Directory of D:\FORM_10g_PLL

-->4.And the we need to set the Path of Custom (Our Own) Directory ,
      Note: Hear we need Add our custom directory to the Existing  directory.
       
        Ex Nov:- Got the RUN--> need to type as (regedit) and then click on ok

                                       --> Hear we need to Seclect HKEY_LOCAL_MEACHINE
                                       --> And then Select to open SOFTWARE
                           --> And then Select to open ORACLE
                                       --> And then Select to open HOME /HOME0, HOME1
                                       --> And then find to Openn the file name as FORM90_PATH ( D2k 10g version)
                                        FORM60_PATH ( D2k 6i version)
-->5.And then we need to Add our Custom Directory to the existing Directories

     EX: D:\develope\cgenf61\admin;D:\develope\forms90;D:\FORM_10g_PLL

--> So our path is Created

--> And we need Creat a form by using TEMPLATE.fmb ( in our Custo Directory of D:\FORM_10g_PLL)

APPS FORM CREATION USING WIZARD METHOD:
=============================

--> Open the Form Builder

 --> Hear we need creat form by selecting the Form Using Tempalte

       Ex: Nav:--> File-->New-->Form Using Tempalte

     Note: Hear we need to Brows to open  TEMPLATE.fmb ( in our Custo Directory of D:\FORM_10g_PLL)

Note: These Error means

         i am not currect file to copy the custom directory
        
         APSTAND.fmb( This is not our file)
         APPSTAND.fmb( This is our file)
   
    --> so i need to Replace this file then we can avoid the Error
                           
---> Now we Can Open the file TEMPLATE.fmb

Note: Now we Need To Delete the BLOCKS( Existing) in that Form

---> And Then We Need to Create (Data Block, Canvas, Window)

WINDOW CREATION:
=============

--> Create a new window by selectin Create button(+)
--> And Open property pallet(F4) for seting the properties

     Ex: General:
                      Name: APPS_WIZ_W
CANVAS CREATION:
=============
--> Create a new Canvas by selectin Create button(+)
--> And Open property pallet(F4) for seting the properties

Ex: General:
                      Name: APPS_WIZ_C

Note:  Attach WINDOWS to CANVAS & CANVAS to WINDOWS
=====================================

--> Go to The Property Palette(F4)  of CANVAS (APPS_WIZ_C)
    
       Physical:
                   Window: APPS_WIZ_W


--> Go to The Property Palette(F4)  of WINDOW (APPS_WIZ_W)
    
       Functional:
                   Primary Canvas: APPS_WIZ_C


DATA BLOCK CREATION:
===============
--> Create a new Data Block by selectin Create button(+)
--> Then Select tha Use The Data Block Wizard and Click on Ok Button
--> (Display the page next time) Click on Next-->(Table or View) Click on Next--> Type the Table         Name(Ex: PO_HEADERS_ALL) and Click on Refresh Button and Connect to The Data Bace (User Name: apps,         Password: apps, Database: vis)

--> Then Move The Available Columns to Database items And Click on Next-->Next-->(Hear we can edit the Data        Block Name) Click on Next-->Finish--> Click on Next-->
    (LAYOUT MODEL CREATION)--> Hear we can Select our Created CANVAS ( No need to        select , Defoult it will     Shows-->Next--> Hear we need to Move The Available items to Displayed        items-->Next-->Next-->Hear we     can select Form/Tabular (Form) -->Next--Hear we can give the Form Title-->Next-->Finish

--> Then we need to Save(.fmb) & Compile(Ctrl+T) the Form

       Ex: APPS_PO_WIZ_FORM.fmb

--> Note: When ever Compile the Form the (.fmx) will be Created automatically

--> Form is Created     

         

******* FORM REGISTRATION PROCESS ************


--> After Creation of the Form by using (TEMPLATE.fmb)

--> Then we need to Move (.fmb) File in " au-Top or po-Top "

       Ex: au-Top: D:\oracle\VIS\apps\apps_st\appl\au\12.0.0\forms\US

--> Then we need to Move (.fmx) File in " po-Top" (Perticular Resp) Only

       Ex: po-Top: D:\oracle\VIS\apps\apps_st\appl\po\12.0.0\forms\US


--> Login to Oracle Applications

                      operations
                      welcome

--> Form Registering:
      ===========
--> Nav: Application Developer (Responsibilty)--> Application-->Form

--> Hear we need to give

      Ex:   Form                                                    Application    User Form Name                                     
             ======                                              =======    ===========
             APPS_PO_WIZ_FORM ( File name(.fmb))      Purchasing    Apps Po Wiz Form  ( Display the Front End Apps)

--> Save it and Close Form

--> Function Registering:
      =============
--> Nav: Application Developer (Responsibilty)--> Application-->Function

      Ex: Function                        User Function Name  
           ======                       =============   
           APPS_PO_WIZ_FORM ( File name(.fmb))  APPS_PO_WIZ_FORM_FUNC (our wish)
       
           --> Go to the [Properties]  Tab in that same Function

           --> Hear we need to select Type asForm

                      Ex: Type: Form

           --> Go to the [Form] Tab in that same Function

           --> Hear we need to Brow & select our Form Name ( Display the Front End Apps)
  
                      Ex: Form: Apps Po Wiz Form (    User Form Name )

--> Save it and Close the Form Function

Attach "Function to Menu":
=================

--> Go to Nav: Application Developer (Responsibilty)--> Application--> Menu

Note: Hear we need to Get The ' Menu Name  ' of the PO( Perticular ) Responsibility from the Responsibility Window

       Nav: Switch to System Administrator (Responsibilty) -->Security-->Responsibility-->Define

             Hear to give our PO( Perticular ) Responsibility Name using F11 and Ctrl F11  or Find it

              Ex: Responsibility Name: Purchasing, Vision Communications (USA)

              --> And then we can get the Menu Name
 
              Ex: Menu: Purchasing SuperUser GUI

--> After geting the Menu name close the Responsibility Window & Swtch to the Application Developer(Responsibilty)
      --> Go to Nav: Application Developer (Responsibilty)--> Application--> Menu

      --> And enter to find the Menu name, using F11 and Ctrl F11  or Find it

                     Ex: Menu: Purchasing SuperUser GUI

      --> And the To add the (seq no , Prompt, Function Name) to end of the Existing Menus
         
            Ex: seq:702  Prompt: APPS_WIZ_PO_FORM Function: APPS_PO_WIZ_FORM_FUNC ( Brows our User Function                  Name)

--> Save it & Close the Menus form

--> And Switc to the Purchasing, Vision Communications (USA) Responsibilities

--> Go to End of the Navigator of PO Resp  And Click on to open the out put of our Form

***--> So the Error will come Becouse of we need set some properties in the Form Builder and Over Come This           Problem

Note: To set The 4 Tasks in Form Builder

         t.i.  1. Subclass information
               2. Change tha Properties of Form
               3. PRE-FORM
               4. APPS Custom Package Body
Note: 4the step is Common in every ware in form we need to provide.

1.Subclass information
===============
Note: 1.This Subclass information we need to set in (Data Block, Items , Convas, Window)
         2. When ever to set the Subclass information that file is Changed to Red color


--> Go to Set the bellow navigation And set Subclass information

Data Block Level:
---------------
-->  Go to Select-->Data Block-->Property palette of (F4) (PO_HEADERS_ALL)

        -->select the (*)Property Class
        -->Property Class Name: BLOCK
        -->Module: APPS_PO_WIZ_FORM ( Form Name)

--> Click on Ok

Items Level:
----------
--> Go to select--> Items( Like Item1)-->Property palette of (F4) of Item1

           Ex: PO_HEADER_ID

        -->select the (*)Property Class
        -->Property Class Name: Text_Item
        -->Module: APPS_PO_WIZ_FORM ( Form Name)

Note: Set the properties of All The Available Items like Above Ex.

Canvas Level:
------------
--> Go to select-->Canvas-->Property palette of (F4)(APPS_WIZ_C)

        -->select the (*)Property Class
        -->Property Class Name: Canvas
        -->Module: APPS_PO_WIZ_FORM ( Form Name)

Widow Level:
-----------
--> Go to select-->Windows-->Property palette of (F4)(APPS_WIZ_W)


        -->select the (*)Property Class
        -->Property Class Name: Window
        -->Module: APPS_PO_WIZ_FORM ( Form Name)

2. Change tha Properties of Form:
======================

--> Go to the Property Palette(F4)  of Form Leve

      Ex: FORM-->APPS_PO_WIZ_FORM(Form Name)

          Navigation:
        First Navigation Data Block: PO_HEADERS_ALL (Data Block Name)

3. PRE-FORM:
=========

--> Go to the PRE-FORM of Form Level Trigger

      NaV: Trigger( Under the Form)-->PRE-FORM--F11(To open the Pl/sql Editor) and set the bellow

Note:
===    FND_STANDARD.FORM_INFO('$Revision: 120.0                                                                                                                                              $', 'Template Form', 'FND',
                       '$Date: 2005/05/06 23:25  $', '$Author: appldev $');
          app_standard.event('PRE-FORM');
          app_window.set_window_position('BLOCKNAME', 'FIRST_WINDOW');----> Need To Change This Line Only

---> above code is Defoult , just we need to Replace the ('BLOCKNAME'(Data Block name)  , 'FIRST_WINDOW' Window         name )

---> 'FIRST_WINDOW'  Window name is Optional No Need to Replace

---> Need to Replace the BLOCKNAME to PO_HEADERS_ALL(Data Block name)

   Ex: app_window.set_window_position('BLOCKNAME', 'FIRST_WINDOW'); (Default)

        app_window.set_window_position('PO_HEADERS_ALL', 'FIRST_WINDOW');---Yes


--> Compile it ( Ctrl+T)

4. APPS Custom Package Body:
===================

-->Go to Select the " Program Units" in Form Builder
--> And then to  Select the APP_CUSTOM (Package Body)-->Go to the Pl/Sql Editor
--> Hear we need to set the Window name in if Condition

--> The bellow Code is Defoult in APP_CUSTOM (Package Body)

--> In bellow condition we need to replace as( your first window to APPS_WIZ_W(Window name) )

         if (wnd = '<your first window>') then ----> Need To Chang This Line Only
    app_window.close_first_window;
  elsif (wnd = '<another window>') then
    --defer relations
    --close related windows  
    null; 
  elsif (wnd = '<yet another window>') then
    --defer relations
    --close related windows  
    null;
  end if;

--> Then we need to Save & Compile (Ctrl+T) it

--> Then Login To the Oracle Application -->

--> And Switch to the Purchasing, Vision Communications (USA) Responsibilities

--> Go to End of the Navigator of PO Resp  And Click on to open the out put of our Form

Note: Form is Successfully Registered Here  we Can manupulate the DML Opertaions.
 

2 comments:

  1. Great Stuff. Very clear. Created my first form in one hour. Thanks for the post :-)

    ReplyDelete