Friday, July 15, 2016

Create New Custom Form Oracle Applications

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
This is Oracle forms navigation panel after opening TEMPLETE.fmb in it.
Click on the data block


Delete BLOCKNAME and DETAILBLOCK from it   

Now click on Windows
Add new window by clicking +
Window will appear like this (with added window)
Go to the properties of window (press F4 or right click à properties)
Change subclass information (click on the property class radio button)
Now go to triggers
Click on the PRE-FORM
Change BLOCKNAME to <your block name> i.e. Window name that you  have difined
 defined window name
Now press compile
Click on the Program Units
 Go to APP_CUSTOM (Package Body) and change <your first window > to defined window then compile  
Now to go to Data Blocks and create new data block by (+) and choose wizard method
Press Next
Choose table or view and Press Next
Search table and add columns then Press Next 
Click next (till final window) click on Finish Now
That wizard is followed by layout wizard click next  
Select (new canvas) then Press Next
Select columns then Press Next
Select Tabular button then Click next
 Set Title and Number of record to display
Click to Finish
 Now Adjust layout 


---------------------------------------------------------------------------------------------------------------
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
This is Oracle forms navigation panel after opening TEMPLETE.fmb in it.

Click on the data block
Delete BLOCKNAME and DETAILBLOCK from it   
Now click on Windows
Add new window by clicking +
Window will appear like this (with added window)
Go to the properties of window (press F4 or right click à properties)
Change subclass information (click on the property class radio button)
Now go to triggers
Click on the PRE-FORM
Change BLOCKNAME to <your block name> i.e. Window name that you  have difined
 defined window name
Now press compile
Click on the Program Units
 Go to APP_CUSTOM (Package Body) and change <your first window > to defined window then compile  
Now to go to Data Blocks and create new data block by (+) and choose wizard method
Press Next
Choose table or view and Press Next
Search table and add columns then Press Next 
Click next (till final window) click on Finish Now
That wizard is followed by layout wizard click next  
Select (new canvas) then Press Next
Select columns then Press Next
Select Tabular button then Click next
 Set Title and Number of record to display
Click to Finish
 Now Adjust layout 



No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...