Friday, 27 January 2017

D2K Forms

Steps to Develop Custom Form in APPS
  1. Copy TEMPLATE.fmb from $AU_TOP/forms/US, rename and open it on Forms Builder.
  2. Click on the data block
  3. Delete BLOCKNAME and DETAILBLOCK from it 
  4. Now click on Windows.
  5. Add new window.
  6. Go to the properties of window (press F4)
  7. Change subclass information (click on the property class radio button)
  8. Now go to triggers
  9. Click on the PRE-FORM
  10. Change BLOCKNAME to i.e. Window name that you have defined and compile.
  11. Click on the Program Units
  12. Go to APP_CUSTOM (Package Body) and change to defined window then compile 
  13. Now build DataBlocks and Canvas as desired.


Open "Oracle Form Builder":



File -> Open [Ctrl+O] and select 'TEMPLATE.fmb' :


File -> Save As "MY_FIRST_FORM.fmb".

Rename TEMPLATE (say MY_FORM) :



Now, select MY_FORM and press F4.
/* wrong step: Update 'Subclass Information' to WINDOW :


*/

Forms -> MY_FORM -> Triggers -> WHEN_NEW_FORM_INSTANCE -> F4 -> Trigger Text :
Replace TEMPLATE.fmb to MY_FORM.fmb


Select the 'Windows' and click on green-plus icon to create new window:


Now, rename it to XX_WIN.
Update 'Subclass Information' to WINDOW

In the same way, create a Canvas and rename it to XX_CANVAS.


now press F4 and set its properties :


Now, select


press F4 :

Replace "if (wnd = '<your first window>')" with "if (wnd = 'XX_WIN')" :


Now select 'Pre-Form':


Press F4 and update 'Trigger Text':
Replace "app_window.set_window_position('BLOCKNAME', 'FIRST_WINDOW');" with "app_window.set_window_position('XX_WIN', 'FIRST_WINDOW');"



Forms -> MY_FORM -> Data Blocks -> Click on 'Green +' icon -> Use the Data Block Wizard -> Next -> Table or View -> Select Table & Columns -> Next -> Data Block Name : EMP_XT -> Create the data block, then call the Layout Wizard -> Finish

Layout Wizard will appear:






Select the layout style for your frame by clicking a redio button below -> Form ->




To open again this "Layout" window, double click on XX_CANVAS:




Make sure, each item has subclass "TEXT_ITEM":


Login to putty.

Come to the path of .fmb file location.

cd /d01/oraapps/apps/apps_st/appl/au/12.0.0/forms/US

frmcmp_batch module=/d01/oraapps/apps/apps_st/appl/au/12.0.0/forms/US/MY_FIRST_FORM.fmb  userid=apps/summer13 output_file=/d01/oraapps/apps/apps_st/appl/mls/12.0.0/forms/US/MY_FIRST_FORM.fmx module_type=form batch=no compile_all=special

or from WinSCP:
Go to the path of .fmb file location.
In MNEU list of WinSCP: Commands -> Open Terminal (Ctrl + T)
Enter Command:
frmcmp_batch module=XXCNS_CFORM_LEGACY_DATA_UPDT.fmb userid=apps/t0mahawk5 output_file=$AR_TOP/forms/US/XXCNS_CFORM_LEGACY_DATA_UPDT.fmx module_type=form
Click on 'Execute' button.

Note: Here $AR_TOP is the TOP of application of 'FORM'.



No comments:

Post a Comment