Thursday, 18 April 2013

A Simple and easy steps to Create New Custom Form Oracle Applications



A Simple and easy steps to

Create New Custom Form Oracle Applications


---------------------------------------------------------------------------------------------------------------
Oracle Applications
Simple and easy steps to Create New Custom Form Oracle Applications
A beginner’s guide  to Create New Custom Form Oracle Applications


Custom form creation
  1. This is Oracle forms navigation panel after opening TEMPLETE.fmb in it.
  2. Click on the data block
  3. Delete BLOCKNAME and DETAILBLOCK from it   
  4. Now click on Windows
  5. Add new window by clicking +
  6. Window will appear like this (with added window)
  7. Go to the properties of window (press F4 or right click à properties)
  8. Change subclass information (click on the property class radio button)
  9. Now go to triggers
  10. Click on the PRE-FORM
  11. Change BLOCKNAME to <your block name> i.e. Window name that you  have difined
  12.  defined window name
  13. Now press compile
  14. Click on the Program Units
  15.  Go to APP_CUSTOM (Package Body) and change <your first window > to defined window then compile  
  16. Now to go to Data Blocks and create new data block by (+) and choose wizard method
  17. Press Next
  18. Choose table or view and Press Next
  19. Search table and add columns then Press Next 
  20. Click next (till final window) click on Finish Now
  21. That wizard is followed by layout wizard click next  
  22. Select (new canvas) then Press Next
  23. Select columns then Press Next
  24. Select Tabular button then Click next
  25.  Set Title and Number of record to display
  26. Click to Finish
  27.  Now Adjust layout 


No comments:

Post a Comment